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.
Contains information about how to develop a monitoring strategy, select the appropriate monitoring tools, and analyze the data captured during monitoring.
Contains information about SQL Server and Windows tools that can be used to monitor and tune SQL Server for improved performance.
Contains information about how to determine a baseline for performance in SQL Server.
Contains information about using Database Engine Tuning Advisor to tune the physical database design, which includes indexes, indexed views, and partitioning.