Windows Server 2008 R2 and SQL 2008 R2 Cluster best practices and performance tweaks

Posted on 2011-10-12
Last Modified: 2012-06-27
I am looking for best practices and performance tweaks for a three node Windows Server 2008 R2 Cluster for SQL Server 2008 R2. Thanks in advance for your help.
Question by:ctc1900
    LVL 13

    Assisted Solution

    LVL 10

    Assisted Solution

    LVL 4

    Author Comment

    Thanks for the links, they are very useful.   Do any of you guys know where I can find a best practices document from Microsoft on Windows Server 2008 SQL clustering?  Thanks
    LVL 13

    Accepted Solution


    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    746 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

    19 Experts available now in Live!

    Get 1:1 Help Now