Blocked Process Reports: From Capture to Root Cause
Enable the blocked process threshold, capture blocked_process_report in Extended Events, and shred the XML into a blocker and blocked view.
From Deadlock Graph to Repeat Offender: A Production Extended Events Pipeline
Capture xml_deadlock_report in an Extended Events session, persist it past the ring buffer, and rank the repeat-offender procedures in T-SQL.
SSRS and Multi-Subnet Failover: The Connection String That Doesn’t Exist
SSRS has no way to specify MultiSubnetFailover=True in its ReportServer database connection. Here’s how to automate SSRS reconfiguration after an AG failover across subnets using rsconfig.exe, sp_update_jobstep, and a SQL Agent alert.
Statistics update job
SQL Server statistics are extremely important for good query performance since they provide invaluable guidelines that allow the query optimizer to pick an optimal plan. Out-of-date or non-existent statistics objects can cause excessive I/O, poor…
SQL Server Agent Job Activity
SQL Server Agent provides a graphical user interface to inspect the status of agent jobs. The Job Activity Monitor looks like: However, if you want to programmatically obtain the detail about running jobs, including details…