Loading...

Query Performance Overview

You can run the DBMaintenance utility to collect data about query performance. After the data is collected, you can analyze the data to troubleshoot the queries:

  • Find long running and high CPU utilization queries
  • Find blocking chains
  • Find deadlocks