Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2013-04-30 : 21:45:16
|
| A few days ago I moved our SQL database to a much more powerful server (has 32 cores and 244 gigs of RAM). Since moving to this server I have seen significantly higher writelog and pageiolatch (ex and up) waits. I know that these both indicate possible IO contention but my physical disk metrics do not show a problem. Read and write latencies average 2 ms/op and 15 ms/op respectively for the data drive and write latencies average 0.5 ms/op on the tlog drive. From what I understand these numbers are very good. Is there a different metric I should be looking at? I'm not noticing any performance problems but will be moving much busier databases to this server soon and want to make sure these waits don't become much worse when I do.Thanks. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-05-02 : 01:57:19
|
| Is your tempdb on a separate drive and do you have multiple files for tempdb?mohammad.javeed.ahmed@gmail.com |
 |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-05-02 : 10:54:53
|
quote:
Originally posted by ahmeds08
Is your tempdb on a separate drive and do you have multiple files for tempdb?mohammad.javeed.ahmed@gmail.com
Yes and yes.Last night we moved our tlogs from SAN storage to local DAS storage and the waits appear to be gone :) |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-05-03 : 02:03:34
|
| My recommendation for sqlio is to use it as part of acceptance testing -. It is also useful to compare figures with the server used previously - and could give you some good clues on how to manage the server configuration and disk usage. for existing production systems, it is also possible to negotiate time outside of business hrs. Many production systems do not have to be available 24 x 7 . Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
High writelog and pageiolatch waits on new server