asked on

How to measure storage performance

I have my virtual servers hosted in my cloud service provider.
The servers include Database servers. I would like to measure the performance of my servers in terms of storage.

What are the parameters which needs to be checked for measuring the performance of the disk.
Basically i would like to know how to measure the storage performance.

Mohammed Khawaja

If you have access to the OS and your servers are Windows based then use Performance Monitor to check disk performance. There are limited things you could do from SQL to give you some idea of Disk IO. Refer to SQL Tuners document link below:

http://www.sqltuners.net/blog/13-05-16/Measuring_Disk_IO_performance_for_SQL_Servers.aspx

You could also download SQLIO from Microsoft:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=20163

For Linux and MySQL, refer to link below:

http://www.psce.com/blog/2012/04/18/analyzing-io-performance/

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

I would recommend and use the "industry" standard, and use IOMeter.

http://www.iometer.org/

ASKER CERTIFIED SOLUTION

madunix

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Carlos Ijalba

BTW disk performance is usually measured in IOPS (input/output operations per second), which is the standard unit of measurement for the maximum number of reads and writes to storage devices.

Dirk Mare

VMTurbo

DirkMare

SrikantRajeev

ASKER

Thanks