SQL 2008 Performance Tools

  • Hi

    I am trying to install SQL server 2008's Performance Tools on my client xp box

    the tools that i need is DB Engine Tuning Advisor and SQL Server Profiler.

    can you help me out how and where i can get this install for client?

    thanks

  • If I am not mistaken, you will need to install SSMS Client from your SQL Server 2008 Installtion CD.

    -Roy

  • I have SSMS Client installed but that dosent have this Performance Tools 🙁

  • So you dont see the Sub menu of Performance tools? Strange.. It is actually part of the SQL Server 2008 Set up CD.

    -Roy

  • no it comes when i install it on the server.. but now i need this on my PC

  • You could try to do a Command line set up to get the performance tools. I read in another site how to do this. On command prompt go to the directory where Setup.exe is and use the command below. It will install all Advanced features

    setup.exe /q /ACTION=INSTALL /FEATURES=ADV_SSMS

    -Roy

  • wow it worked ... Thanks a lot Roy 🙂

  • No problem at all. Enjoy tuning queries. It is fun..:-)

    -Roy

  • Nice work Roy.

    Marco

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply