The Multifunctioning DBA:

Performance

1

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...

June 21, 2011  3:54 PM

SPIDS disconnecting from DB



Posted by: Colin Smith
Performance, SP, SPIDS drop

Ever run into the following issue? <Date><Time> <spid> Error: 18056, Severity: 20, State: 29. I did and it was a mess. Production system just starting dropping spids. It finally stopped with me doing nothing except trying to find out what it was. It took a while but I...


1

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: