Foglight for SQL Server (Cartridge) 5.9.7.20

Properties

The Properties view displays database properties that correspond to the data returned by the SQL Server DatabasePropertyEx function. For more information about these properties, see the Transact-SQL Reference section in Microsoft® SQL Server Books Online.

In Memory

The In Memory view displays metrics on space usage by objects in memory. To view details for a specific database, click on the database row. Detailed metrics will be displayed below the table.

Table 38. The In Memory view displays metrics on space usage by object in memory
Parameter	Description
dbid	The database ID number.
Database Name	The name of the database.
XTP Enabled	Whether or not the database is XTP enabled.
Resource Pool Name	The name of the resource pool allocated to the database.
Percent of Pool	Total memory usage of the objects within the database.
Tables Allocation	Total amount of memory (in MB) allocated for the tables.
Indexes Allocation	Total amount of memory (in MB) allocated for the indices.
System Allocation	Total amount of memory (in MB) allocated for the system.
Table Used	Total amount of memory (in MB) used by the tables, including row versions.
Indexes Used	Total amount of memory (in MB) used by the indices, including row versions.
System Used	Total amount of memory (in MB) used by the system, including row versions.

Monitoring Database Details

You can display detailed data for a database. by selecting the database row in any one of the tables displayed on the Overview, Transactions, Backup Status, Properties or In Memory tabs.

The Database Details panel allows carrying out the following tasks:

•

Monitoring database space and history — using the Summary pane, which displays a graphical representation of the disk space usage for databases, as well as various statistics for each database. For further details, see Monitoring Database History .

•

Monitoring file groups — using the File Groups pane; see Monitoring File Groups in the Selected Databases .

•

Monitoring data files — using the Data Files pane, which displays all files (excluding the Transaction Log) in the selected databases; see Monitoring data files .

•

Monitoring transaction logs — using the Transaction Logs pane; see Monitoring Transaction Logs in the Selected Database .

•

Monitoring log files using the Log Files pane; see Monitoring Log Files .

•

Monitoring tables — using the Tables & Indexes pane, which displays statistics for all tables and indexes in the selected databases (by default, 50 rows are displayed); see Monitoring Tables and Indexes .


	NOTE: The panes from File Groups to Tables and Indexes display tabular and graphical information about other areas down the storage level hierarchy, currently selected in the Databases table. The charts on each of these panes display the amount of space allocated to the area for each selected database (Space Chart), and the amount by which each of the areas is growing over time (Growth Chart).

•

Monitoring disk space — using the Disk Space pane, which displays each logical disk on the server, with a detailed graphical representation of the disk space usage for all disk. For further details, see Monitoring Disk Space .

Monitoring Database History

The Summary pane displays three separate charts showing various statistics relating to recent I/O activity on each database. You can select which data each graph should display.


	NOTE: The graphs in the chart are available for each database.

To view a particular graph, select it from the Database History list.

Table 39. The following graphs are available for each database:
Graph	Description
% Log Used	The amount of 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). NOTE: All log records that exist after the oldest open transaction cannot be freed.
Data File Size	The amount of disk space that the data files are using. This graph indicates how the size of data files has changed over time.
Log File Size	The amount of disk space that the log files are using. This graph shows how the size of log files has changed over time.
Active Transactions	The number of open transactions in each database.
Transactions Rate	The rate of transactions for each database.
Log Cache Hit Rate	Percentage of log cache reads satisfied from the log cache. This metric reflects the amount of physical log I/O that is being avoided by caching log data. The log caches normally have a non-zero hit rate only if Rollback activity is taking place.
BCP Throughput Rate	The rate (measured in kilobytes per second) at which data is being loaded into the database using BCP (Bulk Copy Program) or BULK INSERT. Despite the speed at which BCP and BULK INSERT can import data into SQL Server, system I/O performance may degrade while BCP operations are underway.
Backup Throughput Rate	The rate (measured in kilobytes per second) at which backup or restore operations are reading or writing to the database. Throughput of a database backup or restore operation allows determining the progress and performance of these operations; for example, measuring how the performance of the database backup operation changes when more backup devices are used in parallel or when faster devices are used.
DBCC Scan Bytes Rates	The rate (measured in kilobytes per second) at which Database Console Commands (DBCC) are processing data. This rate represents the number of logical read scan kilobytes per second for database command console (DBCC) statements.
Log Flushes Rate	The rate at which the log cache for each database is being flushed to disk, which is necessary to guarantee that transactions can be recovered in the event of a system failure.
Log Flush Wait Time	The amount of time spent, in milliseconds, waiting for log flushes in each database. High log flush wait time can be caused by a slow or overworked disk subsystem. If a database has a consistently high Log Flush Wait Time that never changes, run the SQL command CHECKPOINT on that database to force another log flush and re-check the value in Foglight for SQL Server.
Log Growths Rate	The number of times the log has been expanded for each database.
Log Shrinks Rate	The number of times the log has been reduced for each database.
Log Truncations Rate	The frequency of log truncations for each database.

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) 5.9.7.20 - User Guide

Properties

In Memory

Monitoring Database Details

Monitoring Database History