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

How to measure physical disk activity ? Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 7:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 2, 2014 8:21 AM
Points: 168, Visits: 423
I am setting up a new server (Windows Server 2008 R2) to run a SQL Server (2012) and IIS (7.5) based web application which manages about 160GB of data (SQL and flat files). I've got 6 large SAS disks in three RAID-1 sets, and have divided the data load, I think, between them. My goal is to optimize performance by splitting up the IO activity across the disks during the work day.

How can I measure my strategy? I'd like to measure disk physical activity without damaging application performance too much.

I'm looking for pointer to a utility or PowerShell script that will measure total IO by disk during a period of a few hours.

Thank you for any assistance.



Post #1475044
Posted Thursday, July 18, 2013 7:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:17 AM
Points: 5,230, Visits: 9,457
Quite difficult, if you don't have anything to compare your results with. I suppose if users are happy, performance is acceptable. I would recommend monitoring Disk Reads and Writes per sec and Disk secs per Read/Write for each disk. Save the results, and then if you have any problems in future, you can monitor the same thing again to determine whether IO is the problem.

John
Post #1475048
Posted Thursday, July 18, 2013 9:24 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:50 PM
Points: 33,073, Visits: 15,187
You might also track some of the existing waits with regards to IO. http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1475093
Posted Friday, July 19, 2013 12:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 2, 2014 8:21 AM
Points: 168, Visits: 423
Thank you for the Paul Randall blog - it will be helpful.

I tested a new SAN by running SQLIO every hour from a VM server for several months, and looked at the IOPS change over time as more systems were moved to it. I'm looking to do something similar, by disk drive, on the new server. I might want to move my TEMPDB, or split the SS12 database between drives if I can show improved performance.

On the other hand, I am reluctant to change a system to solve a problem I don't have. This new HP DL380 is giving me over 110,000 IOPS from SAS drives in RAID-1 configuration, and has plenty of memory and CPU.



Post #1475639
Posted Friday, July 19, 2013 2:04 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:28 PM
Points: 185, Visits: 918
Alan Spillert (7/18/2013)
I've got 6 large SAS disks in three RAID-1 sets, and have divided the data load, I think, between them. My goal is to optimize performance by splitting up the IO activity across the disks during the work day.
I'm hardly a RAID specialist, but isn't it better to create just 1 big RAID-5(or 6)? If you do that then the data load will be automatically divided evenly.



Alex Suprun
Post #1475681
Posted Friday, July 19, 2013 3:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 2, 2014 8:21 AM
Points: 168, Visits: 423
Yes, data will be divided, but IO activity will also hit all the drives. My attempt is to optimize application performance by spreading out the IO activity.


Post #1475703
Posted Monday, July 22, 2013 1:07 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:28 PM
Points: 185, Visits: 918
Alan Spillert (7/19/2013)
Yes, data will be divided, but IO activity will also hit all the drives. My attempt is to optimize application performance by spreading out the IO activity.
If data is divided then IO activity is also divided, isn't it?



Alex Suprun
Post #1476222
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse