troubleshooting Question

NetworkEng Needs DBA Advice MS SQL Performance

Avatar of amigan_99
amigan_99Flag for United States of America asked on
9 Comments3 Solutions52 ViewsLast Modified:
So the consultant DBA has been blaming the network for months to management for high latency of writes to his DB. The VMWare datastore latencies from the host and VMs were all low like 2ms. No errors, no drops. Today I finally got to see what he was referring to. All of his databases have decent write latency except for one. The DBs on the same LUN all do fine except this one. Anyhow I think it's up to him to figure it out. BUT - I figured I throw the stats on the MS SQL database up here to the experts DBAs. Is there anything about these stats that looks out
of bed? Or any guess as to why one DB would show 64ms write latencies while the 26 others are between 1ms and 11ms for write latency? This is the biggest of the DBs - the others are more like 200GB. They have nowhere near the Total IO Write Stalls figure.Perhaps those could be from multiple users trying to write at the same time? There are probably 1500 or so users accessing it a day. DBA opinions sought!

Database Name ScubaPro
Logical File Name ScubaPro [ROWS]
Drive      E:
Size (GB) 857.99      
Total IO Read Stall  130,522,647
Total Reads      42,706,650
GB Read         1,167
Avg Read Stall (ms) 3      
Max Rec Read Stall Avg 30
Total IO Write Stall  2,711,425,650
Total Writes  41,904,190
GB Written 863.5
Avg Write Latency/Stall (ms) 64
Max Rec Write Stall Avg 30
Physical File Name  E:\MSSQLData\ScubaPro.mdf      
Read-Related Wait Stat  PAGEIOLATCH*
Write-Related Wait Stat  ASYNC_IO_COMPLETION
Sample Time      16:03.5
Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros