February 1, 2011 at 8:27 pm
This is so weird. I had posted a question on memory pressure few days back and few members did reply to that post. I cant see that post at all, not sure how it is missing. Anyways based on everyone's suggestion and my research i have captured the following data.I have analyzed the data and looks to me sql server is having some memory issues. I request if experienced DBA's can take a look and share there views. Mentioned below is my server configuration:
SQL Server 2005 X64 bit stnd edition
Locked Pages In Memory Enabled
SQL min 0 and max 43 gb off total 48 gb physical memory
February 1, 2011 at 10:34 pm
All counters look fine for me except Memory\Page Faults/sec which are way over the limit.
But before that you need to figure out how many of them are hard page faults.If you have a high rate of page faults combined with a high rate of page reads (Memory\ Page Reads /sec) then you may have an issue with memory indicating hard page fault.
Also are there any other processes running on your box except SQL Server ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 1, 2011 at 11:05 pm
Sachin Nandanwar (2/1/2011)
All counters look fine for me except Memory\Page Faults/sec which are way over the limit.But before that you need to figure out how many of them are hard page faults.If you have a high rate of page faults combined with a high rate of page reads (Memory\ Page Reads /sec) then you may have an issue with memory indicating hard page fault.
Also are there any other processes running on your box except SQL Server ?
Thanks Sachin. Memory\Page Faults/sec what should be the ideal value? Is there something else you want me to trace? Did you take average of all the counters?
February 1, 2011 at 11:15 pm
You are welcome.
Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page fault.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 1, 2011 at 11:38 pm
Sachin Nandanwar (2/1/2011)
You are welcome.Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page fault.
Sachin i will do it right now and post the updates tomorrow. Yes this is server is dedicated to sql server. Sachin could you please say how did you analyze the data. I was doing average for each counter. Is that the same way you did? Thanks
February 2, 2011 at 6:15 pm
Sachin Nandanwar (2/1/2011)
You are welcome.Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page fault.
Sachin i have the captured the data with Memory\Page Reads/sec. The values are less than 1 but Memory\Cache Faults /sec are big. Can you please say what is going on here?
February 3, 2011 at 9:13 pm
Are high memory\page cache faults good?
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply