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
Author
Message
Posted Thursday, October 10, 2013 4:15 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:59 PM
Points: 31,082, Visits: 15,529
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:

http://www.brentozar.com/archive/2008/09/finding-your-san-bottlenecks-with-sqlio/
http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/05/25/parsing-sqlio-output-to-excel-charts-using-regex-in-powershell.aspx







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