This chapter provides information to help you configure Microsoft SQL Server 7.0 for maximum performance and to help you determine the cause of poor performance in a SQL Server environment. This chapter also provides information about using SQL Server indexes and SQL Server tools for analyzing the I/O performance efficiency of SQL Server queries.