sqlserver probe permissions

Products

• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)
• DX SaaS

Issue/Introduction

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?

Environment

Release : 8.2

Component : UIM - SQLSERVER

Resolution

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