Listed below are few tools that we can use to resolve performance issues in Sql server.
- Perfmon or performance monitor that comes along with windows OS.
- SQL Server Profiler that comes with SQL Server Performance Tools.
- DBCC Commands.
- DMV’s
- Extended Events
- Data Collector
Check this for more troubleshooting performance issues in Sql server