Accelerated Database Recovery in SQL Server 2025

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

7 Common SQL Server Transaction Log Myths

sql server transaction log myths

SQL Server is a complicated piece of software, so it’s understandable that some of us have some misconceptions about what the transaction log is and what it does. This post is designed to not just tell you about these myths, but also to show you a few ways how to prove (or rather disprove) some … Read more

5 common Problems to Troubleshoot with sp_WhoIsActive in SQL Server

Fix blocking, full logs, tempdb bloat, memory waits, and “what’s running now” in minutes with these five sp_WhoIsActive commands. Use this tool today to solve your own SQL Server issues. Need more help? We can help with our SQL Server Consulting services or our DBA services. 5 Common SQL Server Problems to Fix with sp_WhoIsActive … Read more