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.

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.

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 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).

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.

Profiler charts

The left search bar is for Profiler charts, and the right search bar is for system charts. Click in the left search bar to select a Profiler chart. Profiler charts will be displayed as The Top 10 profiler category by Total time by default. For example, click queries from the Profiler search bar to display the Top 10 Queries by Total Time. Click the Settings funnel to adjust the Profiler chart. You can adjust the chart to rank from the top 10 - 50, and by any of the Profiler ranking options.

Use the Profiler table to display the Profiler chart details in the table view. Click an option within the table to remove that option from the Profiler chart. Removing options from the chart can help you to isolate specific patterns and better identify indicators for optimization. You can also Click Open in Profiler to open any Profiler chart in the Profiler, and click Export to CSV to quickly save your results to a CSV file.

System metric charts

Click in the right search bar to select system metric charts. Rank system metric charts such as MySQL Queries, MySQL Query Latency, and MySQL Activity to display the respective charts for the set time period. Compare the data from the selected system charts and Profiler charts to identify troublesome queries, periods of downtime, or other database related issues.

Click the X at the top right of a chart to close the chart.

Clear the Inspector

Click the Clear All button to remove all Profiler data sets and system metrics charts from the view.

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.

Database Instances # of Sessions

Displays the number of active and idle sessions for the selected database instance type. Click a sessions chart legend to only display that session type.

Event Details

Displays the event type and the number of event occurrences. Click the event information button to display the Event Information pane for the selected event type.

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.

The Advisors Summary details the total recommendation count, displaying the advisor checks that failed and are actionable to improve database best practices. The Advisors tab displays whether the advisor categories are informational (blue), critical (red), or cautionary (yellow). Critical recommendations should take priority, and require you to optimize an aspect of your database for improved database performance.

Advice categories are displayed beneath the Summary, and provide you with recommendations grouped into specific database categories. Use the Advice categories to filter for specific database aspects that you may want to optimize. For example, you could expand the MySQL Configuration category to see any critical, cautionary, or informational recommendations. Each recommendation category has its own count, with listed recommendations underneath the category. Expand any recommendation to view affected database(s) by ID, their status, and an explanation of the recommendation. Click any database ID to filter the view for that database, and see all the advisor checks for that database.

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