topic Re: Reallocate measure in Data Protection

Reallocate measure

vims — Fri, 18 Dec 2015 09:14:00 GMT

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

aborzenkov — Sat, 04 May 2013 12:10:28 GMT

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

vims — Tue, 07 May 2013 22:48:45 GMT

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

aborzenkov — Wed, 08 May 2013 04:05:15 GMT

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

Re: Reallocate measure

bsti — Wed, 08 May 2013 15:17:51 GMT

TR-3929

http://www.netapp.com/us/system/pdf-reader.aspx?pdfuri=tcm:10-106035-16&m=tr-3929-new.pdf

Re: Reallocate measure

vims — Wed, 08 May 2013 16:01:21 GMT

Thanks, just right on time,

Re: Reallocate measure

Oscar73 — Tue, 01 Dec 2015 17:30:52 GMT

Hello,

For reallocation command to be successfully run is there an space restrictions that we should have on the Aggregates?

Thanks for your feedback.