Good day,
We may have found a bug with the following rules & unit monitors included with v6.4.1.0 (& prior versions) of the SQL Server MP:
|
Workflow Type
|
Display Name
|
Rule ID
|
Invalid object name
|
|
Rule
|
MSSQL 2008: Collect Database Allocated Size (MB)
|
Microsoft.SQLServer.2008.Database.DBSize.Collection
|
$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$ : Database
|
|
Rule
|
MSSQL 2008: Collect Database Total Free Space (MB)
|
Microsoft.SQLServer.2008.Database.DBSpaceFree.Collection
|
$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$ : Database
|
|
Rule
|
MSSQL 2008: Collect Database Total Free Space (%)
|
Microsoft.SQLServer.2008.Database.DBSpaceFreePercent.Collection
|
$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$ : Database
|
|
Monitor
|
DB Total Space
|
Microsoft.SQLServer.2008.Database.DBSizePercentMonitor
|
$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Database
|
|
Monitor
|
DB Space Percentage Change
|
Microsoft.SQLServer.2008.Database.DBSizePercentageChangeMonitor
|
$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$ : Database
|
|
Monitor
|
DB Space Free (MB) : DEPRECATED
|
Microsoft.SQLServer.2008.Database.DBSizeMegabytesMonitor
|
$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Database
|
The odd thing about these workflows is that, despite the fact that the Perfmon object with the “Database” suffix is
not found on the server (i.e.
<InstanceName>:Databases exists, but
not <InstanceName>:Database):
- data is indeed being collected by the rule; and
- health appears to be successfully established by the unit monitor.
There is another workflow supplied in the MP which references the
<InstanceName>:Databases object.
Can anyone either:
- confirm that this is somehow a bug, or
- Explain why/how this works
Thanks,
Larry
