High Pages/sec

Last Post 17 Dec 2012 06:57 AM by Frank Garcia. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Resolved
rerichards
New Member
New Member

--
13 Dec 2012 04:45 AM
Our Pages/sec are over 150.

The box has 32G RAM
SQL Server Max Memory is 26G
Available MBytes is 2G
Buffer Cache Hit ration > 99.5

Does this mean my paging file is not sized correctly?
rm
New Member
New Member

--
13 Dec 2012 04:55 AM
How big the page file is? Does sql service account have 'lock pages in memory' user rights on the server?
rerichards
New Member
New Member

--
13 Dec 2012 07:02 AM
We are running 64bit Enterprise, 2008 R2

We have Lock Pages in Memory set.

The Paging File is 33065MB
Frank Garcia
New Member
New Member

--
17 Dec 2012 06:57 AM
Hi,

Is this a physical server or virtual?
You are not authorized to post a reply.

Acceptable Use Policy