SQL Server Performance

page file

Discussion in 'SQL Server 2008 General DBA Questions' started by klehonia, Feb 8, 2010.

  1. klehonia New Member

    Hi, my system is windows server 2008 R2 enterprise with RAM 64GB and i want to install sql enterprise 2008, what should be the appropriate page file and how many pagefile.sys files i should create in separate disks?
    thank you
  2. preethi Member

    I am not an expert in ths area. But I am replying to this thread as no one has responded so far.
    I haven't come across of any recommendation on how to set the pagefile size especially considering SQL Server. But it is a general practive to set it to 1.5 - 2.5 times of your RAM.
    Creating page file in different disks make performance improvement, but I prefer not to put them with the SQL Server database files.
    However, instead of relying on our response, you need to constantly monitor the system and see whether it makes any improvement.
    I found a couple of articles, which may be useful for you.
    http://technet.microsoft.com/en-us/magazine/ff382717.aspx
    http://windowsitpro.com/article/articleid/99930/q-whats-the-ideal-page-file-size.html
    Hope this helps.

Share This Page