Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database Tuning Advisor
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Database Tuning Advisor
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01395052
Message ID:
01395052
Vues:
138
Hi All,

I run a SQL Server profiler in order to create a trc file to be used by the DTA.
The only event I am caputring is SP:StmtCompleted since I need to tune the content of a stored procedure.

When I point the DTA to the trace file and start the analysis I am getting the followig error message:

The specified workload has no tunable events. Events must be one of the following types:
SQL:BatchStarting
SQL:BatchCompleted
RPC:Starting
RPC:Completed
SP:StmtStarting
SP:StmtCompleted

What am I missing?
Thanks,
Daniel
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform