Skip to content

RootDBA

DBA expertise: PostgreSQL, SQL Server & MySQL

Menu
  • Home
  • blog
  • PostgreSql
  • MySql
  • Sql Server
  • About AHMED – Root DBA
Menu

deadlock Buster

Hunting SQL Server Deadlocks with PSBlitz (by VladDBA)

Posted on September 14, 2025 by AHMED

Welcome back to the Deadlock Buster series. Today we’re looking at PSBlitz, a PowerShell tool by Vlad Drumea. PSBlitz runs Brent Ozar’s SQL Server First Responder Kit under the hood to generate a comprehensive SQL Server health report. It’s fast, practical, and built for DBAs who want signal over noise. You can export the results to HTML or Excel for easy review and sharing….

Read more
Deadlocks

How to Capture SQL Server Deadlocks Using Extended Events

Posted on September 9, 2025 by AHMED

Deadlocks are one of the worst scenarios a DBA will face. They happen when two sessions are fighting for resources and each one is holding a lock the other needs. At that point, the SQL Server engine will choose one session to kill — this is called the deadlock victim. The reality is you cannot eliminate…

Read more
© 2025 RootDBA | Powered by Minimalist Blog WordPress Theme