Introducing sp_CheckTempdb: Check Your SQL Server tempdb for Performance Issues

Free SQL Server DBA tool - sp_CheckTempdb

Most database folks might know the tempdb database in SQL Server is used for temporary tables, but many folks don’t realize all the other things that use this critical system database. It’s also used by table variables, cursors, aggregations, joins, and sorts. And by memory spills when you don’t have enough memory. And by integrity … Read more

Introducing sp_CheckBackup: Check Your SQL Server Backups for Recoverability Issues

SQL Server database backup tool for checking recoverability issues

Whether you are backing up your SQL Server databases with Ola Hallengren’s scripts, Maintenance Plans, or some third-party software, your backups are your lifeline for recovering your data in case of a disaster. So…are your databases recoverable? Do you know WHERE your most recent backups were written? Do you know WHEN they were written? Did … Read more