I have a SQL Server 7.0 database that I ran Profiler from my sql2000server desktop PC to grab 2 hours worth of data into a table in my sql2000server desktop.
I am now trying to use the Index Tuning Wizard to analyze this workload and check the original sql7.0 database indexes.
It's been running for hours and now doesn't appear to be doing anything....I'm not sure if it's hung or not.
It did create 2 temp files that haven't updated since the beginning.
Is there any problems with using the Index Wizrd on a 2000 machine against a 7.0 database perhaps?
Does anyone have any other ideas....or does it normally takes hours to go through?