Hello all
Im looking for a way of automating the Database Tuning Advisor tool of SQL Server 2005 with the help of sql agent so that i can schedule it on a regular basis to scan a trace file and then make it export the results in a text file.
The system would need no human interaction at all.
Is it possible?
I just found out this morning that yes it is possible for someone to automate the analysis and i thought i would share that information with you.You have to use the command "dta" wich run the analysis on the server.
It let you choose the file name (wich can be a trc,sql or xml), the session name, the file it will export the result to and a lot of other paremeter.
I just tried it and it work as fine as running the application directly.
To get more information about that command :
quote:
Dta -?
Dalesql
No comments:
Post a Comment