Tag Archives : sp_whoisactive

---

The waiting is the hardest part

This entry was posted in Troubleshooting and tagged sp_whoisactive troubleshooting on February 15, 2011 by Colleen M. Morrow

A developer came to me last week with a problem.  A relatively simple query within his application that normally takes under a second to run, is intermittently taking upwards of 30 seconds.  This, in turn, is causing his application to time out.  He said he could increase the timeout on his application to work around […]

---

The obligatory first post

This entry was posted in Professional Development and tagged professional development sp_whoisactive SQL Server on February 8, 2011 by Colleen M. Morrow

This past weekend I attended SQL Saturday here in sunny Cleveland.  And while there were probably more fun ways to spend a Saturday, I have to say I’m very glad I went.  There were some great sessions by Steve Jones, Thomas LaRock, Grant Fritchey, and Jeremiah Peschka and I learned a ton of information. However, […]

---