Community

Subscribe
Highlighted

Reallocate measure

I was working on optimizing performance for MS SQL volumes and have quite a good feedback from DBAs
However I still want to know how to properly read out put of reallocate measure command.

What is the meaning  of string optimization.  all other are self explainable.

Reallocation scans are on
/vol/sqlserver1/lun.0:
        State: Idle
     Schedule: n/a
     Interval: 1 day
Optimization: 1
  Measure Log: n/a

/vol/vanibisqlwqa1_sprocket_insightstglog/lun.0:
        State: Idle
     Schedule: n/a
     Interval: 1 day
Optimization: 1
  Measure Log: n/a

thanks

Re: Reallocate measure

This is fragmentation level. 1 is the best (no fragmentation). Max depends on Data ONTAP version, historically it was 16, today I think it can go up to 64.

Re: Reallocate measure

So to summarize 1 is the best and 64 is the worst. Is it correct ?

PS is there any doc, TR etc... ?

Re: Reallocate measure

Yes, correct. There is reallocation TR, do not have number handy.

Re: Reallocate measure

Thanks,  just right on time,