What SQL Server Performance & Management Tools Do I Use?

Published On: 2019-09-04By:

Several times I’ve been asked what tools are in my performance tuning and SQL Server management arsenal, so I decided to just create this blog to list them out for you. Keep in mind, these are ones I personally use. There are many more out there that the community uses. Feel free to comment with any you may use that is not on my list.

Community Tools (Free)


Ola Hallengren’s Maintenance Scripts- Index Maintenance, Integrity and Backup Scripts https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html


Glenn Berry’s Diagnostic Scripts -Various scripts based on DMVs to extract SQL Performance statistics and information  https://www.sqlskills.com/blogs/glenn/category/dmv-queries/


Adam Machanic sp_WhoIsActive See what is currently going on in SQL Server similar to sp_who2 http://whoisactive.com/


Dbatools– PowerShell modules https://dbatools.io/


Tiger Team Toolbox – Various Tools for diving into SQL performance via Github https://github.com/microsoft/tigertoolbox


PSSDiag – is a general-purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files https://support.microsoft.com/en-us/help/830232/pssdiag-data-collection-utility


SQL Nexus– Used to analyze PSSDiag results https://github.com/Microsoft/SqlNexus/wiki/Installation


Xperf– Windows performance tool kit https://docs.microsoft.com/en-us/windows-hardware/test/wpt/


CPU-z -See the effect of CPU power saving and see the immediate relief that comes from changing your power saving mode https://www.cpuid.com/softwares/cpu-z.html


Denny Cherry and Associates Github– Misc. collection of scripts https://github.com/DC-AC


Grafana– Open Source tool to graphically showcase your SQL Server performance metrics no matter where they are stored https://grafana.com/grafana/dashboards

3rd Party Tools


SentryOne Plan Explorer (FREE)– Enhanced way to review execution plans https://www.sentryone.com/plan-explorer


SentryOne SQL Sentry https://www.sentryone.com/products/sentryone-platform/sql-sentry/sql-server-performance-monitoring


Idera Diagnostic Manager https://www.idera.com/productssolutions/sqlserver/sqldiagnosticmanager


Redgate SQL Monitorhttps://www.red-gate.com/products/dba/sql-monitor/

Contact the Author | Contact DCAC


Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award    FT Americas’ Fastest Growing Companies 2020   
Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link