Table of ContentsView in Frames

Viewing fractional space reservation status

Viewing fractional space reservation status

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.

  • The following columns displays SnapManager configuration information:
    • Drive Letter or Mount Point
    • Fractional Overwrite Reserve(%)
    • Backup Autodelete Trigger (%)
    • Disable Database Trigger (%)
Note: The SnapManager fractional space reservation policy triggers (listed above) are not applicable to fully space-reserved LUNs.
  • The following columns displays the fractional overwrite reserve settings and status:
    • Used Overwrite Reserve (%)
    • Used Overwrite Reserve (MB)
    • Used Reserve (MB)
    • Available Reserve (MB)
    • Storage System Snapshot Autodelete
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:

  • Disable the Data ONTAP Snapshot copy autodelete feature.
  • Ensure that the Data ONTAP Snapshot copy autodelete feature is configured in such a way that it will not delete SQL Server backup set components.

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.