Ouch! Thats pretty bad. What do you have your memory set at? For a
physical ram system with nothing else running on the SQL Server, I would
set tempdb in ram to 24mb, and the memory to 32768 (64mb of ram). You
might also try set tempdb in RAM to 0 (so that its on disk) and setting
the memory to 44000 (88mb).
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com