Options for SQL Performance Monitoring

Here are the default tools for monitoring SQL Server Performance:

  • SQL Server Profiler
  • sp_trace_create and related system stored procedures
  • Management Data Warehouse (best to install on a separate monitoring server)
  • SQL Server Utility
  • Activity Monitor
  • SQL Server Management Studio Reports

Leave a Reply

Your email address will not be published. Required fields are marked *