SAN storage processor cache and database performance

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?
LVL 11
it-rexAsked:
Who is Participating?
 
Duncan MeyersCommented:
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.
0
 
it-rexAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.