14,494 questions
It's possible, even if I wonder what's good for.
You find the tool in
C:\Program Files (x86)\Microsoft SQL Server\ <VersionNo> \Tools\Binn => DTASHELL.exe
Change <VersionNo> to the version you use, e.g. 120
How tuning a t-sql query directly inside the Database Engine Tuning Advisor
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pmscorca
1,052
Reputation points
Hi,
I need to tuning a t-sql query by the DTA tool operating directly inside it without using the SSMS, where selecting first the query and then the DTA.
Is it possible, and how? thanks
SQL Server Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2021-05-06T09:52:11.68+00:00 Hi @pmscorca ,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia
Sign in to comment
5 answers
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points2021-04-30T10:57:15.89+00:00 -
pmscorca 1,052 Reputation points
2021-04-30T12:44:10.903+00:00 Hi, thanks for your reply.
I try to explain better the question.
Usually, inside a query window opened in SSMS I specify the query to tune, select it and then with the mouse right-click call the DTA tool, that shows the Query option as a workload.
In a SQL installation, for an error I cannot accomplish the described action and so I neee to specify the query to tune inside the DTA tool, if possible of course.
Thanks-
Olaf Helper 47,436 Reputation points
2021-04-30T13:02:59.573+00:00 Start the tool directly, the you see what options you have, e.g. loading SQL file, trace and so on.
Sign in to comment -
-
pmscorca 1,052 Reputation points
2021-04-30T13:30:08.337+00:00 Ok, I've noticed that the query code isn't saved inside the selected script file.
Thanks-
Olaf Helper 47,436 Reputation points
2021-05-01T07:28:42.717+00:00 ????
Don't understand what you mean?
Sign in to comment -
-
pmscorca 1,052 Reputation points
2021-05-01T08:01:13.53+00:00 Hi Olaf,
inside the DTA I've tried to select a file as a workload, but the query code in this file wasn't saved (likely to a my inadvertence).
Ok? -
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
2021-05-03T07:28:35.103+00:00 Hi pmscorca-6887,
In addition, DTA is inbuilt tool which comes with SSMS.
You can download and install SSMS 18.x to launch the DTA from SSMS. You also can launch it from \Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\DTASHELL.EXE if you find your workload file.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.