INF: SQL Server 6.5 I/O Performance Tuning Quick Reference

Last reviewed: August 6, 1998
Article ID: Q191061

The information in this article applies to:

Microsoft SQL Server version 6.5

SUMMARY

The compressed file Sqliopt.exe in the Microsoft Software Library (MSL) contains a Word 97 document. The document is a performance tuning quick reference designed to help database administrators configure SQL Server for maximum performance and help determine the cause of poor performance in a SQL Server environment. It also provides SQL Server application developers guidance on how to use SQL Server indexes and SQL Server tools for analyzing the I/O performance efficiency of SQL queries.

MORE INFORMATION

The following file is available for download from the Microsoft Software Library:

 ~ Sqliopt.exe (size: 228052 bytes)

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

Contents of Sqliopt.exe:

   File name       Description
   ------------------------------------------------------------------------

   Sqliopt.doc     MS SQL Server 6.5 I/O Performance Tuning Quick Reference

Additional query words: softlib whitepaper
Keywords : kbfile
Version : WinNT: 6.5
Platform : winnt
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.