Subscribe
Accepted Solution

Snapshot space allocation continues to grow.

HI

I have an MS SQL db server with SnapManger for SQL which I have som problem with. From time to time I get following alert from opretion manager " The volume is 85.44% full (using 59.8 GB of 70.0 GB)". I usually resize the volume,

but it is not sustainable in the long run. SnapManager is configured to save two snapshot copies. When I reszie the volume the LUN is still the same, how can I use the area between the LUN and the snapshot copies?

Rgds

Tobias 

Re: Snapshot space allocation continues to grow.

Hi,

Can you provide the output of:

vol status <volname> -v

lun <lunpath> -v

df -r <volname>

df -s <volname>

Regards,
Radek

Re: Snapshot space allocation continues to grow.

Hi

Here´s the output from a volume with the same problem. I couldn´t get the output from "lun <lunpath> -V" ???

faspri02> vol status Servernamn_fcdb04 -v
         Volume State           Status            Options
SERVERNAMN_fcdb04 online          raid_dp, flex     nosnap=on, nosnapdir=off,
                                                  minra=off, no_atime_update=off,
                                                  nvfail=off,
                                                  ignore_inconsistent=off,
                                                  snapmirrored=off,
                                                  create_ucode=on,
                                                  convert_ucode=on,
                                                  maxdirsize=73400,
                                                  schedsnapname=ordinal,
                                                  fs_size_fixed=off,
                                                  compression=off,
                                                  guarantee=volume, svo_enable=off,
                                                  svo_checksum=off,
                                                  svo_allow_rman=off,
                                                  svo_reject_errors=off, no_i2p=on,
                                                  fractional_reserve=0, extent=off,
                                                  try_first=volume_grow,
                                                  read_realloc=off,
                                                  snapshot_clone_dependency=off,
                                                  nbu_archival_snap=off
                         Volume UUID: 21c40724-49ea-11e1-8c33-00a098143420
                Containing aggregate: 'aggr1'

                Plex /aggr1/plex0: online, normal, active
                    RAID group /aggr1/plex0/rg0: normal
                    RAID group /aggr1/plex0/rg1: normal
                    RAID group /aggr1/plex0/rg2: normal

        Snapshot autodelete settings for SERVERNAMN_fcdb04:
                                        state=on
                                        commitment=try
                                        trigger=volume
                                        target_free_space=20%
                                        delete_order=oldest_first
                                        defer_delete=user_created
                                        prefix=(not specified)
                                        destroy_list=none
        Volume autosize settings:
                                        state=on
                                        maximum-size=72 GB
                                        increment-size=3 GB

Filesystem              kbytes       used      avail   reserved  Mounted on
/vol/SERVERNAMN_fcdb04/   62914560   50220444   12694116          0  /vol/SERVERNAMN_fcdb04/
/vol/SERVERNAMN_fcdb04/.snapshot          0    8087888          0          0  /vol/SERVERNAMN_fcdb04/.snapshot

Filesystem                used      saved       %saved
/vol/SERVERNAMN_fcdb04/   50220444          0           0%

Rgds

Tobias

Re: Snapshot space allocation continues to grow.

Sorry, I missed one word! It should be:

lun show <lunpath> -v

Re: Snapshot space allocation continues to grow.

Don´t know if Iám doing something wrong, but I can´t get any information

lun show /vol/SERVERNAMN_fcdb04/SERVERNAMN_lunnamn -V

Rgds

Tobias

Re: Snapshot space allocation continues to grow.

Tobias,

You may wish to use '-v' (Not the capital -V) flag.

Good luck

Henry

Re: Snapshot space allocation continues to grow.

Hi

I have tried with both -v and -V and it still dosen´t work. 

Rgds

Tobias

Re: Snapshot space allocation continues to grow.

Hi Tobias,

Apologies - I got it wrong second time around! :-/

The correct syntax:

lun show -v <lunpath>

That said, looking at previous outputs I don't see anything surprising / unusual so far: 60g volume with ~48g space taken. If the latter is equal to your LUN size, everything looks just normal to my eye.

Regards,

Radek

Re: Snapshot space allocation continues to grow.

Hi Radek

Here´s the lun output

faspri02> lun show -v /vol/SERVERNAMN_fcdb04/SERVERNAMN_qtree_db01/SERVERNAMN_db01

        /vol/SERVERNAMN_fcdb04/HPASQLDB01_qtree_db01/SERVERNAMN_db01   40.0g (42952412160)   (r/w, online, mapped)

                Serial#: dfPsK4hrI0dc

                Share: none

                Space Reservation: enabled

                Multiprotocol Type: windows_2008

                Maps: SERVERNAMN=13

                Occupied Size:    4.8g (5150593024)

                Creation Time: Thu Jan 26 22:06:23 CET 2012

                Cluster Shared Volume Information: 0x0

Rgds

Tobias

Re: Snapshot space allocation continues to grow.

Hi,

Everything looks just 'normal' I'd say - with the exception of one thing: your snapshots occupy a *lot* of space!

You have fully provisioned 60g volume with 40g space reserved LUN in it. It looks though like there is only 4.8g of data inside the LUN, whilst snapshots are taking ~8g of space.

Are some of the snapshots really old? Or are you running any database maintenance tasks, reindexing, etc.? Or maybe disk defrag on Windows OS?

Regards,

Radek