multiple sql 2008 r2 instances

Posted on 2011-04-18
Last Modified: 2012-05-11
Best practices stacking multiple SQL 2008 R2 Instances on a host connected to NetApp Mount points.

Any info is appreciated
Question by:dblake15
    1 Comment
    LVL 28

    Accepted Solution

    Are you talking about using the Netapp mount points for your back-end storage of the data? Though it's not really clear, I don't believe Netapp does any kind of front-end access, so you must mean doing remote storage.

    The best practice for multiple instances of SQL Server is the same as a single instance, except that you add more drives for each additional instance of SQL to keep them separate (though separating the drives doesn't help if they're sharing spindles on the netapp box, so be careful there). In that case, just the standard advice - logs/tempdb on one partition and data files on another (with any highly active data files on their own). Where you'd have 2 extra partitions in a single instance SQL server, you'd have 4 in a two instance, 6 in a three-instance - you get the idea.

    Pretty straightforward, but make sure you're putting them on different sets of spindles on the NetApp - you can divide all the data across 100 partitions on your SQL server, but they share spindles on the NetApp, you'll be hurting when the SQL box is under pressure.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now