Can I install SQL 2008 Performance Tools on a live server

Posted on 2009-12-18
Last Modified: 2012-05-08

I need to install the SQL 2008 performance tools on a live db server (Win 2k3 R2) without interrupting the services. Can I do this safely?


Question by:the1paulcole
    LVL 14

    Accepted Solution

    The SQL Server 2008 Setup validates your computer configuration before the Setup operation completes, so you should be able to select the performance tools in the setup and it will tell you if a reboot is required to add those features, if it is then just cancel the setup and schedule it for a time when you can reboot the server.

    How to: Add Features to an Instance of SQL Server 2008 (Setup)

    Feature Installation Rules

    However since it is only the performance tools I would suspect that it does not require a reboot.
    LVL 1

    Author Closing Comment

    Excellent, cheers for that, couldn't have asked for a better response!

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 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