DTA (database tuning advisor) tool

Question

DTA (database tuning advisor) tool

dastagirid

SSCommitted

Points: 1810
More actions
August 9, 2009 at 11:16 pm

#213259

hi..
I searched lot in search engines ..but i didnt find DTA tool.
I need this software plase send me link to that tool.freesoftware tool for DTA.
Thanks
Dastagiri.D

Viewing 5 posts - 1 through 4 (of 4 total)

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

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

The database engine tuning advisor is also called DTE and it is installed with the server. You can activate it from management studio. From the menu you have to select Tools and then select Database Engine Tuning Advisor.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

dastagirid SSCommitted Points: 1810 More actions · Answer 2

hi..

I have installed SQL Server Management Studio express CTP.

In that I didnt find tools.

Thanks
Dastagiri.D

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

The Database tuning advisor is only included in Standard, Enterprise and Developer editions. You can either download a 180 day trial of Enterprise edition or you can buy developer edition ($50)

See the edition comparison - http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 4

This changes the picture completely:-). Express edition doesn’t have DTE as part of the installation. Unfortunately I don’t know about a free tool that does the same job. One remark that is not connected to the subject – Why are you using a CTP? You can use a free version that is ready for production use.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/