Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2004-11-03 : 10:03:15
|
| ok, In query analyzer I select the current query and hit cntl+I. Select all the tables in the DB. I get:"The workload does not contain any events or queries that can be tunned against the current database. Check to see that the trace contains valid events or that the SQL script contains valid queries and you are tunning against the right database."The query does run and it is on the right DB. What am I doing wrong? |
|
|
MuadDBA
628 Posts |
Posted - 2004-11-03 : 13:17:46
|
| The index tuning wizard is meant to be used on a trace file or table, not a query you typed into query analyzer.Set up a profiler trace, save it to a file or a table, execute your query, and when it completes, close the profiler session. Then use that as input into your index tuning wizard. |
 |
|
|
|
|
|
Index Tunning Wizard issue