How to measure storage performance

SrikantRajeev
SrikantRajeev used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mohammed KhawajaManager - Infrastructure:  Information Technology

Commented:
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 / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

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

http://www.iometer.org/
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Carlos IjalbaIT Systems Director
Top Expert 2014

Commented:
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 MareSystems Engineer (Acting IT Manager)

Commented:
VMTurbo

DirkMare

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial