Monitoring and Tuning for Performance

The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends. SQL Server and the Windows operating system provide utilities that let you view the current condition of the database and to track performance as conditions change.

In This Section

Topic	Description
Monitoring and Tuning for Performance Overview	Contains information about how to develop a monitoring strategy, select the appropriate monitoring tools, and analyze the data captured during monitoring.
Tools for Performance Monitoring and Tuning	Contains information about SQL Server and Windows tools that can be used to monitor and tune SQL Server for improved performance.
Evaluating Performance	Contains information about how to determine a baseline for performance in SQL Server.
Tuning the Physical Database Design	Contains information about using Database Engine Tuning Advisor to tune the physical database design, which includes indexes, indexed views, and partitioning.

See Also

Concepts

Automating Administration Across an Enterprise

Database Engine Tuning Advisor Overview

SQL Server Profiler Reference

Other Resources

Monitoring Events

Monitoring Resource Usage (System Monitor)