Most of the people involved with storage deal on daily basis with performance and capacity monitoring. There are two metrics which everyone cares the most: size and IOPS. Of course, latency, queue depth and many more have significant impact as well. If you worked in enterprise storage you will notice that most of the time you will run out of IOPS before capacity.
HP 3PAR has several functionalities to help you get the most of your investment and today we will talk about Adaptive Optimization (AO).
This case will apply to hybrid array, such as the one having mixed of FC and SSD drives. In the example below I will help you understand how to calculate required capacity for each tier for a given application using 3PAR SSMC 3.0.
In our test scenario we will be running physical server connected to 3PAR 8200. Our test server will be hosting MsSQL database and have separate volumes for Data (.mdf) and Logs (.ldf) files. We notice that these volumes generate heavy load on our FC disk and we want to optimize it to provide more performance capacity for other applications sharing the same storage.
Our two volumes are here:
Well, the answer is quite simple here; first you need to log into SSMC and generate IO Density reports for these volumes.
Select CPG – Cumulative IO Density report template and select CPG which contains your volumes
Next enable Virtual Volume filter and select desired volumes:
and finally change chart details to Fine and access count to Percentage
Click create and you should see something similiar:
According to this graph roughly 90% of IOPs on these volumes are generated by 55% of data.
So now we do some math to see how much SSD capacity we need for our “hot” data:
SQL_DATA – 55% of 600GB = 330GB
SQL_LOG – 55% of 722GB = 398GB
Thus, we need 728GB of SSD storage to offload 90% of IOPS generated by our SQL server. Depending on the application and it’s access patterns you can find that 90% of IOPS are generated by only 10% of capacity. Another thing to take into account is business cycles for application – some data might be “hot” only during special events, such as huge report at the end of the month will require read from all databases. AO is very powerful tool which can bring you maximum return on your investment and drastically improve performance if you deploy it properly.