Description

SQLIO is a Microsoft command line tool for testing disk performance for Microsoft SQL Server. It is designed to measure disk input/output performance by running a sequence of specialized tests. SQLIO can be used to simulate the behavior of a SQL Server application, such as random reads and writes to a disk, as well as sequential reads and writes. SQLIO can also be used to measure the performance of different disk configurations, such as RAID levels and partition alignment. SQLIO can be used to investigate the effects of different caching strategies, such as read-ahead and write-behind. SQLIO can also be used to investigate the effects of different workloads, such as random or sequential.

Categories