Foglight for SQL Server (Cartridge) 5.9.2.1

The Databases table provides details about all of the selected SQL Server databases within the selected instance. The information displayed in the table can be changed by selecting, from the View list, one of the options detailed in the following sections:

•

Overview — general information about each database.

•

Transactions — details about the oldest active transaction in each database.

•

Backup Status — details on database backups, including date and total file sizes.

•

Properties — the properties of the various SQL Server databases.

•

In Memory -

Overview

To refresh

Table 33. The Overview view displays general information about each of the monitored databases.
Parameter	Description
dbid	ID of the database, unique within an instance of SQL Server.
Database Name	Name of the database, unique within an instance of SQL Server.
Status	The database’s current status (for example, ONLINE, OFFLINE, RESTORING, or SUSPECT).
Database Space	Provides a visual representation of the database size and space usage within each database.
Data Size	The total size allocated to data files.
Data Used Size	The total size actually used by data files in the database.
Data Free Size	The total available data size (allocated to data files but not used).
Log Size	The total size allocated to log files.
Log Used Size	The total size actually used by log files in the database.
Log Free Size	The total available log size (allocated to log files but not used).
# Tables	The number of tables, where table type=user, which exist in the database.
# Indexes	The number of indexes that exist in the database.
# File Groups	The number of file groups that exist in the database.
Last Backup	The date and time of the database’s most recent backup.
Last Backup Full Time	The date and time when the most recent full database backup of any type took place.
Last Backup Differential Time	The date and time when the most recent differential database backup of any type took place.
Last Backup Log Time	The date and time when the most recent database log backup of any type took place.
NOTE: The Last Backup Full Time, Last Backup Full Differential Time, and Last Backup Log Time columns are not displayed by default; to view these columns, click the Customizer button at the right side of the table
Recovery	The recovery model for the database; for example, Simple, Bulk Logged, or Full.

Transactions

The Transactions view displays details about the oldest active transaction in each of the monitored databases. A transaction open for a long time may result in degraded performance.

Table 34. The Transactions view displays the following parameters:
Parameter	Description
dbid	ID of the database, unique within an instance of SQL Server.
Database Name	Name of the database, unique within an instance of SQL Server.
Oldest Tran Start Time	The date and time at which the oldest active transaction in the database began.
Oldest Tran SPID	The system process ID of the session that owns the oldest active transaction in the database.

To view the session details of a transaction:

Select the SQL Activity drilldown > Sessions panel > Sessions table.

In the Sessions table, browse for the requested SPID.

Click the SPID number to display the Session Details page.

Use this page to review the information relevant for handling the transaction, such as the transaction count and the text of the most recent SQL batch.

Backup Status

The Backup Status view displays backup details for the database, such as the data size and the date and time of the most recent backup of any type for the database.


	NOTE: The summarized value of the data size and the log size indicates the anticipated size of the backup file.

Table 35. The Backup Status view displays the following parameters:
Parameter	Description
dbid	ID of the database, unique within an instance of SQL Server.
Database Name	Name of the database, unique within an instance of SQL Server.
Status	The database’s current status (for example, ONLINE, OFFLINE, RESTORING, or SUSPECT).
Data Size	The total size allocated to data files.
Log Size	The total size allocated to log files.
Last Backup	The date and time of the most recent backup operation.
Last Backup Full Time	The date and time when the most recent full database backup of any type took place.
Last Backup Differential Time	The date and time when the most recent differential database backup of any type took place.
Last Backup Log Time	The date and time when the most recent database log backup of any type took place.
NOTE: The Last Backup Full, Differential, and Log Time columns are not displayed by default; to view these columns, click the Customizer button at the right side of the table.

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Foglight for SQL Server (Cartridge) 5.9.2.1 - User Guide

Monitoring SQL Server Databases

Overview

Transactions

Backup Status