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…..

676 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.

  14. Exploring the Innovative Kazbaz.ru No-Cost Classifieds Board

    In the age of digital connectivity, virtual platforms play a pivotal role in enabling seamless transactions and connecting buyers and sellers.
    Kazbaz.ru, the cutting-edge Free Classifieds Board,
    ushers in a new era of online trading. In this piece, we dive into the
    remarkable features that distinguish Kazbaz.ru apart as the pinnacle of virtual trading excellence.

    A Glimpse into Kazbaz.ru’s Distinctive Offerings:
    Kazbaz.ru No-Cost Classifieds Platform represents advanced innovation in the realm
    of online trading, providing users an all-encompassing platform
    for effortless exchanges.

    1. Free Ad Placements:
    Kazbaz.ru revolutionizes the commerce scene by eliminating advertising costs, enabling users to
    showcase their products and services free from cost constraints.
    This unique approach stimulates wider participation from users and enterprises.

    2. Wide Array of Categories:
    Kazbaz.ru’s No-Cost Classifieds Board covers a diverse range
    of categories, guaranteeing that users can easily find the perfect category for their listings.

    3. International and Community Exposure:
    While focusing on local interactions, Kazbaz.ru additionally
    extends its reach globally, providing users opportunities for
    local and global trade.

    4. Streamlined Communication:
    Kazbaz.ru promotes open dialogue between participants, simplifying deal discussions and building
    confidence within the venue.

    5. Customer-Centric Environment:
    Kazbaz.ru emphasizes customer contentment through its intuitive design and supportive community.

    Kazbaz.ru’s No-Cost Classifieds Board stands as a
    leading light in the world of online trading, redefining
    accessible online trading. Its no-cost approach, comprehensive category selection,
    dual reach, smooth interaction, and customer-centered emphasis elevate it beyond the competition. Experience the
    enriching benefits of Kazbaz.ru’s No-Cost Classifieds Platform today,
    and initiate a journey of boundless opportunities in the world of online
    commerce.

  15. email bomber – (Info Email bomber https://t.me/s/floodservice/265 )

    Email Bombing – email flood or email hoax (DOS attack) or cluster email bombing, what are they actually doing?

    A huge number of emails are sent to e-mail. This usually means that the @FloodService_bot bot specifically targets the victim’s mailbox associated with your email.

    These emails are intended to make fun of friends or distract the victim from any security messages or other emails.

    I am glad to present you a mail flood bot with a convenient menu and flexible settings!

    The cost of the service is $ 2 = 1000 letters.

    You specify the time of the flood and the number of letters yourself, or choose the “FAST FLOOD” function

    During the flood, a sufficient number of letters arrive so that the owner would miss an important letter!

    The bot will flood more than you ordered. On average, 30% more than ordered.

    Flood email, Floods Email, Email flooding, gmail flood, email bomber, flood hotmail, flood online,email flooding, email flood bot, email flooded with spam, email flooding service, email flooded with subscriptions, email flooder bot, email bomber 2023, email bomber 2024, email spam bot online, email spammer bot free, spam bot, бот по флуду почт, сервис по флуду почт, услуги по флуду, флуд услуги.
    @FloodService_bot – Лучший емаил бомбер на рынке!

Leave a Reply to Dzmilx Cancel reply

Your email address will not be published. Required fields are marked *