Tagged: SQL Server Monitoring

Monitoring Blocking in SQL Server

Hello to everyone, In this article, I will try to give information about monitoring blocking in SQL Server. You may want to watch blocking and waits in SQL Server in some cases. You can easily do this using the code below. SET NOCOUNT ON; GO SELECT spid, blocked, REPLACE(REPLACE(T.text, CHAR(10),...

Don`t copy text!