![]() ![]() Register a SQL Server database instance and create the monitoring user yourself Task 1: Create the monitoring user To use this option, see Register a SQL Server database instance and let DPA create the monitoring user below. The monitoring user is assigned the sysadmin role.ĭPA does not store the user credentials.You must provide the credentials of a user with the sysadmin role so that DPA can create or configure the monitoring user.To use this option, see Register a SQL Server database instance and create the monitoring user yourself below.ĭPA will create/configure the monitoring user. The 'Windows Service Not Running - SQL Server' alert does not work.įor detailed information about the privileges granted to the monitoring user, see this article.The 'SQL Server Log has Many Virtual Logs' alert does not work.DPA cannot collect near-zero or zero cost plans. ![]() Because the monitoring user is not granted the sysadmin role, DPA has the following limitations: If you create the monitoring with one of the scripts provided, the DPA monitoring user is not assigned the sysadmin role. You are not prompted to enter privileged user credentials into DPA. Then you use the wizard to complete the registration. With this option, you can create the monitoring user manually or by running a script. I will create the monitoring user manually. If DPA is integrated with CyberArk, these options are not displayed. If DPA is not integrated with CyberArk, the following options in the registration wizard determine how the monitoring user and utility package are created or configured. The DPA monitoring user enables DPA to monitor a database instance. After the trial period, you must activate a license to monitor the database instance. If you register a database instance within the 14-day trial period, DPA begins monitoring the instance immediately. To register SQL Server database instances using a Windows Computer Account (such as a Network Service Account), see this KB article.įor DPA to collect metrics from a monitored SQL Server instance, Azure SQL instance, or ASMI, the SQL option NUMERIC_ROUNDABOUT must be set to OFF. If you are monitoring a SQL Server Availability Group (AG), see Registration and licensing options for clustered environments. Alternatively, you can use mass registration to registrations to register multiple database instances, or you can register database instances using scripts that call the DPA API. ![]()
0 Comments
Leave a Reply. |