SQL Server Performance

What is paging file size recommendation, as opinion varies?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Mar 9, 2014.

  1. Trev256b Member

    I have a 64 bit SQL Server 2008 R2 with total RAM 16GB, and SQL Server max memory 12 GB. The paging file is 8 GB.

    1) What size should the paging file be as 64 bit servers could page out the whole memory?
    2) If I set Lock Pages in Memory, should the paging file size be set differently?

Share This Page