What SQL Server Performance And Management Tools Do 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/
PowerShell modules https://dbatools.io/
Tiger Team Toolbox
Various Tools for diving into SQL performance via Github https://github.com/microsoft/tigertoolbox
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
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
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

Denny Cherry and Associates
Expert Consultants From HA to DR to up-time to SQL virtualization to scalability.