Lots of Page Faults/sec on SQL server 2005

[Vramby]

I have an SQL Server 2005 with 4Gb of memory.
Only 2,5 Gb of the memory is assigned to SQL server.
It hardly uses over 2,1 GB.
Lately we have seen a lot of page Faults/sec (an average of 400). Strangly enough the Buffer cache hit ratio is always around 99%.

This happens on a production server, we have almost the same configuration on our development server (2 processors instead of 4) an here the problem doesn't occur. On both servers we have the same programs running.

Does anyone had a similar problem or can give me some hints to help me find the cause of this problem?

Thanks,
Vramby

 

[MissTipps]

Have you checked whether that 2.1GB of memory that SQL is using is all physical memory and you're not seeing a lot of page file usage?

Also out of interest how big is the database on this server?

MissTipps

CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

 

[Vramby]

I doubt that it is the page file usage that is causing the Page Faults, because I still have got +/- 800Mb free. I also ran a trace on the queries that were being send to the sqlserver, but I don't see anything taking longer than 50 ms. But if you have a good tip of how to see that a process is not paging instead iof staying in memory, please let me know.

The database is around 5Gb in total.

I noticed today that 3 processes were having page faults when no one (except me) was connected to the server:

sqlserver.exe
explorer.exe
java.exe *32

I will now focus on the other processes to see if they are taking up resources.

Vramby