All Questions
Tagged with sp-whoisactive monitoring
3 questions
-4
votes
2
answers
258
views
Why Prefer Extended Events to sp_WhoIsActive and Query Store?
If I want to find out what is happening right now, then I use Adam Machanic's sp_whoisactive. If I want to find out what has happened on my server recently, then I will use Query Store.
Extended ...
- 823
0
votes
0
answers
39
views
sp_WhoIsActive CREATE statement in sql_text column while executing object inside another [duplicate]
I am running fabulous sp_WhoIsActive with these parameters:
EXEC dbo.sp_WhoIsActive
@get_task_info = 2
,@find_block_leaders = 1
,@get_outer_command = 1
,@get_transaction_info = 1
,@...
- 945
2
votes
1
answer
635
views
Is there a way to get the isolation level from sp_whoisactive out of the xml into the plain result?
While I caught myself re-engineering the functionality of sp_who / sp_whoisactive using the sys.sysprocesses and sys.dm_exec_session views, to get an overview about running sessions and transactions ...
- 4,807