What Queries (updated ) are used by the sqlserver Probe in UIM?
Document ID :
Last Modified Date :
Show Technical Document Details
CA Unified Infrastructure Management
CA Unified Infrastructure Management:Release:8.4
UNIFIED INFRASTRUCTURE MGMT:CAUIM
UIM - SQLSERVER:UIMSQS
Queries used by sqlserver probe are provided in this kb article. Running these queries requires sufficient permissions being granted to the user used in sqlserver probe. This is described in UIM probe document:
What updated Queries are used by the sqlserver Probe?
See attached file containing queries (SqlserverProbeCheckpointQueries.txt)
probe will run selected SQL's to extract vital information about your SQL Servers.
Was this information helpful?