1 |
Open the migration wizard by navigating to Dashboards > Databases > Support Dashboard > Databases Technical Support > Database Agents Migration > SQL Server. |
6 |
Click Next to migrate the agents. |
7 |
When migration has completed, click Finish to exit the Wizard. |
The communication architecture of Foglight for SQL Server is presented below.
Foglight for SQL Server provides a graphic, intuitive method for creating and configuring multiple agents, which can be used instead of Foglight’s default method for creating agents and editing their properties using the Agent Administration dashboard (see About the Foglight for SQL Server Agent in the Foglight for SQL Server Reference Guide). Foglight for SQL Server allows running a wizard that provides a common entry point for adding and discovering all database instances within a user-specified range, and then configuring these instances for monitoring.
1 |
On the navigation panel, click Homes > Databases. |
2 |
a |
Click the Agent Manager Host link located in the bottom left corner of the dialog box. |
• |
Port — Optional. This field can be left empty, unless the TCP/IP connection port is not the default port: 1443. |
7 |
In the Configuration section, select the Alarm Template to use for this instance. The Factory Template will be applied by default. Refer to Viewing, Creating, and Managing Alarm Templates in the Foglight User Guide for more information. |
8 |
Optional To enable SQL Performance Investigator, select SQL PI in the Monitoring Extension section. The SQL PI Repository dialog is displayed. Select the Agent Manager on which the SQL PI |
c |
If no SQL PI repository exists on the selected Agent Manager, the SQL PI Repository Settings |
NOTE: To use gMSA authentication for connections to the PI Repository, select Local User in the Authentication drop-down. This requires that your FMS and Agent Manager are configured to run as a Windows Service logged on with the gMSA account. The gMSA account requires access to the SQL instance. |
d |
If the given SQL PI repository user does not have sufficient privileges, the Insufficient Privileges dialog will be displayed. Enter an admin user and password, and then click Grant Privileges. |
9 |
10 |
Optional — In the Monitoring Extensions pane, click Collect VM statistics. |
11 |
Click Monitor. |
12 |
When the installation completes successfully, the Monitoring Initialized Successfully dialog box appears. Click Add another Database or Finish to exit. |
1 |
2 |
Click the Use this option to discover multiple SQL-Server instances link. The Select an Agent Manager dialog box appears. |
3 |
Choose an Agent Manager host, click Validate to validate the Agent Manager system resources, and then click Next. |
4 |
Click Add instances and select one of the following methods for adding instances: |
5 |
7 |
Click Set credentials to provide the instances' log in credentials and monitoring configuration. |
8 |
Follow the steps described in Installing and Monitoring a Single SQL Server Instance , starting with Step 5 to enter the monitoring credentials and enable the monitoring extensions for this instance. |
NOTE: To use stored credentials when enabling the Operating System monitoring extension, click the Operating System > Select from stored credentials link to open the Stored Credentials dialog box. Here you can review the log in credentials and authentication methods used for logging in to Foglight. Foglight stores encrypted credentials in lockboxes, which may be password-protected for added security. Database agents store all user log in credentials in a default lockbox called DB-Agent Lockbox. If credentials have already been entered in another lockbox, use the Lockbox list to select from that lockbox. |
9 |
Click Monitor |
• |
If the message is Insufficient database privileges, this issue can be resolved using the Insufficient Database Privileges dialog box that appears. For details, go to Step 10. |
• |
For all other messages, the Database Connection Failed dialog box appears. For details, go to Step 11. |
10 |
Click the text Insufficient Database Privileges. |
a |
Click Show details to view the error’s description. |
b |
Click Set credentials to display the dialog box used for entering the credentials, and enter the required changes. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center