Tuning Advisor is Missing
-
Here's the version information for my installation of SQL Server:
Microsoft SQL Server Management Studio9.00.3042.00
Microsoft Analysis Services Client Tools2005.090.3042.00
Microsoft Data Access Components (MDAC)2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML2.6 3.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework2.0.50727.1433
Operating System5.2.3790
I'd very much like to use the Database Tuning Advisor (DTA) tool, however this installation does not appear to have it.
There is no link to it anywhere in the start menu tree, nor in the filesystem, nor in any tools menu that I can find. This is a production server, so.. making dramatic changes to the SQL Server installation is something I'd prefer to avoid. Is there a way to just download and install DTA itself? Or upgrade just the analysis services component or something? I've found lots of links (on the Internet) to information about DTA, but no links to anything that installs DTA.Thanks for any help!
Shavais
-
There should be an entry call "Database Engine Tuning Advisor" under the "Tools" menu?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
What does SELECT @@version return?
DTA shouldn't be run from the server. It puts additional load on the server. For that matter, it shouldn't be run against a production server. It should be run from a client machine against a test server, it's recommendations evaluated and then those recommendations applied to the production server.
You can install just the client tools on your machine (management studio, profiler, DTA, etc) without needing a database server installed as well.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
rbarryyoung (10/22/2008)
There should be an entry call "Database Engine Tuning Advisor" under the "Tools" menu?Tools menu of what program? The configuration manager? The management studio program? There is no such entry in any program I've found.
-
It should be in Management Studio. what edition are you running?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
GilaMonster (10/22/2008)
What does SELECT @@version return?DTA shouldn't be run from the server. It puts additional load on the server. For that matter, it shouldn't be run against a production server. It should be run from a client machine against a test server, it's recommendations evaluated and then those recommendations applied to the production server.
You can install just the client tools on your machine (management studio, profiler, DTA, etc) without needing a database server installed as well.
Thanks for the reply -
Here's what select @@version returns:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
The server is physically located over the Internet from me, and I have no LAN or WAN access to it. Nor any direct physical access to it. I can only RDP into it. I'm not sure I could successfully run DTA from my machine against the server.. I'd probably have to open firewall ports and such, which I'd prefer not to do. I can appreciate the fact that running the tool on the server would load it down, but the business requires improving the speed of the database quite a bit in as short a time as possible. Part of that more-or-less requires capturing the actual SQL people are running on the live server. Current load isn't really an issue, future performance is a critical issue. (We must expand, and we can't do it without dramatically improving performance.)
Anyway, whether I run DTA from some other box against the server or run it on the server itself, I need to know where to get it. So I guess it comes with the client tools? Can I download just the client tools from somewhere?
Thanks again for your help!
-
shavais (10/22/2008)
So I guess it comes with the client tools? Can I download just the client tools from somewhere?Thanks again for your help!
No, the client tools are not available for download. You can install them from the DVD that SQL came on. My guess is that when it was installed only the basic management tools were installed. That may explain why you don't have DTA. Do you have profiler? What options are shown on the Tools menu of Management Studio?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply