Norway




- 7819 - Finding All Currently Blocked Requests in SQL
- 7820 - Finding All Currently Blocked Requests in SQL
- 3235 - Finding All Currently Blocked Requests in SQL
- 3406 - Finding All Currently Blocked Requests in SQL


Tip of the Day   - 5428 - Finding All Currently Blocked Requests in SQL
- 5551 - Finding All Currently Blocked Requests in SQL

Language: SQL
Expertise: Intermediate

Mar 15,

Full Text Search: The to Better Natural Language Queries for NoSQL in Node.js

Here is a quick way to find all currently requests in SQL:

SELECT
SESSION_ID,
STATUS,
BLOCKING_SESSION_ID,
WAIT_TYPE,
WAIT_,
WAIT_RESOURCE,
TRANSACTION_ID

FROM sys.dm_exec_requests

WHERE STATUS = N'suspended';
GO

Hannes du Preez

 

- 7279 - Finding All Currently Blocked Requests in SQL
- 7280 - Finding All Currently Blocked Requests in SQL



- close icon - Finding All Currently Blocked Requests in SQL

Thanks for your registration, follow us on our social networks to keep up-to-date



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here