Disk metrics such as Disk Utilization work in the Infrastructure and Host dashboards, but the same disk information cannot be seen in the disk utilization column of the DB dashboard.
An error such as the following may appear in the database agent long
YYYY-MM-DD HH:MM:SS.SSS ECHO ERROR [testserver.example.com-ALPHA-wmiThreadPool-1-[DBSS_SQL_Server_Host][YYYY-MM-DD HH:MM:SS.SSS]] com.quest.qsi.fason.core.collection.processor.InstanceProcessor - Failed to run DBSSPhysicalDiskProcessor processor of DBSS_SQL_Server_Host collection.
java.lang.RuntimeException: Failed to execute collection [DBSS_SQL_Server_Host], reason=failed to run WMI query: DBSS_Physical_Disk_Raw1_0_0_0.wmi
Operating system metrics such as CPU and memory may appear in the database dashboard without the Infrastructure cartridge (IC) having been successfully installed, agents created, and credentials having been configured.
In Windows 2008, WMI is missing some OS metrics and Disk % Busy is included. This metric accounts for the percentage of time the busiest device spent serving system-wide input/output requests, it serves as a measure for the system I/O load. Since the metric is missing in the first place, the Agent cannot collect the needed data and hence the n/a shown in Databases Dashboards. The solution would be to install the hotfix from Microsoft on the monitored host.
The Disk % busy, is displayed in the Global View and in the Summary -> Real-time, Summary -> History and Performance dashboards.
Starting from SQL Server cartridge version 5.6.4 and up, the Disk % busy is being retrieved taken from the IC (Infrastructure) cartridge topologies /storage/diskUtilization)
The following is from the Microsoft service note link for the hot fix:
SYMPTOMS:
On a computer that is running Windows Vista or Windows Server 2008, you use some raw performance classes of Windows Management Instrumentation (WMI) to calculate performance data. However, you receive incorrect data from the performance classes.
For example, you calculate some performance data from the AvgDiskSecPerTransfer and AvgDiskBytesPerTransfer_Base values in the Win32_PerfRawData_PerfDisk_LogicalDisk class. However, the AvgDiskBytesPerTransfer_Base value is not updated as expected.
This problem does not occur when you use certain formatted performance classes, such as the Win32_PerfFormattedData_PerfDisk_LogicalDisk class.
RESOLUTION 1
How do DB, VMWare, and IC cartridges work when collecting OS metrics?
Review the article to understand how these agents function.
Controlling System Access with Credentials
The Credentials dashboard provides quick access to credentials and lockboxes. This dashboard provides at-a-glance information about the current state of credentials, lockboxes, credential clients, the alarms they generate and cartridge-specific credential views. Use it as a starting point for your credential management needs. To access this dashboard on the navigation panel, click "Administration | Credentials".
How do I troubleshoot WinRM configuration?
Review the article to obtain insight on remote monitoring configuration/troubleshooting.
WindowsAgent or UnixAgent Infrastructure Agent never shows up in Agents on All Hosts dashboard.
Review the WindowsAgent/UnixAgent solution to understand configuration of these agents.
Infrastructure agent not collecting: "Failed to connect" and "a connection could not be established"
Review the article for diagnosing connection failures.
RESOLUTION 2
Install the Microsoft hotfix to resolve this issue for Windows 2008 R2 and Vista
Installing the hotfix might require server boot in order for the fix to take place. After the fix is in place and the server is booted, the Agent should display the Disk % Busy metric (may have to refresh dashboard by changing time range).
In order to verify that the solution was taking place you can run a WMI query "PercentIdleTime" (see please see the attached screenshot WMI+Query.PNG) and make sure you get similiar results with no errors.
Check the Resources below for the required/suggested links.
Hotfix url:
Refer to Microsoft KB Article ID: 961435 - "Some base values are not updated when you use the Win32_PerfRawData_PerfDisk_LogicalDisk WMI class to calculate performance data in Windows Vista or in Windows Server 2008"
You must restart the computer after you apply this hotfix.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center