SQL Server Performance Enhancement - miniDBA

miniDBA is designed to maximize potential performance in your SQL Servers. Gain performance from tooling that addresses; server configuration, T-SQL tuning, performance alerting & historic performance trend analysis. If left unaddressed these areas will cause your server/application to run at a fraction of the speed & reliability it could do.
SQL Server Healthcheck

Server Configuration

  • Run over 50 diagnostic checks at server & database level with 1 click
  • Be warned of configuration/setup problems that will decrease performance
  • File configuration (using the system drive & tempdb file number) warnings + IO throughput speed data
  • Memory & CPU configuration problems can be identified using the built in graphical views

sql server performance tuning

T-SQL Tuning

  • Having SQL statements that are logically correct is only half way to maximising your SQL Server performance
  • Performance tuning SQL statements is essential for any non-trivial batches and can enhance performance almost beyond recognition
  • See every cached sql statement and its usage data - execution count, execution time, reads, writes and more...
  • Identify slowest performing sql statements instantly & what they were doing (cpu, reading, writing)
  • Graphical dashboards enable you to see what T-SQL is doing with memory, cpu and IO at server and database level
  • Healthchecks include T-SQL analysis: query hints, maxdop, sarg-ability, wildcards, parameterization, execsql use & more all analysed
SQL Server Alerts

Performance Alerting

  • Your SQL Server performance will degrade over time unless appropriate maintenance jobs are implemented
  • Get alerted to performance falling below configurable thresholds so performance is not sub-optimal without you knowing about it
  • 24*7 Performance monitoring acheived by miniDBA Server enables you to have full confidence your server is running well

sql server performance history

Analyse History

  • Sampled SQL Server Performance data is stored and can be viewed in the History Viewer: SQL Server performance counters, wait statistics, deadlocks & T-Sql are all available for performance analysis
  • Review historic saved data to see performance trending over time & areas that are degrading
  • See saved T-SQL blocking and deadlocks here enables you to fix these performance bottlenecks
  • Monitor data is written to an internal database - no need to setup & license a logging database

Versions Supported

SQL Server 2005 -> 2017

Permission Requirements

High level permissions such as SA or DBO are not necessary - just public role or VIEW SERVER STATE