Return
-
Title
Chart "Disk Queue Length" displays data from drives which are not used by the selected SQL Server instance -
Description
The SQL Server chart "Disk Queue Length" is displaying data from disk/drives which are not used by the selected SQL Server instance.
For example:
The selected SQL Server instance is using drive 'G:' for its data and log files. But in the chart also data from drive 'F:' is displayed. Drive 'F:' is used by another SQL Server instance.
-
Cause
Clustered SQL Server environment
-
Resolution
In SQL Server cartridges previous to 5.5.8, Foglight picks up the information about the disks/drives from the node, but in the cluster environment the information needs to be picked up from the cluster administration.
As part of the 5.5.8 cartridge version, the SQL Server cartridge was modified so that the agents only collect disk information on disks that contain the instance data files.The disk monitoring collections for the database cartridge are only meant to add value to the DB collections, rather than replicate the functionality of the full Infrastructure cartridge.