The Multifunctioning DBA:

October, 2011

October 5, 2011  1:52 PM

I need some help

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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: