Using the SQL2008R2 profiler and DTA connected to a SQL2000 server.
I created a tuning tracefile with profiler for a certain db on the sql2000 server because I need to tune 1 table in the database referenced by 3 parameterized stored procedures which built a query depending on the parameters and is executed with an sp_executesql
When I run the DTA loading the tracefile I see the exec stored procedure events with it's parameters and the message Event does not reference any tables. And that's it.
The DTA generates no Recommendatioin at all.
How can I get the exact sql statements in the tracefile so the DTA can do what he needs to do?
View Complete Post