SQL Server 2000 I/O Basics

SQL Server 2000 I/O Basics
SQL Server I/O Basics Chapter 2 (I/O and SQL Server 2005)

Utilities
Microsoft provides a few utilities for testing the general properties of your system.
SQLIOStress.exe
SQLIOStress.exe simulates various patterns of SQL Server 2000 I/O behavior to ensure rudimentary I/O safety.
The SQLIOStress utility can be downloaded from the Microsoft Web site. See the following article.
•
How to Use the SQLIOStress Utility to Stress a Disk Subsystem such as SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;231619
Important The download contains a complete white paper with extended details about the utility.
SQLIO.exe
SQLIO.exe is a SQL Server 2000 I/O utility used to establish basic benchmark testing results.
The SQLIO utility can be downloaded from the Microsoft Web site. See the following:
•
SQLIO Performance Testing Tool (SQL Development) – Customer Available
http://download.microsoft.com/download/f/3/f/f3f92f8b-b24e-4c2e-9e86-d66df1f6f83b/SQLIO.msi


For detailed information about the use of caching controllers and SQL Server, see the following articles on the Microsoft Support Web site.
• SQL Server and Caching Disk Controllers
http://support.microsoft.com/default.aspx?scid=kb;en-us;86903
• Using Disk Drive Caching with SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;234656
• Using Hard Disk Controller Caching with SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;46091


Note: You can also read more about I/O and SQL Server 2005 in SQL Server I/O Basics Chapter 2.