In the Fractional Space Reservation Settings dialog box, use the Current Settings tab to view the current space consumption in the storage system volumes that contain LUNs that store SQL Server data or SnapInfo directories.
Drive Letter or Mountpoint A SnapManager configuration setting for the LUN. The drive letter or NTFS mount point on which the LUN is mounted.
Fractional Reserve (%) The amount of space reserved for overwrites on the storage system volume that contains this LUN. Expressed as a percentage of the total size of all space-reserved LUNs in the volume.
Backup Autodelete Trigger (%) A SnapManager fractional space reservation policy setting for the storage system volume that contains the LUN. The percentage of overwrite reserve utilization that triggers automatic deletion of SQL Server backup sets.
Disable Database Trigger (%) A SnapManager fractional space reservation policy setting for the storage system volume that contains the LUN. The percentage of overwrite reserve utilization that triggers automatic disabling of SQL Server databases.
Used Reserve For the storage system volume that contains this LUN, the amount of overwrite reserve in use. Expressed in two ways: as a percentage of the total size of all space-reserved LUNs in the volume and in megabytes.
Available Reserve (MB) For the storage system volume that contains this LUN, the amount of overwrite reserve available.
Snapshot Autodelete For the storage system volume that contains this LUN, the state of the Data ONTAP Snapshot copy autodeletion feature: enabled or disabled. If this LUN stores SQL Server data files and is contained in a storage system volume for which the Data ONTAP Snapshot copy autodeletion feature is enabled, disable this feature on that volume or ensure that it is configured so that it will not delete SnapManager backup set components.
To view the current space consumption information about each LUN, complete the following steps.
Step | Action | |
---|---|---|
1 | Select Fractional Space Reservation Settings in the SnapManager Actions pane. |
|
2 | In the Current Status tab, note the space consumption status for each LUN that stores SQL Server data or SnapInfo directories.
Note: The SnapManager
fractional space reservation policy triggers (listed above) are
not applicable to fully space-reserved LUNs.
Note: If
Fractional Overwrite Reserve (%) is 100, the LUN is contained in
a fully space-reserved volume rather than a fractionally space-reserved
volume.
The information displayed in this tab is automatically refreshed every 60 seconds. Note: Only the Drive
Letter or Mount Point column displays LUN-specific information.
All other columns in this tab display information that applies across
the storage system volume that contains the LUN.
|
|
3 | If the Snapshot Autodelete column is enabled, investigate the cause and take preventive action if necessary. Attention: If the Storage Snapshot Autodelete column
is enabled, the LUN is contained in a FlexVol volume that has overwrite
reserve set to less than 100 percent and that also has the Data
ONTAP automatic Snapshot copy deletion feature enabled and configured
to trigger when the overwrite reserve is nearly full. If SQL Server
data or SnapManager SnapInfo directories are stored on LUNs contained
in a volume with these characteristics, the Data ONTAP Snapshot
copy autodeletion policy might delete SQL Server backup set components.
Take one of the following actions on the volume:
For details about the snap autodelete storage system command, see the Data ONTAP SAN Administration Guide for 7-Mode. Note: The SnapManager fractional space reservation
policy includes a separate, SQL Server-aware autodeletion feature.
For details, see Fractional space reservation policies manage SQL Server data
and Configuring fractional space reservation policies. The
SnapManager autodeletion feature can be used in place of or in conjunction
with the Data ONTAP autodeletion feature; you can also select to
disable the SnapManager autodeletion feature.
|
|
4 | To close the dialog box, click OK. |