DBA In A Box

Useful scripts and jobs to make life as a part-time SQL Server DBA easier.

Scripts Included

• 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

Getting Started

To install in a database other than master, simply change Line 1 of install.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:

1. DBA_CHECKDB: Run CHECKDB on all databases - weekly (Sunday).
2. DBA_CYCLELOGS: Cycle log and error log files - daily (midnight).
3. DBA_REBUILDINDEXES: Rebuild indexes on all user databases - weekly (Saturday).
4. DBA_STATISTICS: Update statistics on all user databases - daily (midnight).
5. DBA_WAITSTATS: Capture a snapshot of server wait statistics - daily (midnight).
6. DBA_WHOISACTIVE: Capture a snapshot of sp_whoIsActive - 60s
7. DBA_PURGEHISTORY: Purge msdb backup & job history of data older than 60 days - daily (midnight).

All jobs are created in the disabled state and must be enabled.

Find a bug?

There's an issue for that.

License

Built with ♥ by NHLPA Engineering in Toronto, ON. Licensed under MIT.