Identify Blocked SQL Processes Quickly: Figure 3 Run the dba_BlockTracer Stored Procedure. -- Visual Studio Magazine

Identify Blocked SQL Processes Quickly: Figure 3 Run the dba_BlockTracer Stored Procedure.

This SQL code runs the dba_BlockTracer stored procedure. The output shows two grids; the first shows that the root-blocking spid is 86, and the second shows two blocked spids, 122 and 104. Both spid 104 and 122 are trying to select records from the tblCountry table.

05/28/2008

Identify Blocked SQL Processes Quickly: Figure 3 Run the dba_BlockTracer Stored Procedure.

Printable Format

comments powered by Disqus

Featured

VS Code 1.127 Further Integrates Advanced Browser-AI Tech

Microsoft's July 1 Visual Studio Code update continues a recent push to make the editor's integrated browser a more capable development surface -- and a more useful tool for AI agents.
Support Vector Regression with SGD Training Using C#

Support vector regression can predict numeric values effectively, and this article shows how to implement and train a kernel SVR model in C# using stochastic sub-gradient descent.
New GitHub Switch Limits Repo Issue Creation to Collaborators Only

After publicly touting pull request limits as a way to cut maintainer noise, GitHub is taking the same idea further with a new setting that lets repository admins restrict issue creation to collaborators only.
Uno Platform Helps Ship First Stable SkiaSharp 4.0 Release for 2D .NET Graphics

SkiaSharp 4.148.0 is the first stable v4 release, bringing a newer Skia engine, API cleanup, performance work and a Microsoft-Uno co-maintenance model.