Question : Recently I have noticed some threads running on our sql server which are invoked from our application, which […]
Tag: sp-whoisactive
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 […]
Is it possible to see blocker’s host name or machine name using sp_WhoIsActive?
Question : I am using sp_WhoIsActive. When blocking is occurred on a server I want to quickly identify who is […]
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, […]
- 1
- 2