Foglight for SQL Server (Cartridge) 7.1.0


Display Name	Description
% Free	The percentage of space not allocated to any objects.
% Used	The percentage of space allocated to objects.
Can Grow	Indicates whether the file can grow.
Database	The database’s name provides a unique identification of the database.
DBID	The database’s ID provides a unique identification of the database.
File Count	The number of files in each file group.
File Group	The name of the file group to which the file belongs.
Free Size	The amount of unused space, measured in megabytes.
Size	The size of the file, in megabytes.
Type	The type of file group (for example: data or log).
Used Size	The size used by the database file (in megabytes).

File Data Flow Statistics

Purpose

This collection displays a list of data and log files within a SQL Server instance, which provides detailed statistics about usage, size, and data flow.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Current Reads Wait Time	The number of seconds SQL Server has spent waiting for physical read operations on this file since the last time data was collected. Shows data only for SQL Server 2005.
Current Wait Time	The number of seconds SQL Server has spent waiting for I/O operations on this file since the last time data was collected.
Current Writes Wait Time	The number of seconds SQL Server has spent waiting for write operations on this file since the last time data was collected. Shows data only for SQL Server 2005.
DB And File Group	The database name, concatenated with its file group name.
DB File Name	The database name, concatenated with its file name.
DB Name	The name of the SQL Server database that contains the file.
Disk	The disk where the file resides.
File Group	File group name.
File Name	The name of the file.
MB On Disk	Physical file size on disk in MB. Shows data only for SQL Server 2005.
MB Read	The number of MB read from this file since SQL Server started.
MB Written	The number of MB written to this file since SQL Server started.
Path	The name of the file whose I/O statistics are on display.
Reads	Number of reads issued on the file.
Reads Rate	The current rate at which SQL Server is performing physical read operations from this file.
Reads Wait Time	The total number of seconds SQL Server has spent waiting for physical read operations on the file since SQL Server started. Shows data only for SQL Server 2005.
Total IO	The number of MB read from and written to this file since SQL Server started (MB Read plus MB Written).
Total IO Rate	The current rate at which SQL Server is performing both physical read and write operations for this file (Reads Rate plus Writes Rate).
Total Wait Time	The total number of seconds SQL Server has spent waiting for I/O operations on this file since SQL Server started.
Writes	Number of writes issued on the file.
Writes Rate	The current rate at which SQL Server is performing physical write operations to this file.
Writes Wait Time	The total number of seconds SQL Server has spent waiting for write operations on the file since SQL Server started. Shows data only for SQL Server 2005.

File Groups

Purpose

This collection displays a list of all SQL Server instance file groups and transaction logs details.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
% Free	The percentage of space not allocated to any objects.
% Used	The percentage of space allocated to objects.
Can Grow	Indicates whether the file can grow.
Database	The database’s name provides a unique identification of the database.
DBID	The database’s ID provides a unique identification of the database.
File Count	The number of files in each file group.
File Group	The name of the file group to which the file belongs.
Free Size	The amount of unused space, measured in megabytes.
Size	The size of the file, in megabytes.
Type	The type of file group (for example: data or log).
Used Size	The size used by the database file (in megabytes).

Files

This collection displays a detailed list of all data and log files within a SQL Server instance.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
% Free	The percentage of space not allocated to any objects.
% Used	The percentage of space allocated to objects.
Auto Grow	Whether the file can grow automatically as it fills.
Can Grow	Indicates whether any of the files in the transaction log can grow.
Data Files Used Percentage Threshold	A flag indicating a threshold for the used percentage of space within a data file. When this percentage exceeds the predefined threshold, an alarm will be invoked.
Database	The name of the specified database.
DB and File	The database name, concatenated with the database file's name.
DBID	The database’s ID; provides a unique identification of the database.
File	The name of the data file.
File Group	The name of the file group to which the file belongs.
Free Size	The amount of unused space, measured in megabytes.
Growth Increment	Indicates the amount by which the file will grow every time, if the autogrow option is enabled. For example: if the data file’s initial size is 1 MB and it has to grow to a final size of 11 MB, setting the Growth Inc. parameter to 2 MB causes the file to grow five times, each time by a 2 MB increment.
Growth Remaining	The number of times a log file can grow automatically before the file is almost full and can no longer automatically grow enough to relieve the problem.
Growths Remaining Data File Threshold	A flag indicating a threshold for the number of times the data file can AutoGrow until it is unable to grow anymore.
Growths Remaining Log File Threshold	A flag indicating a threshold for the number of times a log file can AutoGrow until it is unable to grow anymore.
Log File Used Percentage Threshold	A flag indicating a threshold for the used percentage of space within a log file.
Path	The path of the database file.
Size	The file’s size.
Type	The type of file group. For example, data or log.
Used Size	The amount of space size used by the database file.

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

File Groups

File Data Flow Statistics

File Groups

Files