Data Backup and Recovery

Reallocate measure

vims

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

6 REPLIES 6

Oscar73

Hello,

 

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

 

Thanks for your feedback.

aborzenkov

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.

vims

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

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

aborzenkov

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

vims

Thanks,  just right on time,

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public