Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

separate disks for data / logs / tempdb / system Expand / Collapse
Posted Thursday, October 10, 2013 4:15 PM



Group: Administrators
Last Login: Today @ 8:48 AM
Points: 32,685, Visits: 16,980
you can use a server side trace to get your workload. Then replay that against your new disk system and see what results you get. Change disks, do this again. This can help you understand how your workload runs against the different configs.

I believe SQLIO uses the separate threads and aggregates, which would explain your results. You might read through these to help:

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1503817
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse