You need to troubleshoot performance problems with SQL Server ... GO EXEC sys.sp_configure N'blocked process threshold', 5; --Seconds RECONFIGURE; GO Set up the Extended Event: CREATE EVENT SESSION ...