Did you give the "Lock Pages in Memory" right to the SQL Server Service account? This is extremely important for 64-bit SQL Server 2005. Otherwise, the OS controls paging instead of SQL Server. I have some more details below:
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!115.entry
No comments:
Post a Comment