ITW problem
-
Hi,
I've got a problem with the index tuning wizard. It just won't read my trace data (stored in a table) : "the workload does not contain any events or queries that can be tuned against current database...."
I'm tuning against the right database, saved the right data, etc. I am tuning with the following events : RPC:completed, SQL:batchCompleted.
The Profiler data is stored in a different sql server than my tables, could that make a difference? But it's not working either if I save it in a file.
I used ITW before... but I just can't make it work this time...
Any ideas? Btw, i'm using SQL2k std sp3 on win2k server
Thanks,
Eric
-
I got the same setup here, and the same problem.. I'll be anxiously waiting for an answer on this one.
-
More specs (maybe we'll find something out of this...):
- I use Windows authentification (I run ITW on username Administrator)
- I run profiler on another computer than my sqlserver (maybe it's a connection problem?)
- server : win2k in french
- I've tried the template "SQLProfilerTuning"... doesn't change anything
If Remi doesn't know the answer... how could I ?!?!?
Eric
-
I'm still a first year programmer... I'm just real good in tsql, I'm not a god. yet
. -
I have come across this problem if you use temporary tables in your script, or it can sometimes happen when using derived tables in the query.
The way I have gotten around the problem is to create actual tables of the data returned or referenced from the temporary tables originally used in the query, and replaced the temporary tables with these.
Once the tuning is done you can replace these tables with the temporary ones again.
-
This is not the case for me. I didn't have #temp table or table variables in my trace.
-
Neither do I... thanks anyway
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply