サポートと今すぐチャット
サポートとのチャット

Foglight for SQL Server (Cartridge) 5.7.5.30 - User Guide

Managing SQL Server Database Systems Introduction to this Guide Using Foglight for SQL Server Monitoring Business Intelligence Services Administering Foglight for SQL Server Glossary Reference

Reviewing Database Usage

Monitoring SQL Server Databases

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.
Table 33. The Overview view displays general information about each of the monitored databases.
Table 34. The Transactions view displays the following parameters:
1
Select the SQL Activity drilldown > Sessions panel > Sessions table.
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.

Monitoring Database Details

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 data files — using the Data Files pane, which displays all files (excluding the Transaction Log) in the selected databases; see Monitoring data 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.
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.
The File Groups pane displays detailed information about all file groups in the databases that are currently selected in the Databases table.
The File Groups table shows information about all file groups in the selected database. File stream types (used by memory optimized objects and file-stream objects) are now supported.
The File Groups Space chart displays the amount of space allocated to each file group. Each file group consists of used space and free space.
The Growth chart displays the amount by which each file group is growing over time.
Use the Growth list to change the values displayed on the chart. This list can be displayed by the total amount of space (File total size), used space (File used size), or unused space (File free size).
The Data Files pane displays detailed information about all data files in the database currently selected in the Databases table.
Figure 19. The Data Files pane.
Table 39. The Data Files table displays the following indicators for all database data files:
Growth increment. Indicates the amount by which the file grows every time, if the autogrow option is enabled. for example, if the data file’s initial size is 1 megabyte and it has to grow to a final size of 11 megabytes, setting the Growth Inc. parameter to 2 megabytes causes the file to grow five times, each time by a 2 megabyte increment.
The File Space chart displays the amount of space allocated to the data file for each selected database. Each data file consists of used and free space.
The chart values can be displayed in megabytes or as a percentage of disk space. Use the File Space list to change the values displayed on the chart.
The Data Files Growth chart displays, in megabytes, the amount by which each file is growing over time.
Use the Growth list to change the values displayed on the chart. This list can be displayed by the total amount of space (File Total Size), used space (File Used Size) or unused space (File Free Size).
The Transaction Logs pane displays detailed information about all transaction logs in the database currently selected in the Databases table.
Figure 20. The Transaction Logs pane.
The Transaction Logs table displays information about all transaction logs in the selected databases, as detailed in the following table.
Table 40. The Transaction Logs table details.
The Transaction Log Space chart displays used space and free space for each of the selected databases’ transaction logs.
The chart values can be displayed in megabytes or as a percentage of disk space. Use the Transaction Log Space list to change the values displayed on the chart.
The Transaction Log Growth chart shows the amount by which each transaction log is growing over time.
Use the Growth list to change the values displayed on the chart. This list can be displayed by the total amount of either all transaction logs (File Total Size), used logs database (File Used Size), or unused transaction logs (File Free Size).
The Log Files pane displays detailed information about all log files in the database currently selected in the Databases table.
Figure 21. The Log Files pane.
Table 41. The Log Files table displays information about all log files in the selected database.
The Log Files Space chart displays the total space allocated to each log file.
The chart values can be displayed in megabytes or as a percentage of disk space. Use the Log File Space list to change the values displayed on the chart.
The Log File Growth chart shows the amount by which each log file is growing over time.
Use the Growth list to change the values displayed on the chart. This list can be displayed by the total amount of space (Total), used space (Used), or unused space (Free space).
The Tables and Indexes pane, which displays storage information for database tables and indexes, contains the following sections:
Optionally — To filter the display, proceed to Step 4. To display the entire list according to the parameters set now, go to Step 5.
3
Use the File Group Name field to display only tables belonging to a specific file group.
4
Use the Table Name field to display either a specific table, by entering its exact name, or all tables that share a character string (for example, product), by entering that string.
5
Click Submit.
The value displayed in the Table Size column indicates only the amount of space used by data, while the value displayed in the Used Size column indicates the amount of space used by both data and indexes, and the value displayed in the Reserved Size column indicates the entire amount of space reserved for data and indexes.
The Table Space chart displays the amount of space used by each table, as well as the amount of space reserved for each table.
The chart values can be displayed in megabytes or as the number of rows. Use the Table Space list to change the values displayed on the chart.
The Indexes table shows the index statistics for all indexes in the selected tables. SQL Server stores statistics about the distribution of the key values in each index, and uses these statistics to determine which indexes to use in query processing.
The Index Density table shows the density values for each combination of columns in the index.
The Fragmentation table displays all indexes in the selected tables and shows the latest fragmentation information collected for each index.
Extent Scan Fragmentation and Logical Scan Fragmentation are expressed as percentage values.
Average Page Density shows how full each page is. This is affected by the FILL FACTOR setting used when creating the index; for example, immediately after creating an index with a FILL FACTOR of 30, the Average Page Density for that index is 30. This value is then change as data in the table is modified. Average Page Density can be thought of as the “real” fill factor at the time the data was collected, as opposed to the “original” fill factor that was specified when the index was created. The Original Fill Factor is used when an index is created to leave free space in index pages to allow for the insertion of new records without having to split the page.
Fill Factor Variance is a computed metric, used for comparing the Average Page Density with the original fill factor used when creating the index. The value of this metric is calculated as the absolute difference between the average page density (AvgPage Density) and Original Fill Factor. The value of this variance shows how much the fill factor of the index has changed since the index was created.
Scan Density is a value computed by dividing the optimal number of extent switches by the actual number of extent switches. It is expressed as a percentage value, where higher values indicate less fragmentation. Scan density is displayed with a value of -1 for tables that reside on more than one file.
When a single index is selected in the Indexes table, the Index Distribution chart displays the index distribution histogram for the selected index.
The Disk Space pane displays storage information about disks that reside on the currently monitored server.
To include the Disk Free and the Non SQL files parameters on the chart, select the box Include Non-SQL files in the chart.
To use the exctrlst.exe utility:
2
Double-click the exctrlst.exe binary file, to display the Extensible Counter List dialog box.

Reviewing the Services

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択