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.