QOS_SQLSERVER_aag metrics are missing in datebase

[Balkar Singh Kang]

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

[Stephen Danseglio]

Hi Balkar,

 

What version of sqlserver is deployed?

[Balkar Singh Kang]

5.30

[Stephen Danseglio]

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

[Balkar Singh Kang]

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?

[Stephen Danseglio]

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?

[Balkar Singh Kang]

It looks like data_engine probe restart solved the problem.

 

Thanks

[Franklin Ravi D'souza]

/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