July 21, 2006 at 12:58 pm
I'm having trouble with a query and I was trying to run the index tunig wizard and it gives me this error:
The workload does not containg eny events or queries that can be tuned against the current database. Check to see that the trace contains valid events and you are tuning against the right database.
I have tried just using the query window and running a trace and loading that in the wizard and niether one works. It's a pretty nasty query, but it should still try and do something with it.
Any help would be appreciated
July 21, 2006 at 4:45 pm
July 25, 2006 at 4:34 am
If you've a copy of 2005 around the tuning advisor makes a much better job than the 2k wizard.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
July 25, 2006 at 7:45 am
Thanks, I'll try using 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply