Useful DBA tools

This is probably one of the posts that never will be completed, as the tools I use change over time. However at the moment this is an overview of the tools I use and how to find them.

DBA ToolsCommunity driven SQL Server PowerShell module, which continously gets more functions and features.
Ola Hallengren
Maintenance Solution
The maintenance tool to help you automate the maintenance you absolutely need!
sp_WhoIsActiveA comprehensive activity monitoring sp, which is a helpful troubleshooting partner.
Created by Adam Machanic
sp_BlitzDiscover your database servers possibilities for improvement.
Created by Brent Ozar
SQL Server
Diagnostic Queries
Magnificent DMV Queries which will provide you with information you did not even thought you wanted.
Created by Glenn Berry
DBAChecksYou probably need to validate your environment, and this is a good tool for it.
SQL Server
Management Studio
Perhaps a given, but it is the main tool used by most DBAs I would recon.
Azure Data StudioAzure Data Studio (previously SQL Server Operations Studio), a tool focusing on getting an overview and documenting stuff.
Microsoft Update CatalogGood to have should you need to patch servers offline.
Execution Plan ReferenceSQL Server Execution Plan Reference
Created by Hugo Kornelis
Wait TypesSQL Server Wait Types Library
Created by SQLSkills
Latch ClassesSQL Server Latch Classes Library
Created by SQLSkills

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s