Chatta subito con l'assistenza
Chat con il supporto

Foglight for SQL Server (Cartridge) 5.7.5.30 - User Guide

Managing SQL Server Database Systems Introduction to this Guide Using Foglight for SQL Server Monitoring Business Intelligence Services Administering Foglight for SQL Server Glossary Reference

Contents of the Input CSV File

The input CSV file contains the following fields, which are used as columns in the resulting file:
 
 
Table 1. Input CSV File
Name
Description
Host name
The SQL Server host name.
Instance name
The name of the SQL Server instance.
DB port (Optional)
The SQL Server instance port. If no value is inserted in this field, the port number should match the instance name.
DB credentials Type (Optional)
DB authentication type. The possible values are:
•
Windows_Default_Account
•
Windows_Custom_Account
•
SQL_Server_Authentication
If this field is left empty, the Windows_Default_Account option is used.
DB user name (Optional)
The user name required for connecting to the database, if the Windows_Default_Account authentication type was selected.
DB password (Optional)
The password of the database user name that was selected if the Windows_Default_Account authentication type was selected.
DB power user credentials Type (Optional)
The type of database authentication of a user that can grant privileges to the regular database user. The possible values are:
•
Windows_Default_Account
•
Windows_Custom_Account
•
SQL_Server_Authentication.
If this field is left empty, the grant privileges script will not run.
DB power user name (Optional)
 
The user name of a user that can grant privileges to the regular database user.
DB power password (Optional)
The password of the database power user name mentioned above; required only if the regular user does not have sufficient privileges.
Should monitor OS
Specifies whether to create an Infrastructure Cartridge agent for the given host name; the possible values are either True or False.
OS credentials Type (Optional)
OS authentication type; can have one of the following values:
•
Windows_Default_Account
•
Windows_Custom_Account
If this field is left empty, the Windows_Default_Account value is used by default.
OS user name (Optional)
The user name required for connecting to the OS if the Windows_Default_Account option was selected. The user name should be compatible with the selected authentication type.
If the Windows_Default_Account value was selected, this field can be left empty.
OS password (optional)
The password of the OS user specified above; if the Windows_Default_Account option was selected, this field can be left empty.
Enable VMware Collection (Optional)
Specifies whether to monitor VMware metrics; the possible values are either True or False.
VMware Host (Optional)
The VMware host name.
VMware Port (Optional)
The VMware port. If no value is inserted in this field, the port number will use the default port number 443.
VMware User Name (Optional)
The user name required for connecting to the VMware.
VMware Password (Optional)
The password of the VMware user specified above.

Configuring the On Demand Data Port on the Agent Manager Concentrator

If a firewall is installed between the Management Server and the Agent Manager, a bidirectional On-Demand Data Port connection is not possible because On-Demand data requests require direct connection.
This issue can be resolved by creating an On-Demand Data Port on the concentrator — an Agent Manager instance that works similarly to an HTTP proxy. This On-Demand Data Port can be configured to accept On-Demand data requests from the Management Server and direct them to the Agent Manager instances (called downstream instances). For additional details about the concentrator, see Configuring an Agent Manager Instance as a Concentrator in the Agent Manager Installation Guide.
Figure 3. On-Demand Data Port connection with firewalls installed.
A concentrator agent, created specifically for Foglight for SQL Server, allows controlling the On-Demand Data Port so that the server is initialized (starts collecting data) when the agent starts, and stops when data retrieval by the agent ends. The agent, which the user creates manually, requires configuring the following parameters:
•
A list of the downstream hosts that are connected through the concentrator
•
The RMI port number
Each time the Foglight Management Server sends RMI request, the list of downstream hosts submitted by the concentrator agent is being searched, as follows:
•
Inclusion of the target RMI server host name within this list indicates that a FglAM concentrator exists, in which case a connection is made to the proxy RMI server.
•
If the list does not contain the target host name, the connection is made directly to the target On-Demand data port server.
To create the concentrator agent:
1
Go to Dashboards > Administration > Agents > Agent Status.
2
Click Create Agent.
3
Select the agent type DB_SQL_Server_Concentrator.
4
Enter a name of your choice.
5
Click Create.
6
After the creation process is completed successfully, click OK.
To edit the concentrator agent connection details:
1
Select the newly created concentrator agent.
2
Click Edit Properties.
3
Click Modify properties for this agent only.
4
Enter the number of the proxy On-Demand Data Port server port, or accept the default number.
5
Enter the concentrator Foglight Agent Manager host name (optional).
6
Click Edit to edit the list of downstream Agent Managers.
7
Click Add Row.
8
Enter the name of the requested Foglight Agent Manager host.
 
