Useful scripts and jobs to make life as a part-time SQL Server DBA easier.
- sp_whoIsActive by Adam Machanic
- DatabaseIntegrityCheck by Ola Hallengren
- IndexOptimize by Ola Hallengren
- sp_Blitz by Brent Ozar
- sp_BlitzCache by Brent Ozar
- sp_BlitzIndex by Brent Ozar
- sp_EasyButton by Pim Brouwers
To install in a database other than
master
, simply change Line 1 ofinstall.sql
Download and run install.sql
, then sit back and relax.
This will install the scripts list above in the master
database. The following SQL Agent Jobs will also be installed:
DBA_CHECKDB
: RunCHECKDB
on all databases - weekly (Sunday).DBA_CYCLELOGS
: Cycle log and error log files - daily (midnight).DBA_REBUILDINDEXES
: Rebuild indexes on all user databases - weekly (Saturday).DBA_STATISTICS
: Update statistics on all user databases - daily (midnight).DBA_WAITSTATS
: Capture a snapshot of server wait statistics - daily (midnight).DBA_WHOISACTIVE
: Capture a snapshot ofsp_whoIsActive
- 60sDBA_PURGEHISTORY
: Purgemsdb
backup & job history of data older than 60 days - daily (midnight).
All jobs are created in the disabled state and must be enabled.
There's an issue for that.
Built with โฅ by NHLPA Engineering in Toronto, ON. Licensed under MIT.