Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qvd1rkqv
New Contributor III

Virtual Memory / pagefile.sys Settings

Our environment includes 2 clustered QVS servers one of which is also the Access Point. This is all these 2 servers do. They are both 2X16 core CPUs with 256GB RAM. We currently have the Virtual Memory set on these servers to "System managed" on an 800GB Data partition which is currently at a 262109 MB page file. We are NOT having any performance issues with our systems.  The problem is that we are hitting 75% usage of the Data partition usage with the 262109 MB page file.  So the question for you folks is do we really need a page file this big?  As far as I can tell QlikView apps are not spilling over into virtual memory which would be bad anyway for performance.  My thought is to reduce the VM setting down to 50 GB and free up the hard drive space. Any thoughts? Thanks. 

Labels (1)
1 Solution

Accepted Solutions

Re: Virtual Memory / pagefile.sys Settings

Mark

QlikView is an 'In Memory' tool.  As such the server should have enough RAM to avoid page file usage, which as you have no performance issues appears to be the case.  So if this was my server I'd happily reduce the page file to 50 GB.

[Most applications would need your current page file size, but QlikView does not.]

Best Regards,     Bill

5 Replies
MVP
MVP

Re: Virtual Memory / pagefile.sys Settings

Hi Mark,

please read http://community.qlik.com/thread/88103 and the referenced document.

Hope this helps,

Stefan

qvd1rkqv
New Contributor III

Re: Virtual Memory / pagefile.sys Settings

I did find that thread and read that document. Very informative but unless I'm mistaken it doesn't answer my question.

Re: Virtual Memory / pagefile.sys Settings

Mark

QlikView is an 'In Memory' tool.  As such the server should have enough RAM to avoid page file usage, which as you have no performance issues appears to be the case.  So if this was my server I'd happily reduce the page file to 50 GB.

[Most applications would need your current page file size, but QlikView does not.]

Best Regards,     Bill

MVP
MVP

Re: Virtual Memory / pagefile.sys Settings

Sorry if the referenced information wasn't really helpful.

Maybe these help to answer your question (I am not sure if it is helpful If I would suggest to shrink it down without actually really knowing your system):

How to determine the appropriate page file size for 64-bit versions of Windows

Pushing the Limits of Windows: Virtual Memory - Mark's Blog - Site Home - TechNet Blogs

qvd1rkqv
New Contributor III

Re: Virtual Memory / pagefile.sys Settings

Thanks Bill. Pretty much what i was looking for and what my research found.

Community Browser