SAN storage processor cache and database performance

Posted on 2012-08-15
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

    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


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Hyper-convergence systems have taken the IT world by storm and have quickly started to change our point of view of how the data center should and could be architected. In this article, I’ll explain the benefits of employing a hyper-converged system …
    this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works. the topics in the following article covered are, 1) dell hardware raidlevel (Perc) 2) adding HDD 3) how t…
    Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
    In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now