Disk I/O Monitoring
-
HI
Can anybody suggest me how to check the IOPS for mssql 2000 / 2005 / 2008 database so that we can go for disks required to fulfill the request of mssql?
vrijesh
-
I don't fully understand your question, but if you are trying to determine the speed of your IO subsystem I suggest the free Microsoft tool SQLIO - search for "SQLIO Disk Subsystem Benchmark Tool" on Microsoft.com
-
See if this blog on "Handy Hardware Accessment Tools" will give you the answer you're looking for as far as tools are concerned.
http://sqlserverperformance.wordpress.com/2010/11/15/handy-hardware-assessment-tools-for-sql-server/%5B/url%5D
Or you can read this thread that discusses using sqlio to measure your disk I/O.
http://www.sqlservercentral.com/Forums/Topic634266-146-1.aspx
Hope this helps.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply