I have one of my production servers that has a windows page file of over 32 GB.
The server in question has 32 GB of RAM, windows server 2008.
It is exclusively used for Sql Server. Nothing else.
The lock pages in memory setting has not been set up for any of the sql server services accounts and I think this might be related to the big size of the page file.
I am already seeing if I can add more memory to this box, but I would like to find out what is causing memory pressure (if anything inside sql server).
what could be some options as how I can do that?
I kind of like, in this case, to monitor Paging File % Usage and if something goes off threshold, I would collect all that is running on sql server at that time. Hopefully the culprits would be all there.
Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)