Foglight for SQL Server (Cartridge) 5.9.7.20


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.

Files Drive Total

This collection, which is active only when monitoring SQL Server instances on a virtualized environment, provides a summary of all data and log files within a SQL Server instance, per disk drive.

Type

SQL Server.

Collection Sampling Intervals


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

Collection Metrics


Display Name	Description
Logical Disk	The logical drive name (for example: C, D).
Allocated Space	Total space (in megabytes) allocated to SQL Server files on the selected logical disk.
Used Space	Total space (in megabytes) used by SQL Server files on the selected logical disk.

Files Instance Summary

This collection provides a summary 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	18000

Collection Metrics


Display Name	Description
Allocated Space	Total space (in megabytes) allocated to SQL Server files on all drives, including the unoccupied space.
Used Space	Total space (in megabytes) used by SQL Server files on all drives.