Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 955
  • Last Modified:

The importance of swap file pagefile.sys ?

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.
0
jjoz
Asked:
jjoz
  • 4
  • 3
3 Solutions
 
tsmgeekCommented:
in my opinion you should always have some there unless you are sure that your server will never ever go over its max memory which you can limit in SQL server anyway, if it did go over slighly and you did not have it then your box would crash
0
 
jjozAuthor Commented:
oh. so do you mean no SWAP could means BSoD ?
0
 
tsmgeekCommented:
i think its more likley you will have non-critical processes die first (sql included) but if it went too far then eventualy the system will grind to a halt
i cant remember 100% what happens on MS server as i always give them the same ammount as the ram but when you have such large ram mabey its not so much required
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
Danny McDanielClinical Systems AnalystCommented:
you have to have minimal one on the system drive in the event that there's a core dump you want to capture it for debug purposes in event of crash.
0
 
jjozAuthor Commented:
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 ?
0
 
tsmgeekCommented:
you could or if you can stretch to a different config...put OS on a RAID1 2 disk and SQL Data on RAID10 4 disks, this is usually the recommended practice if you think you are going to hammer the disks with your DB, this way if you have a disk failing on the OS drives it will not impact the system as much as your SQL
0
 
jjozAuthor Commented:
ah ok, so I was wondering if using Guest OS swap file could potentially slowing it down, perhaps if it is WIndows Server it would be better to just disabling the swap file at all and then increasing the "paging size"
0
 
jjozAuthor Commented:
thanks !
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now