* 
IMPORTANT: When editing the properties of the Foglight Agent Manager concentrator (Dashboards > Administration > Agents > Agent Status), the name of the Foglight Agent Manager should be entered in the Downstream FglAMs section exactly as it appears in the topology, under Home > Agents > All agents > <Agent name> > RMI data > FglAM host property. The <Agent name> parameter refers to the Foglight for SQL Server agents that reside on the selected Foglight Agent Manager.
9
Repeat Step 7 to Step 8 as many times as required.
10
Click Save Changes.
11
Click Save at the lower right corner of the screen.
12
Click Back to Agent Status.
13
Select the newly created concentrator agent.
14
Click Activate.
15
Click OK to complete the process.
In an environment that includes a Foglight Agent Manager concentrator, when upgrading the environment where the concentrator does not contain any regular agents, the concentrator is not upgraded. Therefore, after the upgrade process takes place the Foglight Agent Manager concentrator has to be deployed manually.
 
 

Using Foglight for SQL Server

Foglight for SQL Server monitors the SQL Server database activity by connecting to and querying the SQL Server database. The agents provided monitor the SQL Server database system. The dashboards included with the cartridge provide a visual representation of the status of the major components of the SQL Server agents. They allow you to determine any potential bottleneck in database performance.

Viewing the Databases Dashboard

 
* 
NOTE: The following section describes the various components of the Databases dashboard. To learn how to customize this dashboard’s display and focus on a requested instance, see Selecting an Instance to Monitor.
The Instance home page is opened by accessing the Databases dashboard.
To access the Databases dashboard:
1
Ensure that the navigation panel on the left is open.
To open the navigation panel, click the right-facing arrow on the left.
2
On the navigation panel, click Homes > Databases.
The Databases dashboard provides an at-a-glance view of the monitored environment, with all the currently monitored database types.
The Databases dashboard includes these sections:
•
Database cartridge type tiles — each tile represents a database type (SQL Server, Oracle, Sybase, DB2, or All). Tiles display the number of instances for each database type, along with a breakdown according to the instance health state severity (Normal, Warning, Critical, Fatal).
•
Status section — includes the following components:
•
Status summary — a color-coded bar, which provides a visual representation of the summarized health condition of all instances listed in the Database Group table.
The status summary bar provides a graphic representation of the monitored environment’s current state, broken down to the number of instances and their current health state: Fatal, Critical, Warning, Normal or Unknown.
•
Database-specific health summary — when the database group All is selected, this section displays all the currently monitored instances for each database type, divided by their health state (for example: four SQL Server instances, three of which have the health state Warning and one is indicated with the health state Fatal). When a user-defined database group is selected, this section displays data only about the agents included within the selected group.
The Status Indicators section can be used for filtering the Databases Group table to display only instances that meet a criterion set in this section. For details, see Filtering the Display by Severity.
* 
NOTE: The Status Indicators section can be used for filtering the Databases Group table to display only instances that meet a criterion set in this section. For details, see Filtering the Display by Severity.
•
The Monitor button — Use this button to add instances to monitor. For details, see Monitoring Data Replication.
•
The Configure Alarms button — Takes you directly to the Administration > Alarms page. On the Alarms page you can configure alarm settings and specify alarm sensitivity levels. Sensitivity levels control which alarms are enabled by default.
•
The Settings button — Use this button to do one of the following:
•
Access the User Management settings, allowing you to restrict which instances specific users are allowed to view. This makes it easier to for users to find information about only the instances they are interested in. For details, see Assigning Instances to Users or Groups.
•
After selecting one or more instances of the same database type, use this button to set options for collecting, storing, and displaying data for the selected instances, and configuring the connection to SQL Performance Investigator (if installed). For details, see .
•
Currently selected database group table — a list of all monitored databases within the database group that is selected in the Databases section. For details, see Currently Selected Database Group.
•
The Select dashboards () button — provides direct link to several drilldowns and panels, by that means saving the need to navigate to these locations through the Overview drilldown.
 
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione