Tag Archives: performance monitor

Tools for resolving resource bottleneck

Posted in Troubleshooting by

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