HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Tuning advisor with Extended events?

Submitted by: @import:stackexchange-dba··
0
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

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.

Context

StackExchange Database Administrators Q#39779, answer score: 3

Revisions (0)

No revisions yet.