Performance Counter Values – Memory Pages/Sec | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Performance Counter Values – Memory Pages/Sec

Counter_Name Average Minimum Maximum
—————————————————————————————–
Memory: Pages/sec 10201777
Memory: Available Bytes 209731344183275520258355200
Physical Disk: % Disk time001411
Physical Disk: Avg. Disk Queue Length 0042
Processor: % Processor Time 5045
System: Processor Queue Length 003
SQL Server Buffer: Buffer Cache Hit Ratio 10094100
SQL Server General: User Connections 10399105 The above are the values captured through performance monitor. As per the statement given in this site that the Memory: Pages/Sec should be less than 20, but in this case it is 102. This is taken from the sql server production box(clustered) and there are no other applications running. Could anyone advice whether the Memory: Pages/Sec value is proper and also the rest?

I would suggest reading the Brag Mc Ghee article on this if you have not read it yet. http://www.sql-server-performance.com/sql_server_performance_audit2.asp
The page/second if it happens for period of say 1-4hours in 24-hour period monitoring it is normal could be because of your maintainence plans like backup’s … cheers
sat
I have read this article already. In this article they mentioned that the pages/sec average should be below 20. There is no maintenance plan and no other applications running on this system. I have also checked the memory settings and the values are:
Min – 0
Max – 2147483647 And still i dont understand why the average pages/sec is 102. Thanks,
Bala
Seehttp://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=18 FAQ Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Is SQL dedicated?. Any anti virus?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Yes, the SQL is dedicated one. Yes, Anti Virus Is Running. Thanks,
Bala
– When u see high page/sec better to plot it against line graph and see which duration of day it stays high, thne investigate from there on. -Hardware configurations on the server plays vital role also, if you can describe RAM,CPU …. Cheers
Sat
What about PLE (Page Life Expectency)?
What is the toal server and configured memory? what edition of sql you are on?
Do you see any perfomance issues other than counter is high?
PerfMon: High Number of Pages/Sec Not Necessarily Low Memory
http://support.microsoft.com/default.aspx/kb/139609
http://support.microsoft.com/kb/889654
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

As the anti-virus is installed on SQL you would expect to see jump in pages/sec and memory utilization in this case. I would suggest to take benchmarks by stopping Anti-virus in this case.
quote:Originally posted by Balasundaram Yes, the SQL is dedicated one. Yes, Anti Virus Is Running. Thanks,
Bala

Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>