SQL Server server disk test: Sqlio

Part of the database tuning effort involves troubleshooting IO issues, such as the speed of IO or the inability of RAID levels to respond to fast requests under high concurrency. The most common is to see the disk's response speed per read and write, through the performance counters Avg.Disk Sec/read (write) we can see them intuitively. Different business, busy degree also different, what kind of Io do you need to support? Do you configure hardware with the highest level of IO? Can we use some experience and baselines to determine if the current disk environment meets the requirements?

The hand has 4 Inter SSD DC S3500 Series 600GB hard disk made RAID1 two, we take it to practice practicing!

Sqlio is a Microsoft-provided IO testing tool, download address: http://www.microsoft.com/en-us/download/details.aspx?id=20163

After downloading, the next installation is complete, the default directory is: C:\Program Files (x86) \sqlio

Pre-preparation work:

1. Excluding data execution protection for SQLIO.exe

2, remove the hook on the diagram