Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sp-whoisactive]

For questions about the SQL Server monitoring stored procedure written by Adam Machanic

0
votes
1answer
65 views

sp_WhoIsActive waiting resource

I have a huge query in SQL Server 2016 – when I run the query for a subset of records, it completes in 15 minutes. When I extrapolate it to total number of records, it is supposed to be complete in 1 ...
5
votes
1answer
309 views

Unfamiliar syntax - Query with Parameters in Braces at the beggining

I have run sp_WhoIsActive on one of our servers using the following syntax: sp_whoisactive @get_plans = 1, @show_sleeping_spids = 0, @get_outer_command = 1, @get_locks = 1 and found a spid with the ...
3
votes
1answer
149 views

sp_WhoIsActive vs sp_BlitzFirst @ExpertMode = 1

I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who, sp_who2 etc.....
4
votes
1answer
47 views

sp_whoisactive - Do stats include activity for snapshot versioning?

On a system that has read committed snapshot isolation enabled, do the reads, writes, CPU, etc. stats returned by sp_whoisactive include the activity associated with maintaining versions in tempdb?
3
votes
1answer
52 views

sp_WhoIsActive: Are Stats Cumulative for Session or Batch?

In the output of sp_WhoIsActive, are columns such as reads, writes, CPU, and wait_info cumulative for the session, or just cumulative for the batch? We have a query that is blocking a lot and showing ...
1
vote
1answer
454 views

Monitor SQL Server blocked processes [duplicate]

I have been using sp_whoisactive and this is very helpful in finding details of running sessions and blocking. I wanted to check whether there is any option to schedule a job based on this procedure ...
0
votes
1answer
187 views

sp_whoisactive time columns

I am looking at data captured with the help of sp_whoisactive. session_id: 1016 blocked_session_count: 24 Login_time : 29/03/2018 12:14:59 tran_start_time : 29/03/2018 12:14:59 start_time: 29/03/...
2
votes
0answers
48 views

ERP System Blocking Transaction - Not Sure If There Is A Fix

I am experiencing a problem with our ERP system that is causing my company a huge headache and I am not sure if there is anything that I can do to try to resolve. Essentially, when someone at our ...
1
vote
1answer
935 views

Identifying why query is sleeping with open transactions

We have a 3rd-party application which is sporadically leaving connections in a sleeping state with an open transaction. This is causing many other queries to be blocked. I've been logging ...
3
votes
1answer
147 views

Sleeping SPID with Open Transcations

This is an output from sp_whoisactive. Should I be worried about the sleeping spids with high cpu numbers and an open transaction? The sql_command value is the same as sql_text. CPU and reads do ...
2
votes
2answers
132 views

Strange Situation with sp_WhoIsActive

I'm with a simple task to migrate databases. I'm doing the backup in the primary database, setting it to OFFLINE, and then, migrating it to the secondary. No problem at all. but I notice something ...
2
votes
1answer
156 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 ...
2
votes
2answers
2k views

Automated SP_WhoIsActive SQL Activity Capturing Issue

I have an SQL Agent Job on a production server that keeps failing with the below messages. It is supposed to be capturing SQL Server activity using the SP_WHOISACTIVE stored proc, at regularly ...
0
votes
1answer
378 views

Use sp_WhoIsActive in AWS RDS (MSSQL)

I'm trying to run Adam Machanic's sp_WhoIsActive in AWS RDS for SQL Server. When I run as the designated master account, say "TheAdmin", it works. When I run as another user, say "AlmostAdmin", whom ...
7
votes
1answer
2k views

When does an execution plan not show in sp_WhoIsActive?

I use Adam Machanic's excellent sp_WhoIsActive procedure to see activity and to log to a table to troubleshoot long running queries. Why does the execution plan not show all the time in the results? ...