Is there a tool that can be used to determine the maximum IOPS on my Datastores? Due to the way the SAN is configured (poorly by the installer) it's difficult to calculate this and we want to know where the ceiling is. It looks like we have lots of headroom but we want a way to very this.
Asked
Active
Viewed 6,612 times
3 Answers
8
Microsoft has a tool called SQLIO which will push the IO to the limit. Just build a Windows VM with a disk on the correct data store and run SQLIO. Don't let the name fool you, it doesn't actually require SQL to be installed (it doesn't have anything to do with SQL, it was just built by the SQL team).
mrdenny
- 27,174
- 4
- 41
- 69
-
1Wow - I've never seen that. Fantastic tip. – Dan Dec 16 '11 at 19:46
-
Yeah, it's a handy little tool. Not many out side of the SQL Server world know it exists because it's name isn't very accurate. – mrdenny Dec 19 '11 at 22:12
1
You could also use IOMeter, in much the same way as the SQLIO suggestion by mrdenny. Have a look at the Unofficial Storage Performance Thread @ VMware communities where you can download a pre-configured test file for use with IOMeter and compare your results to other contributors.
dadamson
- 56
- 4
1
In addition to iometer that dadamson suggests, take a look at ATTO diskbench. It's very easy to use, and it's free. Just google for download links.
pauska
- 19,620
- 5
- 57
- 75