1 out of 3 rated this helpful - Rate this topic

Performance Monitoring and Tuning How-to Topics

SQL Server 2005

There are a variety of tools and techniques that can be used to monitor Microsoft SQL Server. Understanding how to monitor SQL Server can help you:

Determine whether performance improvements can be made.
Determine user activity to find out what queries users are issuing and who is connecting to SQL Server.
Troubleshoot problems.
Test applications.

This section contains information about how to use SQL Server performance monitoring and tuning tools as listed in the following table.

Topic	Description
Server Performance and Activity Monitoring How-to Topics	Contains information about using Microsoft Windows tools, SQL Server Management Studio, SQL Trace, and SQL Server Profiler to capture information about SQL Server events to troubleshoot performance problems.
Database Engine Tuning Advisor How-to Topics	Contains information about how to use Database Engine Tuning Advisor to tune the physical SQL Server database design.
Execution Plan How-to Topics	Contains information about using the graphical Showplan feature of SQL Server Management Studio.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions