Various tools available for performance tuning are:

  • Dynamic Management Views
  • SQL Server Profiler
  • Server Side Traces
  • Windows Performance monitor.
  • Query Plans
  • Tuning advisor

What is a performance monitor?

Answer: Windows performance monitor is a tool to capture metrics for the entire server. We can use this tool for capturing events of the SQL server also.
Some useful counters are – Disks, Memory, Processors, Network, etc.

What is the SQL Profiler?

Answer: SQL Profiler provides a graphical representation of events in an instance of SQL Server for monitoring and investment purpose. We can capture and save the data for further analysis. We can put filters as well to captures the specific data we want.