Applications Systems

Data in the Database Disk I/O or Transaction Log Disk I/O resources for AppInsight for SQL Server is not visible

This article resolves an issue with In AppInsight for SQL Server when the resources for Database Disk I/O and Transaction Log I/O shows no data.

First published date

10/16/2018 8:15 PM

Last published date

6/26/2020 5:25 AM

Overview

In AppInsight for SQL Server, the resources for Database Disk I/O and Transaction Log I/O shows no data.

Product section

Server Application Monitor

Cause

The Node being monitored is not via WMI or the volume that the database files are on are not monitored on the server.

These resources use some of the data that is collected via WMI to fill in this data.

Resolution

Go to the node in question in the Orion server under Settings > Manage nodes.

Note: The polling method must be set to WMI.
On the node screen, click List resources.

Note: Any volumes containing the database data files and log files must be selected for monitoring.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.