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?

Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderatorhttp://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.

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 & Moderatorhttp://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.