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.

LVL 1

SrikantRajeevAsked: 2015-10-04

Who is Participating?

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 25

Mohammed KhawajaManager - Infrastructure: Information TechnologyCommented: 2015-10-04

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/

LVL 128

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented: 2015-10-04

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

http://www.iometer.org/

LVL 26

madunix (Fadi SODAH)Commented: 2015-10-04

Yes ... IOmeter is a pretty good tool and it's free, check others too
http://www.oracle.com/technetwork/server-storage/vdbench-downloads-1901681.html
http://www.iozone.org/
https://sites.google.com/site/vwiorate/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

LVL 11

Carlos IjalbaSenior SysadminCommented: 2015-10-05

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.