|
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
Here's How:
- 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.
- RAM is a limited resource. Too much unneeded data and index information flowing into buffer cache will quickly push out valuable pages.
- 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.
- 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.
- 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.
- 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.
- Take advantage of SQL Server Performance Monitor to detect bottlenecks. SQL Server 7.0 provides a revised set of Performance Monitor objects and counters.
- 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:
- This material is excerpted from the Microsoft article linked to below. (C) 2000 Microsoft Corporation. Reprinted with permission.
Related Information:
More How To's from your Guide to
Put this How To on your PDA!
| 
