19 September 2023 by mwd
DBA Resources
Useful resources For SQL Server DBAs
There are a few scripts to be found in my github repository. The stored procs can help locate useful information on a SQL Server Database Server.
Additionally there are numerous websites out there offering advice and scripts to the SQL Server DBA. Some that I have found to be useful are listed below :
- Who Is Active
- Adam Mechanic’s essential addition to sp_who2 to show the current active processes.
- Brent Ozar’s First Responder Kit
- An Invaluable set of scripts for gathering diagnostic data.
- See also the extensive blog posts on the site.
- Ola Hallengren’s Maintenance solution
- A SQL Server Maintenance Solution that is quick to get up and running !
- I don’t know a quicker way to set up a backup solution , but be wary when enabling the indexing jobs without tweaking the parameters.
- Glenn Barry’s SQL Performance Script
- A number of diagnostic queries to dig deep into your DB Server’s configuration and Performance.
- SQL Undercover
- sp_RestoreScript is a very handy resource to generate DB restore commands.
- many other scripts in a github repository - see also the blog posts.
tags: sql