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.
In This Section
This section contains information about how to use SQL Server performance monitoring and tuning tools.
-
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.