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.
StorageStorage HardwareVirtualization
Last Comment
SrikantRajeev
8/22/2022 - Mon
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:
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.
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/