Reallocate measure [ Edited ]

[#1]

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

[#2]

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.

[#3]

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

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

[#4]

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

[#5]

TR-3929

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

[#6]

Thanks,  just right on time,

[#7]

Hello,

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

Thanks for your feedback.