Our DB team have asked for some specifics around the sqlserver probe. What permissions are require for the following metrics?
average_waittime
server_cpu
In addition, is there anywhere we can see the mechanism used by the probe to perform monitoring?
Release : 8.2
Component : UIM - SQLSERVER
Here is a KB Article that describes each query used in sqlserver checkpoint monitoring:
https://knowledge.broadcom.com/external/article/44005/what-queries-updated-are-used-by-the-sq.html
Here is a KB Article regarding sqlserver permissions:
https://knowledge.broadcom.com/external/article/34659/what-permissions-are-needed-for-a-sql-us.html