April 21, 2009 at 2:54 pm
There's a really great document on the SQL Server 2005 Best Practices page http://technet.microsoft.com/en-us/library/cc966413.aspx (Direct Document Link: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc%5B/url%5D) This docs a keeper.
Indications are from that really it comes down to disk performance.
April 21, 2009 at 4:04 pm
That is a fantastic document isn't it?
"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
April 22, 2009 at 7:01 am
Grant Fritchey (4/21/2009)
That is a fantastic document isn't it?
Ok, thanks guys for the link, I started reading the document, and it looks really interesting. I'll have probably have to have the disk changed on the new server, the hardware guy is gonna kill me.. 😉
Thanks again,
Cheers,
J-F
April 22, 2009 at 7:02 am
There are some awesome docs and whitepapers from Microsoft folks out there, the trouble is that they are almost impossible to find.
Wish they could have some kind of central repository for those kinds of things. Their sites are unworkable the majority of the time.
April 22, 2009 at 7:07 am
J-F Bergeron (4/22/2009)
Grant Fritchey (4/21/2009)
That is a fantastic document isn't it?Ok, thanks guys for the link, I started reading the document, and it looks really interesting. I'll have probably have to have the disk changed on the new server, the hardware guy is gonna kill me.. 😉
Thanks again,
Show him the stats, it will back up your case immensely.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply