October 17, 2010 at 6:50 pm
I've run through http://www.sql-server-performance.com/articles/per/System_Monitor_Hardware_Bottlenecks%20_p1.aspx on one of my servers, and have got back some results that I'm struggling to understand.
It says the pages/sec average is 170, but the SQL Server Buffer: Buffer Cache Hit Ratio is 100 which according to the article indicates that there's no real memory is, but why is the paging value so high? There is nothing else running on this server.
Can anyone help shed some light on this please?
October 17, 2010 at 11:08 pm
removed by author due to incorrectness
October 18, 2010 at 7:27 am
I don't think I see a problem with the two numbers you mention either.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 18, 2010 at 7:38 am
john 64806 (10/17/2010)
Pages / Sec refers to how much memory is addressed, it's like saying "you're doing so and so many reads per second to disk" but about memory instead, there we talk of pages.
This is not the case. Pages/sec is a measure of pages read from or written to disk, to resolve hard page faults. Link below is a good starting point to understand the relevance of the values you're seeing:
http://www.sql-server-performance.com/faq/high_pages_sec_counter_p1.aspx
October 18, 2010 at 9:02 am
Good information.
I manage SQL Servers (2000, 2005) on VMware Virtual Machines.
I believe using Performance Counters in VMs isn't accurate.
How can I monitor performance (CPU, RAM etc) on VMs?
October 18, 2010 at 9:45 am
Mark Storey-Smith (10/18/2010)
john 64806 (10/17/2010)
Pages / Sec refers to how much memory is addressed, it's like saying "you're doing so and so many reads per second to disk" but about memory instead, there we talk of pages.
This is not the case. Pages/sec is a measure of pages read from or written to disk, to resolve hard page faults. Link below is a good starting point to understand the relevance of the values you're seeing:
http://www.sql-server-performance.com/faq/high_pages_sec_counter_p1.aspx%5B/quote%5D
I removed my answer to find out a bit more about this, i've never ever hear of "Memory: Pages/Sec" being a measure of disc activity before..
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply