kfk (9/2/2010)
I've tried setting them to various values, from 256MB to 4GB.While 256MB seemed to make the problem worse, I couldn't tell any difference between 2GB and 4GB.
How much memory does the server have?
Is AWE enabled? (along with /PAE in the boot.ini) If the /3GB switch set?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability