Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SAN storage processor cache and database performance

Posted on 2012-08-15
Medium Priority
Last Modified: 2012-09-26
We have an (EMC Celerra NS-480)which is not performing very well. So far SSD is not a choice,And we were wondering if we increase the storage processor cache which is defaulted to 4GB will this improve our performance?
Our biggest segment/table size is 8 GB, if we need to increase the SP cache what should be the value we go for?
Question by:it-rex
LVL 30

Accepted Solution

Duncan Meyers earned 1500 total points
ID: 38299201
In short - no. You can't increase the cache size.

If you're experiencing performance problems, it's better to fix the root cause. Are you sure that the array is the problem?

Have you measured the number of read and write IOPS the application is generating?
What is the response time on the array?
What is the response time on the host?
What sort of disks are you writing to?
How many disks in the RAID group?
Are the disks for the database alone, or are the disks shared with other apps?
Are you using Fibre Channel or iSCSI?
Is the host on VMware or is it physical.
LVL 11

Author Closing Comment

ID: 38438777

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Samsung SSD 840 EVO and 840 EVO mSATA have a well-known problem with a drop in read performance. I first learned about this in an interesting thread here at Experts Exchange: http://www.experts-exchange.com/Hardware/Storage/Hard_Drives/Q_2852…
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Suggested Courses
Course of the Month10 days, 20 hours left to enroll

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question