Documentation forSolarWinds Observability

Databases area overview

The Databases area overview contains the tabs - Overview, Profiler, Queries, Samples, Metrics, Resources, Inspector, Events, Alerts Explorer, and Advisors.

Overview

When database instances are monitored, the metric data for all entities is summarized in widgets in the Databases area overview. To access the area overview, click Databases in the left pane. The widgets in the area overview display the following information:

Response Time P99

Displays the amount of response time in the 99th percentile value for each of the top selected queries.

Avg. Response Time

Displays the amount of query latency in milliseconds per query execution for the selected time period across all of your monitored databases.

Throughput

The number of queries or statements completed per second. This is a metric of traffic intensity and frequency, showing how many requests your servers are processing.

Errors

The number of recorded errors for all database instances per second.

Top 10 Service Breakdown

Bubble charts and a tabular data breakdown showing three dimensions of data by Database, or Top Query, to understand a relationship or trend between the entities. The Database Instances by count is displayed in the bubble chart and tabular data breakdown by default. Select the drop-down menu to adjust the chart selection. Each chart displays the following data for the selected category:

  • Database Instances by count: Database instances monitored with SolarWinds Observability organized by query count.

  • Database Instance by Total Exec Time: Database instances monitored with SolarWinds Observability organized by total query execution time.

  • Top Queries by Count: Queries organized by total count across all database instances monitored with SolarWinds Observability.

  • Top Queries by Total Exec Time: Queries organized by total execution time across all database instances monitored with SolarWinds Observability.
    Hover over a bubble in the Bubble Chart representation to display the additional metrics below.
    • Execution Time: Time Spent executing queries.

    • Queries Count: Total number of queries executed in the selected time period.

    • Load: The percentage of total time which this instance contributed to the total execution time.

    • Errors: Total number of errors for this time period.

Workload Overview - Average Response Time

Displays the amount of query latency in milliseconds per query execution for the selected time period across all of your monitored databases.

Workload Overview - Load

The load on your monitored databases, as a number of requests executing simultaneously. Concurrency reveals load (or demand) in a way that is orthogonal to variations in request speed or frequency.

Workload Overview - Throughput

The number of queries or statements completed per second across your monitored databases. This is a metric of traffic intensity and frequency, showing how many requests your servers are processing.

Workload Overview - Error Rate

The total number of errors returned per second across all of your monitored databases. Incorrect database responses may indicate request are failing, while throughput and response time appear healthy.

Response Time by Tag

Displays stacked contributions to total response time for tagged queries.

Your observed queries must have query tags associated with them for you to rank by Query Tags with SolarWinds Observability. See Query tags for more information.

Database Instances: Displays information about your monitored database instances including health score, database type, agent status, queries executed, throughput, load, error rate, and active alerts for the selected time period. Click a database instance to filter the overview by your database selection.

  • Click Group by to filter the Database Instances widget by Host or DatabaseType.

  • Click Hide Healthy Instances to hide database instances with Good (100) health scores from the widget.

Filtering

Click the funnel icon to open Filters menu. Filter by database name, database type, or database health score. Click the desired drop-down menu, and select a filter option to apply your filter to the Databases Area Overview.

Enter a database instance, tag, or other search criteria into the Filter Database Instances search bar for more granular search results. Clicking in the search bar displays previously selected tags by default. Click the ribbon icon to save your search criteria. Click the bullets icon to open your previously saved searches.

Click the question mark icon to open the Search Syntax Examples box as displayed below.

Profiler

To access the Profiler, click Databases > Profiler. Use the Profiler to rank your queries or query tags by varying metrics such as the top 10 queries by total time and gain insight into the most time consuming and frequently executed queries in your database. See Profiler for more information.

Queries Explorer

To access the Queries Explorer, click Databases > Queries. Use the Queries Explorer to display a list of observed queries with syntax highlighting by total time, allowing you to determine which queries are consuming the most time. See Queries Explorer for more information.

Samples

To access the Samples tab, click Databases > Samples. The Samples tab displays a list of observed query samples with syntax highlighting and their latency. This helps you to quickly identify queries that are consuming more of your server load across all database instances monitored with SolarWinds Observability. The chart and table list query samples in chronological order for the selected time period.

The Samples by Latency chart, and the Samples grid display recorded query samples for the last hour by default. Query samples are color-coded to help you to quickly identify samples that have errors, warnings, or explain plans. The Samples by Latency chart also displays the average latency and p99 latency for the recorded query samples.

Filter for specific sample text, database, user, origin, minimum latency, maximum latency, connection ID, or a combination of options using the search bar. Click Clear All to clear the filter and return to the collected default samples.

Click the Sync with table pagination toggle to sync the results of the chart with the All Samples table below.

Filter the Samples by latency chart by the Top 250, or Top 500 queries to identify big picture patterns for your recorded query samples, allowing you to optimize your database's performance. Further adjust the query samples by samples with errors, or samples with warnings to identify problematic queries that require more attention. Click Reset to return the Samples by Latency chart to its default state.

Click a sample in the chart or table to open the Sample Details Overview. Click Explain Plan to display the explain plan for your sample. Click Visual Explain Plan to view a visual representation of your sample.

See Samples for more information.

Metrics Explorer

To access the database instances Metrics Explorer, click Databases > Metrics. Use the Metrics Explorer to display a list of all the database instance metrics collected for all of your observed database instance entities. See the Metrics Explorer for more information.

Resources

To access the Resources tab, click Databases > Resources. Use the Resources tab to view details about the Database Host and Plugin Host resource utilization. View the CPU, Disk, Memory, and Network utilization for each database host and plugin host across the selected time period.

Use the Filter to filter for specific charts. You can filter the charts by CPU, Disk, Memory, Network, or All (default).

See Resources for more information.

Inspector

To access the Inspector, click Databases > Inspector. The Inspector combines Profiler and system charts data. Use the Inspector to compare Profiler data directly with system metrics such as MySQL Queries, MySQL Query latency, or MySQL Activity. For example, you could use the Top 10 Databases by Total Time chart, and compare that to the MySQL Queries, and MySQL Activity charts to see which of your MySQL databases is experiencing the highest load and requires optimization.

See Inspector for more information.

Events

To access the Events tab, click Databases > Events. Use the Events tab to view details about your database instance entities health, active alerts, load metrics, number of sessions, and Event Details. See Alerts Explorer for more information about Alerts in SolarWinds Observability.

See Events for more information.

Alerts Explorer

To access the Alerts tab, click Databases > Alerts. Use the Alerts tab to view details about any alerts related to your database instance entities, including active alerts, historical (inactive) alerts over time, and alert settings. Alert severity is categorized by color, with Critical (red), Warning (yellow), and Information (blue) based alerts. Use the Alerts tab to quickly identify Critical Alerts from monitored database instance entities that require your attention. Click an alert link from the Active Alerts, Historical Alerts, or Alert Settings tab to continue to Alerts Explorer for your selection. See Alerts Explorer for more information.

Advisors

To access the Advisors tab, click Database > Advisors. Use the Advisors tab to view details about potential problems and optimization opportunities within your databases monitored with SolarWinds Observability.

See Database Advisor Checks for information about the advisor database checks.