Pagine

Server - SQLIO Disk Subsystem Benchmark Tool

There's a very useful command utilities that give you the ability to benchmark your storage and verify that it has good performances.

This utility it's SQLIO Disk Subsystem Benchmark Tool:

http://www.microsoft.com/en-us/download/details.aspx?id=20163


If you are interested to view the original tutorial the right link it's the following:


http://blogs.technet.com/b/italy/archive/2013/09/11/automatizzare-i-test-sullo-storage.aspx

Further link are:



§ SQLIO Disk Subsystem Benchmark Tool http://www.microsoft.com/en-us/download/details.aspx?id=20163

§ Comando FSUTIL http://technet.microsoft.com/en-us/library/cc753059(v=ws.10).aspx

§ SQL Server Best Practices http://technet.microsoft.com/en-us/library/Cc966412

§ How it works: Bob Dorr’s SQL Server I/O presentation
Bob Dorr, Microsoft CSS Engineer

http://bit.ly/b7R1pX
§ SQLIO, PowerShell and storage performance: measuring IOPs, throughput and latency for both local disks and SMB file shares Jose Barreto, Microsoft File Server Team member
http://bit.ly/14qKOzK