Foglight for SQL Server (Cartridge) 5.7.5.30

Reviewing the SQL Agent Error Logs

The SQL Agent Error Logs panel displays errors that are defined in the match list and can be viewed by a paging resolution of 1 hour. It contains the following items:

•

List of current and archived error logs

Use this list to choose the error log whose details are to be displayed in the Error Log table below.

•

Error Log table — displays the following parameters.

Table 58. Error log table parameters.
Column	Description
Date/Time	The date and time when the specified error was logged.
Message	A brief description of the error. This description can also provide the reason for the error, thereby helping to resolve the issue; for example, Unable to start mail session (reason: no mail profile defined).

Reviewing 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 25. 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 59. 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 60. 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.