Performance Tools not visible

We have SQL 2005 as part of SBS 2003 R2. We do not have Performance Tools as a menu option, even though we selected to install all and have subsequently applied SQL SP2. What steps are needed to include this on the menu? We have other SQL installations where it was installed ok, but they were with W2003 and SQL Standard and SQL Enterprise editions.

I assume you are referring to SQL Profiler. It should be installed with the rest of the client tools for any SKU higher than SQL Server Express. If it's installed on your machine, by default it is in %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn. The program name is Profiler90.exe.

If the Start menu item is missing for some reason, you can create a new shortcut in your Start menu for SQL Profiler by doing the following:

1) Start Windows Explorer

2) Tools > Folder Options > View, check "Show hidden files and folder", then close the dialog

3) Expand C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft SQL Server 2005

4) Create a subdirectory under Microsoft SQL Server 2005 called "Performance Tools" (if you don't have one already)

5) Right click on Profiler90.exe and drag it to the new Performance Tools folder. Select "Create Shortcuts Here" in the resulting context menu.

6) Optionally, rename the shortcut to "SQL Server Profiler" (or any other name you like)

Note that your SQL Server Standard and SQL Server Enterprise licenses allow you to install the client tools on any machine you like, so you can install just the client tools from your Enterprise setup DVD on your SBS machine if you need to.

Hope this helps,

Steve

|||Does profiler come with Workgroup? Which I believe is what SBS 2003 R2 installs?|||

SQL Server Profiler only comes with Standard Edition and Enterprise Edition SKUs:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

SBS 2003 comes with Workgroup, so the tools are not available. You can use Profiler from your Standard/Enterprise editions to analyze trace information from your SBS 2003 server.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

sql