SQL Sentry Portal Storage

Feature Availability: Support for the Storage tab is currently in a preview status. It is available in version 2021.18 to those who are part of the feature preview program for this release.

Storage

The Storage view provides details about the disk space and disk activity in your monitored environment. Use the Storage tab to view details about your monitored environment storage by disk, including capacity, free space, databases, etc.

SQL Sentry Portal Storage tab

View data about your monitored environment's disk activity and disk space. Selecting a link from the table on the left populates details for your selection on the right in the Details and Trends tabs. SQL Sentry Portal Storage tab left side selection

Overview Chart

The Overview chart displays Storage information for your monitored environment. 

Note:  Select any blue link to display more information about your selection in the Details tab.

SQL Sentry Portal Storage Overview

Option Description
NameThe name of your monitored storage unit.
TypeThe type of storage unit (Disk , volume, Transaction Log, Data, etc).
% UsedThe percentage of used space for the storage unit.
SizeThe overall size of the Storage unit in MB or GB.

Note:  You can use the icon to expand information for a selected disk and the icon to minimize information for a selected disk.

SQL Sentry Portal Storage overview selection expanded
SQL Sentry Portal Storage overview selection minimized

Details

The Details tab displays recorded storage metrics for your monitored environment. 

SQL Sentry Portal Storage Details

OptionDescription
SizeThe overall size of the selected Storage unit in MB or GB.
% UsedThe percentage of used space for the selected storage unit.
File GroupThe file group that the storage unit is associated with.
DatabaseThe database for the selected storage unit.
File PathThe file path for the selected storage unit.
Active VLFsThe number of active virtual log files for the selected storage unit.
AutogrowthThe percentage of autogrowth and amount of autogrowth memory in (KB), or (MB).
Autogrowth VLF CountThe number of virtual log files that have used autogrowth for the selected storage unit.
Autogrowth VLF SizeThe size in (KB) or (MB) of the autogrowth VLF(s).
Last Backup TimeThe time in UTC that the selected storage unit was last backed up.
Last Backup TypeThe type of backup performed during the last backup period.
Max File SizeThe maximum file size for the selected storage unit.
Max VLF SizeThe maximum virtual log file size for the selected storage unit.
Min VLF SizeThe minimum virtual log file size for the selected storage unit.
Total VLFsThe  total number of virtual log files for the selected storage unit.
Used SpaceThe total amount of consumed space for the selected storage unit. 

Trends

The Trends tab displays Latency, IOPS, and MB/sec graphs for your selected storage unit. 

Select a spike on a trends graph to display detailed read and write tooltips for your selection.

View storage trends historically for your selection. Select the calendar, and then select the desired Range, Days, Weeks, or Months that you want to display. Select Apply to update the trends graphs based on your selection.

Note:  Select the button to switch to live data.

Select a graph metric to remove that data from the graph. 

Select metric
Metric removed from graph