miércoles, 25 de abril de 2012 12:53
Is there any good way to measure IOPS on a current server that is running SQL Server? It seems like that SQLIO utility is more for bench marking a potential server that may be used as a SQL Server host.
Are there any specific counters that I can add up to come up with current average IOPS of a sql server instance? Can adding the average of Disk Read/ Sec and Disk Write/Sec give me the average of IOPS?
Todas las respuestas
miércoles, 25 de abril de 2012 19:53
I ran perfmon for 4 hours and have a average value of 45.924 for Avg. Disk sec/Read and 9.705 for Avg. Disk sec/Write.
What do these values really mean? Is it 45 millie seconds?
jueves, 26 de abril de 2012 5:45Moderador
For detailed information about how to analyze IOPS requirements from a SQL Server perspective, see: http://sqlcat.com/sqlcat/b/whitepapers/archive/2010/05/10/analyzing-i-o-characteristics-and-sizing-storage-systems-for-sql-server-database-applications.aspx
And this thread described some contents which you need:
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Marcado como respuesta Iric WenModerator jueves, 03 de mayo de 2012 7:17