Overview - Databases

Displays information related to the space available and used, configuration properties, and volume metrics for all Databases in the applied filter. The Environment, Instance, and Database filters may be combined to view selected resources data.

Overview Section - Database Overview Screen

This view displays information for all Databases in the environment or for the Host selected using the Environment drop-down filter(s).

Database Status

Displays the number of Databases and their current State based on the applied filter(s).
• Click on the row to display a pop-up that lists the instance(s) and Database(s) for that state. The pop-up display can be sorted by clicking on a column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate full screen window. The pop-out display may be sorted by clicking on a column header.
2.4.1.1.2 Memory – Data Cache Size
Displays information about the Memory available versus the Data Cache Used based on the selected filters.
• The color-coded gauge chart displays the Total Free Memory and Data Cache used. Hover over the colors in the chart to display the amount of Memory (in MB).
• Click on Memory or Data Cache Used to display a pop-up that lists the Total Memory, Used Memory, and Percentage Used by Instance and Database. The pop-out display may be sorted by clicking on a column header.
2.4.1.1.3 Data Space Utilization
Displays information on the size of the Database(s) selected in the filters including the Space allocated and used for both Data and Transaction Log (TLOG)files.
The color-coded gauge chart displays the amount of space allocated to the database(s):
• The colored outer ring visually represents the space used for data files and the inner ring represents the space used for the transaction log files.
• Hover over the colored portion of a ring to view the percentage used for the corresponding data or transaction log file.
• Click on Data Space Reserved or TLOG Space Reserved to display a corresponding pop-up with a list of the Total size and Percentage used by the Database. The pop-out display may be sorted by clicking on a column header.
2.4.1.1.4 Datafiles by Free Space
Displays the number of (data) Files by the range of percentage Used.
The color-coded gauge chart displays the total number of data files:
• The colored rings visually represent the number of Files in each Percentage range.
• Hover over a colored portion of the ring to view the percentage range and number of corresponding files within that range.
• Click on the row to display a pop-up that lists, by Instance and Database, the File Name, File Type, Total File Size, and Percent Used. The pop-out display can be sorted by clicking on a column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate full screen window. The pop-out display may be sorted by clicking on a column header.
2.4.1.1.5 Transaction Logs by Free Space
Displays the number of (Transaction Log) Files by the range of percentage Used.
The color-coded gauge chart displays the total number of TLog files:
• The colored rings visually represent the number of Files in each Percentage range.
• Hovering over a colored portion of the ring to view the percentage range and number of corresponding files within the range.
• Click on the row to display a pop-up that lists, by Instance, Database and File Name, the File Type, Total File Size, and Percent Used. The pop-out display may be sorted by clicking on a column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate full screen window. The pop-out display may be sorted by clicking on a column header.
2.4.1.1.6 Annual Data Growth
Displays the size of both the allocated and used data in a shaded line graph for the selected database(s) over time. The growth percentage for both the allocated and used data is displayed as a percentage and calculated from the time monitoring started in WISdom or up to one full year.
• The color-coded line chart compares allocated growth to used growth. Hover the cursor over the lines to display discrete values by time.
• Click the Three-dot icon to export an image of the graph or display the chart in a separate window. Use the slide toggles to filter the display by either allocated or used growth.

Properties

Displays enabled database Features, Compatibility Modes, and Collations for the database(s) selected in the filter.

Features

Displays the number of Databases with a Feature enabled based on the selected filter(s). The Features evaluated are:
Availability Groups Enabled
Displays the total number of databases that are part of an Availability Group (AG), but does not display the number of AGs or the AG names.
Change Data Capture
Displays the number of databases that have this feature enabled.
Log Shipping Enabled
Displays the number of databases that have this feature enabled, but does not check if the Log Shipping jobs are enabled, have encountered any errors, or if a backup/restore has not occurred in some number of minutes.
Read Committed Snapshot Isolation
Displays the number of databases that have this feature enabled.
Replication Enabled
Displays the number of databases that have this feature enabled, but does not validate the Replication jobs are running or the status of the replication set up as viewed in the Replication Monitor.
Transparent Data Encryption
Displays the number of databases that have this feature enabled.
To sort the data, click on the column header.
2.4.1.2.2 Compatibility Mode
Displays the number of databases in the corresponding Compatibility Mode for each Database based on the selected filter(s).
• The color-coded chart displays the total number of Databases in the center of the gauge. Hover over the corresponding color to view the number for each server version.
• Click on the row to display a pop-up that lists all the Instances and Databases for the selected Compatibility Level. The pop-out display can be sorted by clicking on a column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate full screen window. The pop-out display may be sorted by clicking on a column header.
2.4.1.2.3 Collations
Displays the number of databases with the defined collation for the databases depending on the selected filter(s).
• The color-coded chart displays the total number of Databases in the center of the gauge. Hover over the corresponding color to view the number for each Collation.
• Click on the row to display a pop-up that lists all the Instances and Databases for the selected Collation. The pop-out display can be sorted by clicking on a column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate full screen window. The pop-out display may be sorted by clicking on a column header.

Database Statistics

Displays summaries of the Size of Databases by predefined Size grouping, information for each database related to Size, Growth, Volumetric Data, and Enabled Features based on the selected filter(s).
2.4.1.3.1 Databases by Size
Displays an overview of the total number Databases by Size within predefined ranges.
• The color-coded chart displays the total number of databases in the center of the gauge. Hover over the corresponding color to view the number of databases in the selected range.
• Click on the row to display a pop-up that lists all the Instances, Databases, and Size for the selected size range. The pop-out display can be sorted by clicking on a column header.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The pop-out display may be sorted by clicking on a column header.
2.4.1.3.2 Database Volume Metrics
Displays a table with volume metrics information about each Database, as follows:
• The Instance Name column displays the name of the Instance at collection.
• The Database Name column the name of the Database where the Instance resides.
• The Database Size column displays the size of the Database.
• The Growth column displays the percentage of growth of each Database.
• The Growth Size column displays the actual size of growth for each Database.
• The Transactions/second column displays the transaction count for each Database.
The table is sorted in descending order (default) by Database Size. Click on any column heading to resort the table.
• By default, the number of rows displayed in the table is five (5). To change the number of rows displayed, click Rows per page and select a new setting.
Note: This setting will reset to the default if you navigate to another page or click the Reset button.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The pop-out display may be sorted by clicking on a column header.
2.4.1.3.3 Databases
Displays a table with information about each Database, as follows:
• The Instance column displays the name of the Instance at collection.
• The Database column displays the name of the Database where the Instance resides.
• The RCSI Enabled column indicates whether the Read Committed Snapshot Isolation (RCSI) feature is enabled for that Database.
• The CDC Enabled column indicates whether the Change Data Capture (CDC) feature is enabled for that Database.
• The TDE Enabled column indicates whether the Transparent Data Encryption (TDE) feature is enabled for that Database.
• The Database Size column displays the actual size of the Database.
• The Last Backup Time column displays the date and time of the Last Backup of that Database.
By default, the number of rows displayed in the table is five (5). To change the number of rows displayed, click Rows per page and select a new setting. This setting will reset to the default if you navigate to another page or click the Reset button.
• Click the Three-dot icon to export the data to Excel or display the data in a separate window. The pop-out display may be sorted by clicking on a column header.