Index tuning wizard problems

[jtav]

I am attempting to run the index tuning wizard on a SQL 7.0 SP4 server. I am using a trace file generated from profiler during a process we are having slow response from.

When I run the index tuning wizard (ITW)it gets part way through, usually around where it says 'tuning' and then just stops. No errors. No messages.

I ran performance monitor on the server and it looks like the available memory drops to 0 around the tuning part of the ITW.

I do get a Dr. Watson error in my application log on the server.

The application, , generated an application error The error occurred on 05/12/2003 @ 21:07:32.265 The exception generated was c0000005 at address 4174B1CB (<nosymbols>)


Anyone know what is going on with this? Or how to successfully run the tuning wizard.

Thanks.

[rmiao]

May need more memory. By the way, how big the page file is on the server?

[jtav]

The server has 1GB of RAM.

The page file size is 1.5GB.

[rmiao]

How big the db is? How much memory allocated to sql?

[jtav]

Database Size:

8554MB Data
2584MB Log

SQL Memory is set to dynamically configure SQL Server memory.

[rmiao]

Tried run the wizard on client machine?

[jtav]

Yes. I have run the wizard on another SQL 7.0 server and also on my workstation which has the 2000 version of tools installed.

Both fail.

[rmiao]

May call Microsoft to see if it's known issue.