Question : I am using sp_WhoIsActive. When blocking is occurred on a server I want to quickly identify who is […]
Tag: sp-whoisactive
Sleeping SPID with Open Transcations
Question : This is an output from sp_whoisactive. Should I be worried about the sleeping spids with high cpu numbers […]
Strange Situation with sp_WhoIsActive
Question : I’m with a simple task to migrate databases. I’m doing the backup in the primary database, setting it […]
How to fix error recording sp_whoisactive results to table?
Question : Have a sql agent job modeled from here that uses sp_whoisactive to capture results to a table. 99% […]
Use sp_WhoIsActive in AWS RDS (MSSQL)
Question : I’m trying to run Adam Machanic’s sp_WhoIsActive in AWS RDS for SQL Server. When I run as the […]
sp_WhoIsActive: Are Stats Cumulative for Session or Batch?
Question : In the output of sp_WhoIsActive, are columns such as reads, writes, CPU, and wait_info cumulative for the session, […]
sp_whoisactive time columns
Question : I am looking at data captured with the help of sp_whoisactive. session_id: 1016 blocked_session_count: 24 Login_time : 29/03/2018 […]
sp_whoisactive @get_locks parameter xml error
Question : I often receive this error when running the following command sp_whoisactive @get_locks = 1 Msg 6841, Level 16, […]
Limiting sp_whoisactive output
Question : All, I am currently putting together a knowledge based article that we can hand to our helpdesk to […]