Jeff Moden (10/16/2009)
Heh... wouldn't a reasonable alternative be to only have SQL Server on the SQL Server box? ;-)
Unfortunately not. I've heard of a case where SQL was the only thing installed on the box (other than OS) and and it was still getting paged out if max memory was set about about 60% of the total memory. This is a server with >16GB.
Suspicion was a driver bug, but couldn't be sure.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass