Information générale
Forum:
Microsoft SQL Server
Titre:
Database Tuning Advisor
Versions des environnements
SQL Server:
SQL Server 2005
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement