Announcement

Collapse
No announcement yet.

is physical swap file needed or not ?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • is physical swap file needed or not ?

    Hi All,

    suppose I have one very powerful server which runs:

    2x 12 core Xeon 5650
    64 GB RAM
    4x RAID 10 SAS 15k rpm HDD

    Do I still need to use pagefile.sys or I can just turn it off completely ?

    it is a physical server and it runs SQL Server 2008 Enterprise DB for OLAP

    Thanks.

  • #2
    Re: is physical swap file needed or not ?

    Originally posted by Albertwt View Post
    Hi All,

    suppose I have one very powerful server which runs:

    2x 12 core Xeon 5650
    64 GB RAM
    4x RAID 10 SAS 15k rpm HDD

    Do I still need to use pagefile.sys or I can just turn it off completely ?

    it is a physical server and it runs SQL Server 2008 Enterprise DB for OLAP

    Thanks.
    hi Albertwt
    wow you have master server. with power server that you don't need pagefile.sys, You only use pagefile.sys when RAM is small. H.D.D will create pagefile.sys to swap data and pagefile.sys is Virtual RAM

    Comment


    • #3
      Re: is physical swap file needed or not ?

      Originally posted by Albertwt View Post
      Do I still need to use pagefile.sys or I can just turn it off completely ? it is a physical server and it runs SQL Server 2008 Enterprise DB for OLAP
      (How come this is on VMWare forum?)

      Yes, you need a page file. What do you suppose happens when your DB has allocated all the RAM and some more is needed for, say, OS process?

      Not configuring a page file is not going to save much disk space or the like, so there is little advantage for not having one.

      Crash dumps are also written into the page file.

      -vP

      Comment


      • #4
        Re: is physical swap file needed or not ?

        Originally posted by vonPryz View Post
        (How come this is on VMWare forum?)

        Yes, you need a page file. What do you suppose happens when your DB has allocated all the RAM and some more is needed for, say, OS process?

        Not configuring a page file is not going to save much disk space or the like, so there is little advantage for not having one.

        Crash dumps are also written into the page file.

        -vP
        ok, can I make it approximately 16 GB for the current 64 GB server ?
        so if the drive got zero disk space left, I can just reduce the size to 8 GB and then reboot the server ?

        Comment


        • #5
          Re: is physical swap file needed or not ?

          Originally posted by Albertwt View Post
          can I make it approximately 16 GB for the current 64 GB server ?
          A 16 Gb swap is predictable and should be good enough. If you constantly are running short of virtual memory, consider distributing workload and/or adding more RAM.

          If you run out of space on the system drive, your server is going to die. You do set up the system to different a partition than database and log files, right?

          -vP

          Comment


          • #6
            Re: is physical swap file needed or not ?

            I find it bewildering and annoying that no matter how much RAM you have installed you still need a bloody Pagefile. The more RAM you install the bigger Windows wants to make the Pagefile.

            Alternative is to allow the O/S to handle the size and see what it allocates.
            Click image for larger version

Name:	pagefile-size.jpg
Views:	1
Size:	53.1 KB
ID:	464802
            1 1 was a racehorse.
            2 2 was 1 2.
            1 1 1 1 race 1 day,
            2 2 1 1 2

            Comment

            Working...
            X