The 10-Step Storage Optimization Methodology
In current data center environments where on an average the storage requirements doubles every 12 to 18 months, Storage Optimization becomes a very important function and technique, that needs to be incorporated into the storage architecture and design ahead of time and then followed up constantly as part of the Capacity Planning process on regular basis. When we say Capacity Planning, we include satisfying storage performance requirements (performance SLA’s) besides making sure that enough storage capacity exists in terms of gigabytes to manage storage operations.
Both Storage Capacity and Storage Performance are key aspects of any Storage Optimization methodology. We want to optimize our data center storage utilizations and hardware utilizations to have the best cost optimized solution that meets the requirements on daily basis and provides enough headroom to meet any SLA’s that are required by the end-user applications.
For a near holistic Storage Optimization strategy we need to make sure that the various layers from storage arrays to host file systems are managed in an optimized fashion on the minimum. The database layer should be included (e.g. DB files or raw DB devices) to be more complete in the approach. At a high level the storage optimization can be categorized at the storage capacity level and at the storage performance level. Keeping this in mind, a detailed 10-step Storage Optimization methodology can be as follows:
Capacity Based Optimization – Storage Array and Host Level
STEP 1 – Baseline Capacity allocations for each host at the storage array.
STEP 2 – Identify any hosts that are offline (not logged into SAN) – This is a low hanging fruit in terms of reclaiming storage – Opportunity for storage reclamation.
STEP 3 – Compare storage allocated at the array level for the host (at WWN level) versus storage actually configured at the host OS Level – Opportunity for storage reclamation if the host level shows less.
STEP 4 – Calculate overall File system utilizations at host level (e.g. running “df” command on unix systems)– Opportunity for storage reclamation if utilizations are low.
STEP 5 – Calculate overall Database File utilizations at database level – Opportunity for storage reclamation if utilizations are low at the DB file level.
Performance Based Optimization – Host IO Profile, but at Storage Array Level
STEP 6 – Baseline Performance Profile for each host at the storage array level for a 24 hour peak day. This can be done by aggregating IOPS for all devices masked to the host WWN. Calculate Peak IOPS and 95th Percentile for best practice planning.
STEP 7 – Match IO Profiles for each host to a currently defined Performance Tier. The SLA for this IO profile could be matched using a lower tier. Many hosts may be able to go to a lower tier, without impacting SLA for application performance – Opportunity for lowering cost in terms of $/GB for cost optimization.
Performance Based Optimization – Storage Array Level
STEP 8 – Identify storage arrays that have low IOPS and MBPS load as compared to the hardware configuration – opportunity for consolidation.
STEP 9 – Create a best-fit consolidation plan based on capacity, performance (IOPS & MBPS) and configuration for all storage arrays not being fully utilized from hardware resource perspective.
STEP 10 – Migrate hosts at array level based on detailed consolidation plan making sure best-fit analysis is also done for storage array front-end load planning. This leads to lower TCO at the array level by defining optimized storage pools and having the right number of front-end and back-end adapters.
The nice thing about this methodology is that the one can start from step 1 and go as deep as needed based on tools and resource availability. For example, one can only do step 1 and step 2 for storage reclamation as these are the least resource intensive. The OEM tools can be leveraged as provided by the storage vendors to do these but it will take time to get the proper planning done. Home grown tools can also be developed to perform this optimization.
Tools like Perfonics™ developed by Interscape Technologies Inc. and pro-active services like Performance As A Service™ can be leveraged by contacting Interscape Technologies Inc. These services provide a 3T approach to the any type of project by bundling the Technician (SME), Tool (Perfonics™) and the Team (R&D) as part of the project.
Alok Jain