Converse agora com nosso suporte
Chat com o suporte

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

Defining Data Collection and Storage Options

The Foglight for SQL Server’s agent collects and stores data at all times, even when the browser window that displays the data is not active. Use the Collection Frequencies view to specify:
•
Which collections are sampled and stored
•
The data collection values when sampling is carried out in offline, online, and real-time frequency modes
•
The collection frequency
When a user is currently focusing on a screen, the sampling frequency for all of the collections associated with this screen switches to Real-Time. The collection frequency determines the sampling frequencies of the other collections (that is, collections that are not running in Real-Time mode).
The available collection frequencies are as follows:
•
Low — all collections are running in Offline mode, regardless of whether a client is connected.
•
Normal — the collections' running mode (Online/Offline/Real-time) adjusts dynamically to the client's connection status (disconnected/connected/focusing on a screen).
•
High — all collections are running in Online mode, regardless of whether a client is connected.
•
The Query timeout for on-demand collections.
This setting defines the number of seconds that a query for on-demand collections can run before it times out.
On-demand collections are collections whose data is retrieved not by predefined time intervals but upon entering a screen or clicking a button.
The default setting of this parameter is 60 seconds, but it can be modified by clicking the number that indicates the parameter’s value in the field Query timeout for on-demand collections:.
* 
NOTE: This section displays only SQL Server-related collections. For details about Windows-related collections, see Configuring Performance Counters.
Table 6. The Collections table includes the following columns:
Column
Description
Collection Enabled
Indicates whether the selected collections are sampled and stored.
Collection Name
The name of the collection. This list is sorted in an alphabetical order.
Offline Frequency (Sec)
Allows defining the collection interval, in seconds, in offline mode (for example, 300).
Offline frequency refers to the longest interval possible for sampling the monitored instance.
Online Frequency (Sec)
Allows defining the collection interval, in seconds, in online mode (for example, 60).
Real-time Frequency (Sec)
Allows defining the collection interval, in seconds, in real-time mode (for example, 20).
Only one collection can be sampled at real-time frequency in any given moment.
Query Timeout (Sec)
The amount of time, in seconds, that elapses before the query times out.
* 
IMPORTANT: When the browser window that displays Foglight for SQL Server is active, the collection frequency mode in the active screen (for example: the Indexes pane in the Databases drilldown) switches to the fastest frequency possible - once every 20 seconds.
To modify the values of a specific collection:
1
Select the collection’s row in the table.
2
Click Edit.
The Edit the Collection dialog box appears.
3
Select whether to enable the collection and storage of the selected collection.
4
Set the collection interval, in seconds, in offline frequency mode (if available).
5
Set the collection interval, in seconds, in online frequency mode (if available).
6
Set the collection interval, in seconds, in real-time frequency mode.
7
Set the query timeout, in seconds.
8
Click Set to apply these settings or Cancel to reject them.
9
If no more editing is necessary, save the changes before switching to another screen. For details, see Reviewing the Administration Settings.

Defining Error Log Filtering

