Chatee ahora con Soporte
Chat con el soporte

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

Monitoring Full-text Indexes using the Full Text Search Panel

In full-text indexing, a separate catalog is maintained that indexes each word in a database field as a separate index entry. The Full Text Search panel displays performance details for all full-text indexes on the server.
To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens.
 
Table 52. The Full Text Search Service table contains the following data.
Data Series
Description
Database Name
The name of the database where the tables in the Full Text Catalog reside. Provides a unique identification of the database within a SQL Server instance.
ID
ID of the full-text catalog. Provides a unique identification across the full-text catalogs in the database.
FTC Name
The name of the full-text catalog. Provides a unique identification within the database.
Status
The status of the full-text catalog. Can have one of the following values:
•
0 — Idle
•
1 — Full population in progress
•
2 — Paused
•
3 — Throttled
•
4 — Recovering
•
5 — Shutdown
•
6 — Incremental population in progress
•
7 — Building index
•
8 — Disk is full. Paused.
•
9 — Change tracking
Index Size MB
The size of the full-text index, in megabytes, rounded to the nearest value.
Item Count
The number of items currently found in the full-text catalog.
Path
The name of the catalog directory in the file system.
Last Populated
Displays the time when the full text index was last populated; returns 0 if no population has occurred.
Table Count
The number of tables in the database that take part in the full text indexing process.

Using the HADR Drilldown

The HADR drilldown provides monitoring information regarding the disaster recovering solutions provided by SQL Server: Log Shipping, Cluster, Mirroring, and Always On.
While the data in the Log Shipping panel is available for all versions of SQL Server:
•
The Cluster panel data is only available for instances running on a cluster server.
•
The Mirroring panel data is only available for instances that have databases configured for database mirroring.
•
The Always On panel requires a SQL Server version equipped with the Always On capability (SQL Server 2012 and higher).

Monitoring the Log Shipping

Log shipping is used for setting up backup databases to take the place of a current “live” database if that database goes down. To that end, database logs that are dumped on the live database are copied to the backup server and restored on the backup database.
Monitoring log shipping requires connecting to a monitor server (which may be the live server, one of its backups, or an outside monitor that does not take place in the log shipping process). The monitoring server is used for analyzing log shipping performance.
Foglight for SQL Server monitors log shipping for the following types of errors:
•
Backup threshold exceeded — the failure to back up a database log within a set period of time.
•
Out of Sync threshold exceeded — the failure to restore a database log to a backup server within a set period of time after the log has been backed up.
For details, see Log Shipping Alarm.
The Log Shipping panel allows investigating the cause for a log shipping alarm by carrying out the tasks detailed in the following topics:
•
Tracking the Performance of Servers used in Log Shipping
•
Viewing the Log Shipping Details.
Tracking the Performance of Servers used in Log Shipping
The Log Shipping table contains performance details for the primary and backup servers used in Log Shipping, as presented in the table below.
To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens.
 
Table 53. The Log Shipping table contains performance details.
Column
Description
Server
The server name (Primary server for the parent instance, and Secondary server for all subsequent child instances).
DBName 
Depending on the instance role:
•
For the primary instance, the backup database on the source server
•
For the secondary instance, the destination database on the secondary server
Last Activity
Depending on the instance role:
•
For the primary instance, the last time the database was backed up
•
For the secondary instance, the last time a file was copied or restored
Activity Type
What activity was performed at the Last Activity time (Backup or Copy).
Threshold
The maximum allowed time (in minutes) before a Log Shipping alert occurs.
The amount of time depends on the instance role:
•
For the primary instance, this is the maximum allowed time since the last transaction log backup was made on the source server.
•
For the secondary instance — the maximum allowed time between the last backup on the source server and the last restore on the secondary server.
Outage
During an outage, no alerts occur when thresholds are exceeded (for both the parent and child instances). If this field is blank, no outage takes place.
Threshold Alert
The Error Log drilldown displays this alert if the threshold is exceeded.
Alert Enabled
If this option is selected, only enabled alerts are displayed.
 
Viewing the Log Shipping Details
 
Table 54. The Log Shipping Details section displays the following indicators about the currently selected activity:
Column
Description
Last Backup File
The name of the most recent backup file.
Last File Copied
The name of the most recent backup file that was copied to the secondary server.
Last File Restored
The name of the backup file that was most recently restored to the secondary server.
Backup Time
The time when the most recent backup was carried out.
Copy Time
The date the backup file was most recently copied from the primary to the secondary server.
Restore Time
The date the backup file was most recently restored to the secondary server.
Under the Current Time section:
Source Server
The current timestamp at the primary server.
Target Server
The current timestamp at the secondary server.
Monitor Server
The current timestamp at the monitor server.

Monitoring Cluster Services

The Cluster Services panel displays information about the state of the current Microsoft Cluster Server.
NOTE: If the currently connected SQL Server instance is not part of a Microsoft Cluster Server, this page displays the message SQL Server is not running on a Cluster server.
This panel is used for investigating the causes for the Cluster Server Down alarm, which is raised when Foglight for SQL Server detects that at least one cluster node (server) is not currently running as part of the cluster.
The Cluster Services panel provides only tabular information, using the Cluster Services table. For details, see Monitoring the State of the Current Microsoft Cluster Server.
Monitoring the State of the Current Microsoft Cluster Server
The Cluster Services table displays information about the state of the currently monitored Microsoft Cluster Server.
This table allows viewing the status of each cluster resource and group, as well as the status of any cluster resources owned by each server (node) in the cluster. Foglight for SQL Server highlights any unusual conditions such as resources offline, or cluster nodes down.
To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens.
 
Table 55. The Cluster Services table displays indicators of the Cluster Server performance:
Column
Description
Name
The hierarchical tree of cluster resources, the root of which is the name of the cluster. Lower levels in the tree represent cluster groups, resource groups and servers, and resource details.
Status
The status of the current resource (where applicable).
Server
The individual server in the cluster where the specified resource is located.
Comment
A brief description of the specified cluster resource (if available).
Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación