Top 5 wait_stats question

I have a client that just gave me access to a new polyserve SQL environment. They have placed one production db on the server for testing after they completed setup. We gave them our requirements except for the polyserve but that was because we are not familar with the app so cannot vote for or against.

The are very secuirty aware so right now will not give access to the actual hardware so I cannot run PERFMON but was able to run a query and gather the top 5 wait stats since server startup. (4 weeks)

The SQL instance has seperate drives for data, log and tempdb 16  3ghz proc and 64GB of RAM. The OS and SQL are x64 with SQL being enterprise. With only one db on this instance the two LATCH waits concern me. What dio you guys think. I am attaching the stats and config results.

 config.rpt top5 wait stats
Robert TimmonsSenior Technical ConsultantAsked:
Who is Participating?
 
Daniel_PLDB Expert/ArchitectCommented:
Hi,

As soon as they are low I wouldn't worry about them. Your configuration has separate physical drives for data, logs and tempdb. It is recommended optimal configuration, you can increase performance by adding more spindles to you raid config or choosing other raid config.


PAGEIOLATCH_EX
Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Exclusive mode. Long waits may indicate problems with the disk subsystem.

From white paper I posted:
 table
0
 
Robert TimmonsSenior Technical ConsultantAuthor Commented:
I have reviewed those articles (beleieve me I have read Penal Dave complete FEB. project on wait stats! )and am aware of a few queries we have that I am going to have to add the MAXDOP hint. I am testing the new settings now and am seeing improvement in the CXPACKET wait.  Right now I am more concerned about the LATCH_EX and PAGIOLATCH_SH. This instance basically has no load with only one db in use. Should I be concerned with these? If we have disk subsystem issues I definitily do not want to start rolling production dbs into the new polyserve environment.
0
 
Robert TimmonsSenior Technical ConsultantAuthor Commented:
I agree it is not top two but is in top 5 which is not good. I am accepting this as the solution but any additional comments are welcome. I do want to say the article by Penal Dave on sqlauthority.com is a great source of info but we need all the info we can get since it is the same setup but different results depending on so mamy variables with SQL performance.

Thanks,
Robert
0
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Daniel PL is correct
You will always have waits in a SQL server. You cannot hava a empty top 5 table!
Latches will Always be set, this is a quite normal top 4, given that you take care of the CXPackets.

Regards Martenrune
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.