The Error Log Filtering view allows selecting which error logs generated by the SQL Server database are to be displayed in the Logs drilldown. The error log alarm increments the error log count for each error log entry that matches one of the strings listed in this view.
Foglight for SQL Server provides a default list of error logs enabled in the scanning, and allows adding, modifying, or disabling error logs from the list.
The settings defined using the Error Log Filtering view affect the following alarms: SQL Agent Error Log Summary, SQL Server Error Log Summary, SQL Agent Log Informational Error, and SQL Server Log Informational Error.
For details, see the Alarms chapter of the Foglight for SQL Server Reference Guide.
The Error Log Filtering view allows defining the following settings:
•
Minimal severity for invoking summary alarms — can be either turned off or set to one of the defined severity values, that is: Warning, Critical, or Fatal.
* 
NOTE: By default, the value of this parameter is Critical.
•
Minimal severity for invoking alarms — can be either turned off (the default setting) or set to one of the defined severity values: Warning, Critical, or Fatal.
For all SQL Server versions, the Error Log Filtering view allows defining the following settings:
•
Display under a pre-defined name in the SQL Agent Error Logs and SQL Server Error Logs panels — using the Match List pane. This pane contains a default list of expressions within the alert logs that are to be retrieved and displayed in the Alert Log panel under a pre-defined name, category, and severity.
•
Exclusion from the SQL Agent Error Logs and SQL Server Error Logs panels display — using the Ignore List pane, which contains a default list of alerts that are to be excluded when setting the alert logs display.
* 
IMPORTANT: Only messages that are explicitly defined in the Ignore List will not be displayed. Messages that were not added to either the Match or Ignore lists appear under name Other, type SQL Server errors messages and severity Informational. Therefore, ensure that messages that need not be displayed are added to the Ignore List.
Both the Match List and the Ignore List panes can be customized by adding, editing, or removing alert logs. Each filter can be enabled or disabled separately by clicking Edit and selecting or clearing the Enabled check box. Alternatively, to enable or disable all of the filters, click the Enable All or Disable All button.
To add an error to the Match List:
1
Click Add.
The dialog box Add Filter appears.
Use this dialog box to assign a name to the filter. Alert filters are enabled automatically upon addition. To disable a filter, use the Edit button.
2
Click Add to save your settings.
Each newly added alert filter is enabled by default. To disable the filter, click Edit and then clear the Enabled check box.
The entire list of filters displayed on the view can be enabled or disabled by selecting the Enable All or Disable All buttons at the bottom of the screen. Enabling a single filter requires editing it.
To edit a filter:
1
Select the requested filter.
2
Click Edit.
The Edit Filter dialog box appears. Ensure that the Enable Filter check box is selected (default).
3
To change the filter’s name, edit the text in the Error Log Filter text field.
4
Click Set.
5
If another filter should be edited, repeat Step 1 to Step 4. If no more editing is necessary, or if all additional editing operations were carried out, save the changes before switching to another view. For details, see Reviewing the Administration Settings.

Configuring Performance Counters

The Performance Counters view allows configuring user-defined performance counters and their Unit of Measurement/Indicator. The counters created in this view are accessible using the User Metrics drilldown.
Each user-defined performance counter is collected and plotted over the specified time range in the User Metrics drilldown. The User Metrics drilldown is used only for displaying the user-defined performance counters; any creation or management operation of these counters is carried out using the Performance Counters view.
Use this view to add user-defined collections of performance counters to a specified agent by selecting them from the complete list of available performance counters. The user-defined counters value refers to raw data, which is derived directly from the counter provider.
To retrieve performance counters for a specific agent:
1
Select an agent from the list.
2
Click Add Counters at the bottom of the screen.
The Retrieving Performance Counters progress bar appears.
Upon successful completion of this operation, the Add Counters dialog box appears.
3
Select the requested counters. For each counter select the matching instance and unit.
4
Click Add.
5
After adding all of the requested counters, click Close to exit the Add Counters dialog box.
All of the newly added performance counters now appear in the table.
To delete unwanted counters, select the requested counter and click Remove. To add more counters, repeat Step 2 to Step 5.
6
After carrying out all of the requested changes, save the changes before switching to another view. For details, see Reviewing the Administration Settings.

Setting Options for Displaying Data in the Buffer Cache

The Buffer Cache view allows configuring the default retrieval settings for Buffer Cache panel, accessed through the Memory drilldown.
A lower buffer cache hit rate can be resolved by investigating the objects that consume the largest amount of cache size.
Use this view to configure the number of objects to be displayed in the table and their sorting properties.
 
Table 7. Click Edit in the Buffer Cache Settings section to edit the following parameters.
Parameter
Description
Top N Buffer Cache Objects by Cached MB
Defines the maximum number of objects to be displayed in the Buffer Cache panel (default: 20).
Order direction
Defines whether the order of the items for retrieval is ascending or descending.
Order by
Defines the parameter by which the display is to be ordered.
After carrying out all of the requested changes, save the changes before switching to another view. For details, see Reviewing the Administration Settings.
Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação