sqlserver probe permissions

book

Article ID: 195192

calendar_today

Updated On:

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