Hi,

I will forward the suggestions about the hyperthreads to my sysadmin and take a look at the scripts you provided. Actually, we have purchased the SQL Diagnostic manager but I have not been able to start using it fully yet. Microsoft was pointing the finger at SQL DM because it uses the sp_OACreate and so my boss had me turn it off until we could get a handle on this memory issue. It is a great tool and I spent some time on the phone with one of their support techs getting things setup up properly.

Thanks for the great info! I will see tomorrow if the -g switch helps.

Isabelle