Subscribe to this blog
James' SQL Footprint
Love SQL Server, Love life.
Archives: October 2012
Monitor Blocking with Extented Events in SQL 2012
1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO
here we set the threshold to 10 seconds, which generating a blocked process report for each task that is blocked.
2. Create Extented…
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO
here we set the threshold to 10 seconds, which generating a blocked process report for each task that is blocked.
2. Create Extented…
0 comments, 370 reads
Posted in James' SQL Footprint on 29 October 2012