July 26, 2010 at 1:05 pm
Hi,
We have SQL Server 2005 EE x64 with SP3 and I noticed that the Max IO wait is >25 ms for most of the time and it even going to 100 ms & more.
I have analyzed the wait statistics and noticed that the below wait types have larger values:
OLEDB
PAGELATCH_EX
SLEEP_TASK
BACKUPIO
CXPACKET
ASYNC_NETWORK_IO
Please see the attachment and could you please provide your inputs
Thanks
July 28, 2010 at 2:44 pm
Could you please advice!!
Thanks
July 30, 2010 at 7:06 am
I don't typically open excel spreadsheets from people I don't know, but I can say that several of the things you list indicate unacceptable IO performance. More RAM could help. Dropping MAXDOP could remove the CXPACKET waits. Others could be due to slow client not processing data fast enough.
I highly recommend you get a performance tuning professional on board for a few days for a review to help you identify and correct the root causes of your issues.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply