Foglight for SQL Server (Cartridge) 7.1.0


Display Name	Description
DB Name	The name of the specified database.
FG Name	The name of the File Group where the index resides.
Free MB	The free size left for the index to grow, in megabytes.
Index Id	Unique identifier of the index.
Index MB	The size of the index at the time of its last statistics update, measured in megabytes.
Index Name	The name of the index.
Num Keys	The number of keys held by the index.
Orig Fill Factor	Represents the size the index occupies as a percentage of the total index page (8 KB).
Owner Name	The owner of the index.
Qualified Name	The full qualified name of the database object.
Row Mod Ctr	The number of row modifications made since statistics were last updated for this index.
Rows	The number of rows in the table.
Table Name	The table with which the index is associated.
Type	The index type.
Used MB	The actual size occupied by the index, in megabytes.

Database Information

Purpose

This collection monitors the database's operations, statistics and other general data.

Type

System.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	3600

The percentage of used space within the file space allocated to the transaction log of each currently used database.

Log space can be freed up by backing up the log, or truncating it, using the truncate option (backup log <dbname> with truncate_only).

All log records that exist after the oldest open transaction cannot be freed.

Average Active Transactions

Average number of active transactions during the specified time range.

Average Log Flush Wait Time

Average amount of time (in milliseconds) spent waiting for log flushes in each database.

A high log flush wait time can result from a slow or overworked disk subsystem.

If a database has a consistently high value of log flush wait time, with no changes, run the SQL command CHECKPOINT on that database to force another log flush and check the value again.

Average Transactions

Average transactions for each database.

Average Transactions Rate

The average rate per second of transactions executed for each database.

Backup Throughput MB

Data transition size (in MB) of backup or restore commands that are reading or writing to the database. While backups are essential, other users will probably experience performance degradation while these operations run.

Backup Throughput Rate

The rate (measured in megabytes per second) at which backup or restore commands are reading or writing to the database. While backups are essential, other users may experience performance degradation while these operations run.

Bulk Copy Throughput

Data transition size (in MB) of data being loaded into the database using BCP (Bulk Copy Program) or BULK INSERT.

While BCP and BULK INSERT are the fastest way of getting data into SQL Server, other users will in most probability experience performance degradation while these operations run.

Bulk Copy Throughput Rate

The rate (measured in megabytes per second) at which data is being loaded into the database using BCP (Bulk Copy Program) or BULK INSERT.

Despite the top speed at which BCP and BULK INSERT can import data into SQL Server, system I/O performance may degrade while BCP operations are underway.

Database ID

The database ID.

Database Name

The name of the database.

DBCC Scans

The size (in MB) of data transition resulting from data logical read scans carried out by Database Console Commands (DBCC).

Log Cache

The total number of reads that were satisfied from the log cache, thereby avoiding physical log I/O operations.

Log Cache Hit Rate

The rate per second of log cache reads, namely: reads that were satisfied from the log cache, thereby avoiding physical log I/O operations.

Log Cache Hit Ratio

The percentage of reads that were satisfied from the log, thereby avoiding physical log I/O operations.

Log File Size

The amount of disk space that the log files are using.

Log Flush Wait Time

The amount of time spent waiting for log flushes in each database.

The log flush operation, which is necessary to guarantee that transactions can be recovered in the event of a system failure, is most commonly caused when a user is issuing a commit transaction.

A high log flush wait time can result from a slow or overworked disk subsystem. If a database has a consistently high value of log flush wait time, run the SQL command CHECKPOINT on that database to force another log flush, and then recheck the value.

Log Flushes

The total number of log pages that were being written to disk by the log writer process during the specified time range.

Log Flushes Rate Total

Number of times per second that the log caches of all of the instance’s databases are being flushed to disk.

Log Growth Count

The number of times the log has been expanded for each database.

Log Growth Count Rate

The number of times per second the log has been expanded for each database.

Log Reads

Log cache lookups.

Log Shrink Count

The number of times the log has been reduced for each database.

Log Truncation Count

The total number of log truncations performed for each database during the specified time range.

Log truncations can be carried out using either of the following methods:

•

Manual truncations (backup log <dbname> with truncate_only)

•

Automatic truncations — in either of the following settings:

•

The database has the trunc.log on chkpt. option turned on

•

The recovery model is set to Simple

Total Data Size

The amount of disk space that the data files are using.

Database Properties

This collection displays a list of databases and their overall properties, such as single user, status and used collation.

Type

SQL Server.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	3600
Online	3600
Offline	86400

Database follows SQL-92 rules for allowing null values.

Ansi Nulls

All comparisons to a null evaluate to unknown.

Ansi Padding

Strings are padded to the same length before comparison or insert.

Ansi Warnings

Error or warning messages are issued when standard error conditions occur.

Arithmetic Abort

Queries are ended when an overflow or divide-by-zero error occurs during query execution.

Auto Close

Database shuts down cleanly and frees resources after the last user exits.

Auto Create Statistics

Existing statistics are automatically updated when the statistics become out-of-date because the data in the tables has changed.

Auto Shrink

Database files are candidates for automatic periodic shrinking.

Auto Update Statistics

AUTO_UPDATE_STATISTICS database option is enabled.

Bulk Copy

Database allows non-logged operations.

Close Cursors On Commit

Cursors that are open when a transaction is committed are closed.

Collation

Default collation name for the database.

DB Name

The database’s name provides a unique identification of the database within a SQL Server instance.

DBID

The database’s ID provides a unique identification of the database within a SQL Server instance.

Full Text

Database is full-text enabled.

Local Cursors Default

Cursor declarations default to LOCAL.

Merge Published

The tables of a database can be published for merge replication, if replication is installed.

Null Concat

Null concatenation operand yields NULL.

Numeric Round Abort

Errors are generated when loss of precision occurs in expressions.

Quoted Identifiers

Double quotation marks can be used on identifiers.

Recovery

Recovery model for the database.

Recursive Triggers

Recursive firing of triggers is enabled.

Status

Database status.

Subscribed

Database is subscribed to a publication.

Page Verify

The SQL Server Database Engine detects incomplete I/O operations, resulting from power failures or other system outages. This metric indicates the method used by the database for detecting incomplete I/O operations, and has the following options:

•

None

•

Checksum — A sum derived from the bits of a segment of computer data, which is calculated before and after transmission or storage.

•

Torn page detection — detection of an incomplete I/O operation

Trunc Log

Database truncates its logon checkpoints.

Updateability

Indicates whether data can be modified.

User Access

Indicates which users can access the database.

Database Sessions (Session List)

Provides a detailed list of the SQL Server sessions.

Type

SQL Server.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	300
Offline	300

Collection Metrics


Display Name	Description
Status	The session Status (runnable, sleeping, blocked, etc).
Last Command	The current or previous command executed.
Lock Timeout	The amount of time that this session will wait for lock requests to be satisfied. Corresponds to the @@Lock_Timeout global variable for this session.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for SQL Server (Cartridge) 7.1.0 - User Guide

Database Index List

Database Information

Database Properties

Database Sessions (Session List)