For resolving latency issues on a Nimble CS3000 storage system, particularly for a high-demand application like a 2TB ERP database, the best approach is to add additional SSD drives to the system as cache and PIN the volume. This ensures that the entire database or frequently accessed parts of it are always stored in the fastest storage tier (SSD), significantly reducing latency and improving overall performance for the ERP database.
References:
* HPE Nimble Storage
* HPE Storage Performance Optimization