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. The report includes, among other items:
- SQL Server health checks
- Performance diagnostics
- Query analysis
- Deadlock investigation
- Azure SQL DB support
- Cross-platform compatibility
for this section we will use it to generate report in html and and check deadlock section
How to use PSBlitz
go to following website https://github.com/VladDBA/PSBlitz/releases?tab=readme-ov-file and download latest PSBlitz
now open powershell AS administrator and change your directory to PSBlitz i have place the folder in C drive .
then run the follwoing command
Unblock-File .\PSBlitz.ps1 |
to start it rub the below command
.\PSBlitz.ps1 |
When you run PSBlitz, it prompts you for the essentials—server IP/hostname, login credentials, your preferred output (HTML or Excel), and other options. Pick what you need, and it generates the report.
one done you will find zip file containing the report
lets open the html file and check the report , you will find report is divided to deferent section lets check deadlock information report.
The report shows each deadlock, the database it occurred in, the objects involved, and concrete remediation suggestions.
you can click on jump to deadlock details to check execution plan for query
the deadlock report can show the deadlock execution plan and which object got the blocked by both side , it will help you analyze the issue in terms of selecting better isolation level, optimising the query by checking query execution plan .
for more information on how to use PSBlitz. check the following website https://github.com/VladDBA/PSBlitz