The Multifunctioning DBA:

October, 2011


October 5, 2011  1:52 PM

I need some help



Posted by: Colin Smith
background spid, Help

Yesterday I had an interesting issue that I had never run into before. I attempted to drop a database in SQL Server 2008 SP1 and it failed and it moved the database into single user mode. I attempted the drop again and it failed saying the database was in single user mode and a user was already in...

October 2, 2011  3:23 PM

Just a little Index



Posted by: Colin Smith
Indexing, Performance, Tuning

I ran into a SQL Server that was performing poorly and when I looked at it the only metric that looked like it was causing an issue was the CPU at about 95% avg. I Ran the below query to check and see what my top CPU consumers on the system were. It also showed me that they were executed a...


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: