Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Lots of Page Faults/sec on SQL server 2005
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...- Vramby
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
Lots of Page Faults/sec on SQL server 2005
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...- Vramby
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Setup and Administration
