Pages/sec averages greater than 20

I read

"Memory: Pages/sec
Assuming that SQL Server is the only major application running
on your server, then this figure should average near zero
over a 24 hour period "

I used perfmon like that and my average is 160

1- the only application running on my server
2- Buffer Cache Hit Ratio average 99,88
3- SQL Server is set to the "Dynamically configure SQL Server memory" option

Do I need more RAM or something wrong?

How much memory does the box have and what OS are you running on?
Since the cache hit ratio is high and the average pages/sec is 160 over 24 hours is it possible that there are certain times in the day when the excessive paging occurs and it's not a constant figure (could be caused during backups)?

Cheers
Shaun

World Domination Through Superior Software

Backups, restores, transaction log backups, and file copies can all cause the pages/sec to run high. But these are temporary and are not a cause for concern. So if you have eliminated all of these influences, and your pages/sec is still very high, then I must assume that your server needs more RAM.

It is also possible that some SQL Server setting is not at its default value, or that your disk subsystem is causing the problem. In a few servers, I have seen disk subsystems produce very high pages/sec for no apparent reason. I don't know what causes this or how to avoid it.

------------------
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com