Tchater maintenant avec le support
Tchattez avec un ingénieur du support

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

Alarms

The Alarms view enables you to modify global settings and agent-specific settings for alarms.
To open the Alarms view:
1
Select the agents you wish to modify its alarms settings.
2
Do one of the following steps:
•
Select the Settings button and open the Administration dashboard, then click Alarms.
OR
•
Select the Configure Alarm' button.
3
From the Alarms view, you can complete the following tasks:
•
Modifying Alarm Settings
•
Configuring Email Notifications
•
Cloning Agent Settings
 

Administering 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.

Configuration Settings

The Configuration drilldown displays the various SQL Server configuration options.

Reviewing SQL Server Configuration

The SQL Server Configuration panel allows carrying out the following tasks:
•
Viewing the server property values — using the Server Property Values panel. See Viewing the Server Property Values.
•
Viewing the SQL Server configuration options — using the Configuration table. See Viewing the SQL Server Configuration Options.
Figure 1. The SQL Server Configuration panel.
Viewing the Server Property Values
The Server Property Values panel contains information about the server properties of the monitored SQL Server instance.
 
Table 1. The Server Property Values parameters:
Parameter
Description
SQL Server Version
Version number of the currently monitored SQL Server instance.
Windows Version
The full version number of the Windows operating system installed on the computer that runs the SQL Server instance (including build and service pack).
Processor Type
The processor type (usually a vendor code).
Processor Count
The number of processors on the computer on which Windows is installed.
Physical Memory
The amount of actual RAM in the monitored host.
Collation
Default collation for databases on the SQL Server instance. Unless another collation is specified when creating a new database, this collation will apply to all of the instance’s databases.
Viewing the SQL Server Configuration Options
The SQL Server Configuration table displays the configuration parameters for the currently monitored SQL Server, as listed in the table below. These parameters often affect the system’s performance. Therefore, reviewing the values displayed in this table and modifying them, if needed, may successfully resolve performance issues.
To create a custom filter for this table, use the options accessible by clicking the button at the table’s upper right side. For details, see Components Shared by all Foglight for SQL Server Screens.
 
Table 2. The SQL Server Configuration table parameters:
Parameter
Description
Configuration Name
The name of the specified configuration option.
Run Value
The value currently used by the configuration option.
Configuration Value
The value to which the configuration option is set. Depending on the Modifiable setting, changing the Config value can be implemented either immediately or only after restarting SQL Server.
Previous Value
The configuration option’s value before the last change took place.
Last Change Time
The time the most recent change took place.
Min
The minimum permitted value for the configuration option.
Max
The maximum permitted value for the configuration option.
Modifiable
Indicates when changes to the option take effect.
The following options are possible:
•
Immediate: changes to these options take effect immediately.
•
Restart: changes to these options take effect after SQL Server is stopped and restarted.
•
Never: these options cannot be modified.
Description
Description of the specified configuration option.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation