To resolve the issues related to performance issues MS SQL server we need to be aware about the below tools for resolving the issues :
- 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
We need to learn these tools to collect the performance related data for resolutions.