We are trying to optimize one of our databases (SQL 2005) and we are running analysis on some of the stored procedures. However, the Database Engine Tuning Advisor is resulting in either
Event does not reference any tables.
Or
Statement does not reference any tables.
Anyone have any idea why this would happen?
PLease explain the process how you are trying analyze the SP using DTA?
ALso may try from another machine to see whether its a problem of tools on this machine.
|||Thanks for replying. Sorry I lost track of the thread. Essentially, all we are doing is executing a stored procedure in a query window and analyzing that directly.Also, if we log the execution and use the trace log to do the analysis we get the same.
It has been tried in multiple machines. It is weird since there's no errors with the stored procedures. Thanks again.|||I have the same problem, a lot of those errors, plus after a while (from 25 to 60 minutes) the DTA exits with an "unexpected error".|||this happens against any stored procedure that DTA analyzes, why?
No comments:
Post a Comment