Testing for a DB Block
Testing for a DB Block
I was hoping that I can test for MSSQL DB Blocks, but I can't figure out how one would do that, has anyone else done this before; and if so how?
-
KS-Soft Europe
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
You may use ODBC Query test to check MS SQL Server:
http://www.ks-soft.net/hostmon.eng/mfra ... s.htm#odbc
If you need to determine blocking sessions, you may try use the following ODBC Query test settings:
Execute SQL Query:
SELECT blocking_session_id FROM sys.dm_exec_requests where DB_NAME(database_id)='DN_NAME' and blocking_session_id <>0
Alert when field in 1 row 1 col
is <> from ''
If field is unavailable, set status Ok
http://www.ks-soft.net/hostmon.eng/mfra ... s.htm#odbc
If you need to determine blocking sessions, you may try use the following ODBC Query test settings:
Execute SQL Query:
SELECT blocking_session_id FROM sys.dm_exec_requests where DB_NAME(database_id)='DN_NAME' and blocking_session_id <>0
Alert when field in 1 row 1 col
is <> from ''
If field is unavailable, set status Ok