storage selection for a database

It is amazing how friendships help business relations. I have a friend who is working at NetApps and we are both calling on the same account. We started to recommend conflicting information to the customer based on the knowledge of our own worlds. Once we talked, I understand his perspective and I think that he understands mine. We are now talking about how we can jointly present to this customer and even coordinate our messages with each other and through our recommended consulting organization.

Here’s the situation. We have a customer that is running an old version of Oracle (9i) on an old operating system (Solaris 8) on old hardware (Fujitsu some older model) attached to a NetApps filer (three generations ago). The customer is experiencing significant performance problems. They have two applications that they are running against the database. One is an ERP system that has a relatively low transaction count. The other is a business objects application that is consuming all of the resources. Normally this would not be a problem but the business objects app is consuming all of the resources and causing the ERP system to lock up and interrupt business.

Simple solution right? Find the bottleneck and fix it. Well, it isn’t that simple. NetApps did a detailed analysis and found that the disk is 90% busy. The network is 60% busy. If they double the disk speed and reduce the latency by half, the network will become a problem. Fortunately, the business objects app is configured to be a read only analysis of the database. If we can split the database out, we can significantly improve the ERP performance.

Given a computer science/electrical engineering background, my first impression was that NFS mounting the data was the biggest problem. If they could move to direct attach disks, it would improve performance. This would get rid of the network loading and allow them to purchase faster disks at the same time. What I didn’t realize was that they would also need to purchase a fiber channel switch and learn how to manage this as well. I did know that NFS management was easy, I’ve been doing it for years. I didn’t realize that SAN management is an art to itself and is significantly more complex and expensive to manage. Looking into this subject a little more I was amazed to find that NFS does not substantially effect performance if tuned properly. An NFS system is only 12% slower than a fiber attached system and 2% slower than iSCSI.

The recommendation that we are moving forward with is a second database system that replicates the primary data using DataGuard with physical replication. Once this is done, redirect the business object app to hit the standby database and purchase a second netapp filer to offload the original system. The added benefit is that this configuration is the foundation for disaster recovery since both apps are currently running on one machine. Even though the standby system will be in the same datacenter it will provide redundancy for the primary system.

The performance results and complexity of SAN storage amazed me. Both were contrary to my thinking. Once I looked at it from this perspective, it makes sense. Live and learn…..

677 thoughts on “storage selection for a database”

  1. I have to get across my respect for your kindness supporting folks who should have help with this important niche. Your very own dedication to getting the solution all over had been extraordinarily helpful and has frequently made individuals just like me to attain their endeavors. Your entire interesting key points implies much to me and even further to my fellow workers. Thank you; from each one of us.

  2. I’m also writing to let you be aware of of the remarkable experience my daughter gained using your blog. She figured out so many pieces, not to mention how it is like to possess an ideal helping spirit to have other folks just understand selected multifaceted things. You truly surpassed visitors’ expectations. I appreciate you for churning out the useful, healthy, revealing not to mention fun thoughts on the topic to Janet.

  3. I wanted to write you one bit of note to help say thanks once again relating to the gorgeous techniques you have documented in this article. It is certainly wonderfully open-handed of you to give easily exactly what most of us would’ve made available as an e-book to make some money on their own, chiefly given that you could possibly have tried it in case you wanted. These tricks also served to become a easy way to be certain that other people have the identical fervor much like my own to figure out many more in regard to this matter. Certainly there are a lot more fun instances in the future for those who discover your website.

  4. I not to mention my guys were checking the best strategies on your web page while instantly I got a terrible suspicion I never thanked the web blog owner for those secrets. All of the men became certainly happy to learn them and have in effect surely been having fun with these things. Many thanks for turning out to be so accommodating as well as for picking this sort of extraordinary tips most people are really needing to be aware of. My personal sincere regret for not saying thanks to you earlier.

  5. My spouse and i have been very delighted that Jordan managed to complete his investigations from your ideas he was given through your web pages. It’s not at all simplistic to just continually be making a gift of strategies which most people might have been trying to sell. We already know we have got the writer to give thanks to for this. The type of illustrations you have made, the easy website menu, the relationships you help to engender – it is all remarkable, and it’s making our son and us believe that that concept is entertaining, which is pretty serious. Thanks for everything!

  6. Thank you a lot for providing individuals with such a spectacular possiblity to read articles and blog posts from this site. It’s always very superb and as well , packed with a great time for me personally and my office fellow workers to search the blog on the least 3 times in 7 days to see the newest stuff you will have. And indeed, I am also at all times motivated considering the very good techniques you give. Certain 3 facts in this article are ultimately the most effective we have all had.

  7. I simply wanted to send a simple note so as to thank you for all of the splendid suggestions you are posting on this website. My extensive internet research has at the end of the day been honored with high-quality content to go over with my family and friends. I ‘d express that most of us website visitors actually are really fortunate to exist in a notable network with many lovely individuals with useful principles. I feel somewhat blessed to have used the webpages and look forward to tons of more fun times reading here. Thank you again for everything.

  8. I precisely desired to thank you so much once more. I do not know what I might have undertaken in the absence of these pointers documented by you on my question. Completely was an absolute frightening matter for me, nevertheless coming across a professional manner you managed that forced me to weep for gladness. Now i am happier for your work as well as hope you know what a great job that you’re providing training people today through the use of your web page. I’m certain you haven’t got to know all of us.

  9. I precisely desired to say thanks once more. I do not know the things that I would’ve achieved without the pointers contributed by you regarding this field. Entirely was the horrifying circumstance in my circumstances, but encountering your professional mode you handled it forced me to jump with gladness. Now i am grateful for the work and then expect you are aware of an amazing job that you’re putting in educating other individuals using your blog post. More than likely you’ve never encountered all of us.

  10. I actually wanted to make a remark to thank you for all the magnificent solutions you are giving out here. My time-consuming internet lookup has at the end of the day been recognized with brilliant facts and techniques to share with my good friends. I would assert that we site visitors are very lucky to be in a fine site with very many perfect professionals with very beneficial strategies. I feel really privileged to have come across your entire webpage and look forward to really more fun times reading here. Thanks a lot again for everything.

  11. I together with my pals came studying the excellent guidelines located on your web page while unexpectedly came up with an awful suspicion I had not thanked the website owner for those techniques. Those boys ended up for this reason joyful to read through all of them and have in effect seriously been enjoying those things. Thank you for actually being very thoughtful and also for making a decision on this form of essential tips millions of individuals are really needing to be informed on. My very own honest apologies for not expressing appreciation to you earlier.

  12. My spouse and i were really relieved that Peter managed to round up his inquiry using the ideas he obtained out of your site. It is now and again perplexing to simply always be giving for free guidelines which often the rest might have been selling. And we all figure out we have the blog owner to thank for this. All the explanations you made, the straightforward web site menu, the relationships you will aid to foster – it is everything wonderful, and it is helping our son in addition to our family do think the theme is enjoyable, which is certainly pretty pressing. Thanks for all the pieces!

  13. I enjoy you because of all your valuable hard work on this web page. My mother takes pleasure in engaging in investigation and it’s really simple to grasp why. I notice all regarding the lively means you provide both useful and interesting information via this web blog and foster participation from some other people on the idea so our own girl is without a doubt being taught a whole lot. Take pleasure in the remaining portion of the new year. You are always performing a really great job.