miniDBA - Designed to help SQL Server Developers

Performance tune T-SQL

  • miniDBA Desktop offers a wealth of tools for getting your T-SQL right first time:
  • Identify worst performing statements & causes (CPU, IO, memory, locks)
  • Index analysis - Live index usage, Fragmentation with the index heatmap & Unused\Recommended indexes
  • Wait statistics - See live view of current & total waits & associated wait type descriptions
  • Know instantly what resource SQL Server is waiting for when your T-SQL executes
  • Actual and estimated execution plans broken down and ranked by worst performing operator

See inside SQL Server

  • Highest resolution sampling on the market (every 2 seconds) enables a truly realtime development advantage
  • See what session is blocking plus the exact T-SQL statement it is running
  • See what is locking what other objects
  • See detailed metrics on how memory is being consumed
  • See exactly how each cpu core/scheduler is being used and identify processor pressure
  • See how each disk is performing and each file on that drive

Performance Health Checks

  • Run diagnostic checks of T-SQL and schema design:
  • Wildcard used to begin search
  • Unpartitioned Large Tables
  • MAXDOP used
  • Computed column not persisted
  • Slow IO - (disk problems)
  • Forced Parameterization Enabled
  • Disabled Indexes
  • Untrusted FK constraints
  • ...plus many more

Connect to new servers at any time

  • Don't wait for Administrators to grant you access to servers or tools - connect straight away
  • SA permission is not required to monitor a server - other tools require this but miniDBA is designed for non system administrators as well as DBAs
  • Settable refresh speed means you can connect to a Production server with no fear of putting load on it
  • Connect to SQL Servers either locally, anywhere on the network or in Virtual Machines
  • Use either Windows or SQL Server security when connecting

Extra Features - Enterprise Edition

  • Review historical performance data - know what happens when you aren't watching
  • Configure default alerts - be told when something in your environment crosses a defined performance boundary
  • Custom SQL alerts - write your own T-SQL query and be alerted when its results are not as expected
  • QA and UAT environments rarely have any monitoring or alerting but are full of usefull performance data - now you can make use of it with miniDBA