Hi,

I will take a look at that paper on SQL performance troubleshooting. We are currently working with a Microsoft engineer:

Sanjay Karmakar

Microsoft SQL Server Support Engineer

I just thought I would see what other suggestions or experience other people had with this kind of issue. We knew that the -g512 switch was just a temporary fix, we were just trying to give us some breathing room while we try and figure out what is causing the problems. Currently we haven't had an alert since we put that switch so it gives me some time to do some research. I will keep you posted with a solution when we figure it out! Thanks so much for all your input. It really helps.

Isabelle