September 12, 2011 at 3:37 pm
Frankly he should be on at least SP1, preferably SP2 regardless of problems....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 12, 2011 at 3:41 pm
Bob Fazio (9/12/2011)
There is also a patch we are strongly looking at. http://support.microsoft.com/default.aspx?scid=kb;EN-US;976700The reason why we are leaning towards the patch, is because I think everyone agrees, one bad query shouldn't take down a server of this (or really any) size.
It's also included in SP1, which we might also apply.
Oh yeah, I've seen a single query take down a server before. It doesn't take much unfortunately. The right combination of bad code & bad structure... things can go downhill rather quickly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 13, 2011 at 5:33 am
GilaMonster (9/12/2011)
Frankly he should be on at least SP1, preferably SP2 regardless of problems....
I am on SP2 -CU3 for SQL 2008 I am referring to Windows 2008 R2 (SP1)
December 19, 2011 at 2:48 pm
After tuning nearly every query in our app (of course a good thing) we still couldn't explain why even at what appeared to be relatively low CPU loads, the system would crawl. So we applied SP1 to windows 2008 R2... And the result has been night and day. It is finally running like I would expect a system to run. No question in my mind, this was our issue all along.
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply