SQL Server with Mr. Denny:



March 22, 2012  2:00 PM

How I use sp_whoisactive and sp_who3

Posted by: Denny Cherry
Performance Problems, sp_who3, SQL Server, Troubleshooting

On occasion I'm asked to come and look into some SQL performance problems on systems.  Normally when I'm doing this the customer doesn't have any third party tools installed and they are actively having problems, and these problems are leading to lost revenue or at least really pissed off...

February 16, 2012  2:00 PM

SQL Server isn’t always perfect

Posted by: Denny Cherry
sp_who3, SQL Server

SQL Server is a damn good product, but it sure isn't perfect.  Like any good product out there people have come up with things that can be bolted onto the core to make SQL Server even better. Witho

Bookmark and Share     2 Comments     RSS Feed     Email a friend

April 24, 2008  12:23 PM

My ERRORLOG shows some spids have an ‘s’ after them. What’s going on?

Posted by: Denny Cherry
ERRORLOG, sp_who3, SQL

That "s" is new in SQL Server 2005.  It means that the SPID is a system process.  For example my database is having a problem with tempdb running out of space for no reason.  When I look in the log I see that SPID 118s is the offending SPID.  When I watch SPID 118 using

Bookmark and Share     0 Comments     RSS Feed     Email a friend

October 24, 2007  5:09 AM

Upgrade for sp_who2 called sp_who3

Posted by: Denny Cherry
DataManagement, sp_who3, SQL, T/SQL

I've published this before over on tek-tips.com, but I figured that I'd republish it here as well.  I've written an update for sp_who2 which I call sp_who3.  It can be most useful when trying to diagnose slow running queries as it can provide a wealth of information in a single...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: