snippetsqlMinor
How to tell if there are currently any long running queries executing?
Viewed 0 times
executingareanylongtellrunninghowqueriestherecurrently
Problem
(Related to this question)
If I want to see if there are currently any long-running queries executing on my database, what's the easiest way of checking? (I expect the answer will be some query on
If I want to see if there are currently any long-running queries executing on my database, what's the easiest way of checking? (I expect the answer will be some query on
master..sysprocesses?)Solution
WhoIsActive from Adam Machanic is an excellent tool/sp to see what's currently happening on your server.
The below tutorial from Brent Ozar shows how to periodically log sp_whoisactive to a table for later analysis.
https://www.brentozar.com/responder/log-sp_whoisactive-to-a-table/
The below tutorial from Brent Ozar shows how to periodically log sp_whoisactive to a table for later analysis.
https://www.brentozar.com/responder/log-sp_whoisactive-to-a-table/
Context
StackExchange Database Administrators Q#162173, answer score: 7
Revisions (0)
No revisions yet.