DTA execution problem

Question

I'd like to use the database engine configuration wizard to create an optimisation plan using the plan cache.

When I select the databases I'm interested in and launch the analysis, an error immediately appears: Impossible to extract the workload from the plan cache (DTAEngine).

I don't know what to do to make it work

Thanks for your help

Answer 1

Hi @Laurent Guiochet

Referring from this doc:

These options not available via the GUI:

1. Number of workload events to tune: This option, specified using -n command line argument, allows the user to control how many events from the Query Store are tuned. By default, DTA uses a value of 1000 for this option. DTA always chooses the most expensive events by total duration.
2. Time windows of events to tune: Since the Query Store may contain queries that have executed a long time ago, this option allows the user to specify a past time window (in hours) when a query must have executed for it to be considered by DTA for tuning. This option is specified using -I command line argument.

Best regards,

Cosmog Hong

Answer 2

Hello,

I'm sorry, but you haven't answered my question. I've already consulted this document, which doesn't help me in my case.

You were asking for an explanation of the error and how to resolve it. I haven't managed to solve the problem with the document and I'm looking for further help.

Thank you