SQL Server - Database Details Page

Parameters

Description

• Total MB - Displays the total the total disk space of all available data files(in MB).


• Used % - Displays the percentage of used disk space.


• Used MB - Displays the total disk space used by all data files (in MB).


• Free % - Displays the percentage of free/unused disk space.


• Free MB - Displays the free/unused disk space (in MB).


• Growth % - Displays the percentage at which all data files grow.

Data File Details

• File Name - Name of the data file.


• Total MB - Displays the total disk space of all available data files(in MB).


• Used % - Displays the percentage of used disk space.


• Used MB - Displays the total disk space used by all data files (in MB).


• Free % - Displays the percentage of free/unused disk space.


• Free MB - Displays the free/unused disk space (in MB).


• Growth % - Displays the percentage at which all data files grow.


• Growth Rate - Displays the rate at which the data files grow.


• Maximum size - The maximum size (in MB) up to which the data file can grow.

• File Name - Name of the log file


• Total MB - Displays the total the total disk space of all available log files(in MB).


• Used % - Displays the percentage of used disk space.


• Used MB - Displays the total disk space used by all log files (in MB).


• Free % - Displays the percentage of free/unused disk space.


• Free MB - Displays the free/unused disk space (in MB).


• Growth % - Displays the percentage at which all log files grow.


• Growth Rate - Displays the rate at which the log files grow


• Maximum size - The maximum size (in MB) up to which the log file can grow


• Log Cache Hit Ratio - Displays the log cache hit ratio file size.


• Number of VLFs – Displays the number of VLFs (Virtual Log Files) created. A transaction log is split internally into smaller chunks called virtual log files. A large number of VLFs can cause degradation in performance when transaction log backups occur or in any transaction log related activities.

VLF Details

Clicking on the Number of VLFs will pop up and show the details of about virtual log files within the physical transaction log.

• FileID - Physical log file identifier from sysfiles




• FileSize - Virtual log file size ( in bytes )




• StartOffset - Beginning point of the virtual log file




• FSeqNo - Virtual log file's sequence number




• Status - Whether the virtual file contains the active part of the transaction log. 0 means that virtual file does not contain the active portion of the log and it is available for log use ; 2 means that VLF is active




• Parity - Parity information for virtual log file




• CreateLSN - Log sequence number that began the virtual log file. (click here for more info)

• Creation Date - Date in which the Database was created




• Database Mode - The recovery model for the database which shows how transactions are logged.

• Transactions/Min - Number of transactions started for the database per minute




• Replication Transactions/Min - Number of replication transactions per minute




• Bulk Copy Rows/Min - Number of rows bulk copied




• Bulk Copy Throughput/Min - Amount of KiloBytes bulk copied




• Backup/Restore Throughput/Min - Read/write throughput for backup/restore of a database




• Log Cache Reads/Min - Reads performed through the log manager cache

• Log Flush/Min - Number of log flushes




• Log Flush Waits/Min - Number of commits waiting on log flush




• Log Flush Wait Time - Total wait time (milliseconds)

Parameters

Description

System Tables

Displays current information about all the system tables in the database.

• System Table Name - Name of the System Table.


• Total Rows - Total number of rows present in that table.


• Total Space Used in MB - Size of the table (MB).

Displays the various foreign key relationship that exists in the table.

• Parent Table – Table which contains the primary / parent column for the foreign key.


• Parent Column – The primary column for which a foreign exists.


• Foreign Table – Table name of foreign key column.


• Foreign Column – The foreign key column name.

Displays current information about all the user tables in the database.

• System Table Name - Name of the User Table.


• Total Rows - Total number of rows present in that table.


• Total Space Used in MB - Size of the table (MB).

Displays current information about various views in the database.

• View Name - Name of the View.


• Schema Name - Schema Name to which this view is associated.


• IsIndexed - Shows if there is an index for the view ( 1 = Index Present, 0 = No Index ).


• IsIndexable - Shows whether an index can be created ( 1 = Index can be created, 0 = No Index can be created ).


• Create Date - Date on which the view was created.


• Modify Date - Date on which the view was last modified.

Displays information about various index that is present in the database.

• Table Name - Name of the Table.


• Index Name - Name of Index present in the table.


• Maximum Size Row - Maximum size for a row in that table (in bytes).


• Max Noleafindex Row - Maximum size of a nonleaf index row (in bytes).


• File Group Name - Name of the filegroup (Primary or User-defined).


• Column Name - Name of the column for which index is present.


• Type - Data type of the Column.


• Clustered Index - Shows if the index is a Clustered Index or not (Yes or No). A clustered index determines the physical order of data in a table.

Displays information about various indexes that has not being used so far:

• Object Name – Name of the table in which the index is present.


• Index Name – Name of the index which is not used.


• Type – Type of the Index.

Displays Logical Fragmentation information about indexes that are present in the table.

• Table Name - Name of the table in which the index is present


• Index Name - Name of Index present in the table


• Fragmentation Percent - Percentage of Logical fragmentation present in the Index. This is the percentage of out-of-order pages in the leaf pages of an index. The Percentage of Fragmentation should be as close to zero as possible for maximum performance. However, values from 0% through 10% may be acceptable

Displays information about usage of various indexes in the database.

• Object Name – Name of the table in which the index is present.


• Schema Name – Schema Name to which this table is associated.


• Index Name – Name of the index which is not used.


• Type – Type of the Index.


• User Seeks - The number of seeks in this index by user queries.


• User Scans - The number of scans in this index by user queries.


• User Lookups - The number of bookmark lookups in this index by user queries.


• User Updates - The number of updates in this index by user queries.