Documentation forServer & Application Monitor
Monitoring your applications and environment is a key capability of Hybrid Cloud Observability and is also available in a standalone module, Server & Application Monitor (SAM). Hybrid Cloud Observability and SAM are built on the self-hosted SolarWinds Platform.

Top 10 Most Expensive Queries by CPU Time

This widget displays the top 10 most expensive queries sorted by the length of time the CPU spent processing the listed query.

When viewing this widget from the Summary tab on the Application Details view, queries are listed for the entire SQL Server instance. Conversely, when this same widget appears on the Database Details view, queries are only listed for that specific database.

The data can be sorted by clicking the headers of each column. Additionally, this widget can optionally show Top Queries by I/O by clicking Edit in this widget and making the necessary adjustments.

The widget is filtered based on the settings found on the Queries tab in Details view in the Most Expensive Queries widget.

  • Query Text: The text shown is a preview of the full query. To view an entire query in the list, click [+] next to the query listed to expand and view the query.
    Note: Clicking any listed query takes you to the Most Expensive Queries resource on the Queries tab, providing greater detail about the query.
  • CPU Time: Display the time, in milliseconds, the listed query took to complete.
  • Database: Displays the database with which the listed query is associated. The icon in this column shows the current state of the listed database.

The performance counter, Top Expensive Queries, is used to provide metrics for this widget and cannot be edited.