SQL Sentry Portal Storage

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, disk activity, 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 capacity 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 and any storage activity for your monitored environment. The details tab is divided into Capacity and Activity Metrics sections that display real-time data or a selected range of data.

SQL Sentry Portal Storage Details

Capacity Metrics

MetricDescription
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.
Log Reuse WaitThe status of the transaction log for the monitored connection.

Additional Information: For more information about the Transaction Log in SQL Server and possible statuses, see the Transaction Log (SQL Server) MSDB article
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. 

Activity Metrics

Note:  Activity Metrics update automatically in five minute increments by default.

MetricDescription
ReadsThe number of reads in your selected storage unit for the specified time period. 
Reads/secThe number of reads per second in your selected storage unit for the specified time period.
Read BytesThe total number of read bytes in your selected storage unit for the specified time period. 
Read Bytes/secThe total number of read bytes per second in your selected storage unit for the specified time period.
Read Bytes %The total percentage of read bytes in your selected storage unit for the specified time period.
Bytes/ReadThe number of bytes per read in your selected storage unit for the specified time period.
WritesThe number of writes in your selected storage unit for the specified time period.
Writes/secThe number of writes per second in your selected storage unit for the specified time period.
Write BytesThe total number of write bytes in your selected storage unit for the specified time period.
Write Bytes/secThe total number of write bytes per second in your selected storage unit for the specified time period.
Write Bytes %The total percentage of write bytes in your selected storage unit for the specified time period.
Bytes/WriteThe number of bytes per write in your selected storage unit for the specified time period.

Note:  Activity Metrics update automatically in five minute increments by default.

Trends

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

SQL Sentry Portal Storage Trends

Select a spike on a trends graph to display detailed read and write tooltips for your selection.SQL Sentry Portal Storage Trends tooltip

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.

SQL Sentry Portal Storage select date and time

Note:  Select the button to switch to live data.

SQL Sentry Portal Storage Trends historical data exampleHistorical Data example
SQL Sentry Portal Storage Trends live data exampleLive Data example

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

SQL Sentry Portal Storage Trends filter graph
Select metric

SQL Sentry Portal Storage Trends graph filtered
Metric removed from graph

Select a Disk Volume to display a disk space forecast for the selection.

SQL Sentry Portal Storage Disk Volume Forecast

Warnings

SQL Sentry Portal tracks multiple warnings types across the storage entities in your monitored environment. Warnings display as redicons and are visible on the Overview chart. Select a storage entity with a warning icon to display more information about the warning in the Details tab.

Important:  Warnings in your monitored environment display hierarchically. For example, if you select your Controller, the Details tab will display all of the warnings in your environment. If you select an individual disk, the Details tab will display the warnings associated to the selected disk.

SQL Sentry Portal Storage Controller Details
SQL Sentry Portal Storage Disk Details

Select the on the column bar to sort by warnings.

SQL Sentry Portal Storage Details filter by the warning column

Select a Storage Warning link to be redirected to the selection.

SQL Sentry Portal Storage select warning linkSelect the desired warning link
SQL Sentry Portal Storage Warning link selectionStorage Warning selection

SQL Sentry Portal will notify you if your environment encounters any of the following warnings:

WarningDescription
TotalVlfsOver100 (vlfs = virtual log files)
Total VLFs over 100. Too many VLFs can cause long startup and backup times.
TotalVlfsOver300 (vlfs = virtual log filesTotal VLFs over 300. Too many VLFs can cause long startup and backup times.
AutogrowthUnderTenMegabytesAutogrowth under ten megabytes.
AutogrowthOverOneGigabyteAutogrowth over one gigabyte.
AutogrowthOverRemainingDiskSpaceAutogrowth over remaining disk space.
NonSimpleRecoveryModelAndNotBackedUpThis database is in a non-simple recovery model and is not backed up.
ForecastExhaustionWithinThirtyDaysThe forecasted exhaustion of this volume is within 30 days.
LowFreeSpacePercentage (Free space < 10%)This volume has low free space.