How to Performance Tune SQL Server 7.0
From your Guide

Looking for ways to tune the performance of your SQL Server installation? Try these eight tips from Microsoft.

Difficulty Level: Average    Time Required: Variable

1. Let SQL Server take care of most of the tuning work. This helps SQL Server run at peak performance even as user load and queries change over time.
2. RAM is a limited resource. Too much unneeded data and index information flowing into buffer cache will quickly push out valuable pages.
3. Create and maintain good indexes. A key factor in maintaining minimum I/O for all database queries is to ensure that good indexes are created and maintained.
4. Monitor disk I/O subsystem performance. The physical disk subsystem must provide a database server with sufficient I/O processing power in order for the database server to run without disk queuing.
5. Application and query tuning. This becomes especially important when a database server will be servicing requests from hundreds or thousands of connections through a given application.
6. Take advantage of the powerful combination of SQL Server Profiler and Index Tuning Wizard. SQL Server Profiler can be used to monitor and log a SQL Server's workload.
7. Take advantage of SQL Server Performance Monitor to detect bottlenecks. SQL Server 7.0 provides a revised set of Performance Monitor objects and counters.
8. Take advantage of SQL Server Query Analyzer and Graphical ShowPlan. SQL Server 7.0 introduces Graphical ShowPlan, an easy method to analyze problematic SQL queries.
   

Tips:

1. This material is excerpted from the Microsoft article linked to below. (C) 2000 Microsoft Corporation. Reprinted with permission.

Related Information:

• Microsoft SQL Server Library
• Microsoft's Guide to Performance Tuning SQL Server 7.0
  

More How To's from your Guide to

Put this How To on your PDA!