July 12, 2008 at 7:49 pm
Hi everyone out there.
I am a first timer using DTA. and it´s been hard for me to get the recommendations from DTA.
ok. here is the problem : I already have a workload from my database activities, and I put DTA to work on it, but at the end the recommendations are not what I expect. For whatever reason it gives me one recommendation for one table only.
One thing is that my application make calls to the database through store procedures only; and the DTA reports sintax errors calling those store procedures. From what I see those errors are parameters related.
And That´s why it doesn´t give any recommendations for the other tables.
One more Thing. I do a Test running the store procedures in the Query Analyzer, I took this workload to the DTA and gives no recommendation at all and this time no errors reported either.
Please Anyone can help me with That.
Thanks.
July 12, 2008 at 8:05 pm
did you use the TUNING Trace available in SQL Server Profiler. Or was it a standard trace. USE TUNING TRACE.
at the minimun if you are building a custom trace have these elements.:
For SQL Server 2005 use
RPC:Completed
SQL:BatchCompleted
SP:StmtCompleted
For SQL Server 2000 use
RPC:Completed
SQL:BatchCompleted
Maninder
www.dbanation.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply