TSQL 'Tools' I use
Daily:
- sp_WhoIsActive:
If you are using sp_who or sp_who2 you are doing it wrong. - SQL Server Maintenance Solution scripts from Ola Hallengren
Database Integrity Checks, Backups and index optimization covered.
Ad-hoc:
- sp_Blitz:
Get it, run it. Covers a whole host of health checks. - sp_SQLskills_SQL2008_finddupes:
Find and remove those duplicate indexes. - SQL Server Diagnostic Information Queries:
I use these to audit SQL Servers and Databases.
Comments