Performance Related Tools



By:
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

Last Update: 12/30/2011






Comments For This Article





download








get free sql tips
agree to terms


Learn more about SQL Server tools