Home > IT Blogs > The Multifunctioning DBA/

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1