By: Greg Robidoux
Overview
In order to monitor and improve performance for your SQL Server environment you need to know what tools are available and how to use each of these tools.
In this section we will look at the following tools to give you an introduction as to what they are used for an how you can use them to collect performance related data.
- Dynamic Management Views (DMVs) and System Catalog Views
- Profiler and Server Side Traces
- Windows Performance Monitor
- Built in performance reports in SSMS
- Query Plans
- Database Tuning Advisor
