locked
SQL Server MP Question RRS feed

  • General discussion

  • 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:

    1. confirm that this is somehow a bug, or
    2. Explain why/how this works

    Thanks,


    Larry

    • Changed type Niki Han Monday, February 24, 2014 4:55 PM
    Monday, February 10, 2014 9:09 PM