sp_CheckTempdb

Accelerated Database Recovery in SQL Server 2025

by
Accelerated Database Recovery in SQL Server 2025

Accelerated Database Recovery (ADR) was introduced in SQL Server 2019. Its main purpose is to allow for faster database recovery in the event of a crash or unexpected shutdown. Traditionally, the database engine handles crash recovery through a series of phases—analysis, redo, and undo—which can be inefficient and slow, especially when dealing with long-running transactions. … Read more

Introducing sp_CheckTempdb: Check Your SQL Server tempdb for Performance Issues

by
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