patternMinor
Tuning advisor with Extended events?
Viewed 0 times
eventswithtuningextendedadvisor
Problem
With SQL traces I was able to analyze them with Database Engine Tuning Advisor to obtain basic recommendations for perf. tuning(missing indexes, statistics,...).
Now, with SQL 2012 and Extended Events, how can I do something similar?
Thanks
Now, with SQL 2012 and Extended Events, how can I do something similar?
Thanks
Solution
Unfortunately you cannot do this with Extended events unless the data from XE can be converted into the format that DTA uses or can be stored in the tables generated by DTA.
Not recommended though but Trace is is still available, so can be used if you want.
You can even use DMV's for finding missing indexes, etc.
Also worth mentioning Aaron's post : Don't just blindly create those "missing" indexes!, since you are using DTA for analysis.
Not recommended though but Trace is is still available, so can be used if you want.
You can even use DMV's for finding missing indexes, etc.
Also worth mentioning Aaron's post : Don't just blindly create those "missing" indexes!, since you are using DTA for analysis.
Context
StackExchange Database Administrators Q#39779, answer score: 3
Revisions (0)
No revisions yet.