What SQL Server Performance And Management Tools Do I Use

In this article, you will learn about SQL Server Performance and Management Tools I use.

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
 
 
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
 
 
Xperf
 
 
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
 

Third-Party Tools

 
SentryOne Plan Explorer (FREE)
 
Enhanced way to review execution plans https://www.sentryone.com/plan-explorer
 
SentryOne SQL Sentry
 
 
Idera Diagnostic Manager
 
 
Redgate SQL Monitor