DX Infrastructure Manager

Expand all | Collapse all

QOS_SQLSERVER_aag metrics are missing in datebase

  • 1.  QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-19-2018 10:40 AM

    We have enabled the following qos metrics in sqlserver probe but only 3 are showing up in the database

     

    QOS_SQLSERVER_aag_cluster_quorum_state
    QOS_SQLSERVER_aag_cluster_members_state
    QOS_SQLSERVER_aag_db_replica_synchronization_state
    QOS_SQLSERVER_aag_listener_state
    QOS_SQLSERVER_aag_replica_connected_state
    QOS_SQLSERVER_aag_replica_operational_state
    QOS_SQLSERVER_aag_replica_recovery_health
    QOS_SQLSERVER_aag_synchronization_health

     

     

    the following qos metrics are not available in the database

    QOS_SQLSERVER_aag_db_replica_synchronization_state
    QOS_SQLSERVER_aag_replica_connected_state
    QOS_SQLSERVER_aag_replica_operational_state
    QOS_SQLSERVER_aag_replica_recovery_health
    QOS_SQLSERVER_aag_synchronization_health

     

    We tried to enable loglevel 5 to see if they are being collecting and logs showed these metric in the logs. Then we noticed these metrics are not available in the message bus via Dr. nimbus

     

    Is this a product issue or configuration?

     

    Please advise



  • 2.  Re: QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-19-2018 10:46 AM

    Hi Balkar,

     

    What version of sqlserver is deployed?



  • 3.  Re: QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-19-2018 10:46 AM

    5.30



  • 4.  Re: QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-19-2018 10:50 AM

    No evidence of the aag metrics you see in the log are making it to the local hub/NimBUS?



  • 5.  Re: QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-19-2018 11:01 AM

    Here is the snip from logs which shows that probe is collecting data from the server, but dr. nimbus is showing only following metric on the messagebus

    QOS_SQLSERVER_aag_cluster_quorum_state
    QOS_SQLSERVER_aag_cluster_members_state
    QOS_SQLSERVER_aag_listener_state

     

    And the only above 3 metrics are making to the database.

     

    Trying to find out the cause here? Please assist?



  • 6.  Re: QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-19-2018 11:20 AM

    With data_engine at loglevel 3 or higher, do you see any evidence that any of the other QOS Metrics are being INSERT-ed into the database?



  • 7.  Re: QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-20-2018 02:07 PM

    It looks like data_engine probe restart solved the problem.

     

    Thanks



  • 8.  Re: QOS_SQLSERVER_aag metrics are missing in datebase

    Broadcom Employee
    Posted 06-19-2018 10:39 PM

    /external-link.jspa?url=https%3A%2F%2Fdocops.ca.com%2Fca-unified-infrastructure-management-probes%2Fga%2Fen%2Falphabetical-probe-articles%2Fsqlserver-sql-server-monitoring%2Fsqlserver-sql-server-monitoring-release-notes%23sqlserver%28SQLServerMonitoring%29ReleaseNotes-AccessPrerequisites

    Hi

     

    Please verify also the permissions are ok 

     

    https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-sql-server-monitoring-release-notes#sqlserver(SQLServerMonitoring)ReleaseNotes-AccessPrerequisites

     

    For Windows authentication, perform the following:

    ensure that the user has access to the system hosting the monitored SQL Server.
    provide access rights to Niscache folder of the file system on which the CA UIM robot is installed.
    ensure that the user has local logon rights on the system where the sqlserver probe is installed.

     

    (From version 5.00) Grant the following permission to a non-SA user to access AlwaysOn tables in the database:

    USE master; 
    GRANT VIEW DEFINITION ON AVAILABILITY GROUP::<group name> TO <username>;

    GO