December 13, 2011 at 9:17 pm
Hello,
I am getting 'Page life expectancy' value as '84156' from sys.dm_os_performance_counters views. How can I calculate the average "page life expectancy value" from this ?.
We dint restart our server since 4 months now.
Thanks in advance.
December 13, 2011 at 9:21 pm
That counter value you see itself is the page life expectancy of your server. There is no average value to calculate...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 13, 2011 at 9:29 pm
Bru Medishetty (12/13/2011)
That counter value you see itself is the page life expectancy of your server. There is no average value to calculate...
Thanks a lot for the quick response.
But that counter value looks too much.. If I am not wrong its in seconds right.?. Is it possible to have such huge value for that ?
Thanks again.
December 13, 2011 at 9:35 pm
Yes it is in seconds and it is not uncommon to have that high value. When done a small calculation that # of seconds comes to a day (approx 24 hours).. Which is not surprising.
By the way what makes you look for that counter? Are you seeing any slowness on the server. How much Memory is allocated to SQL, is it Prod or Test or Dev?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 13, 2011 at 9:46 pm
It's production. dedicated server.
Client is complaining that in task manager SQL server shows its using "5 GB" of memory consistenly. They just want to know if its in need of more memory. Can you pls guide me how to go about it. Need to give an explanation on this..
Thanks a lot again for you response.
December 13, 2011 at 9:53 pm
Ok..
Let me clarify this. What they see (SQL Server using 5GB consistently) is normal. SQL Server starts with a low Memory usage and as it needs, grabs more and more memory (until the max memory settings). Now once that max memory is grabbed, SQL Server will not give back the memory to the OS (Windows), unless there is memory pressure. So it will the same value 5 GB until the next restart of SQL Instance.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 13, 2011 at 10:02 pm
..Yup.. I am very much clear on that and I explained to them as well.
I just wanted to give the statistics based on "Performance counters" as well.
Thought I would "buffer cache hit ratio, PLE etc;"
Can you pls guide me on the MEMORY counters I need to look for in the view and how to get the vlaues in propert format. I got the script to get the buffer cache hit ration in %'. Do you have any scripts like that.? For this particular requirement, only memory related would be fine for me.
Thanks for your time.
December 13, 2011 at 11:55 pm
Joy Smith San (12/13/2011)
Can you pls guide me on the MEMORY counters I need to look for in the view and how to get the vlaues in propert format. I got the script to get the buffer cache hit ration in %'. Do you have any scripts like that.? For this particular requirement, only memory related would be fine for me.
Monitoring Memory Usage
December 13, 2011 at 11:59 pm
... Anyone can help pls.......
Thanks.
Smith
December 14, 2011 at 12:07 am
What's the issue Smith? You can anyways format PerfMon reports anyway you want.
December 14, 2011 at 4:21 am
Page life expectancy is a constantly changing measure. You can't take a reading once and have some idea for how it's behaving. Same goes for most of the monitored values. You have to collect data for a week or so at a time which is why I recommend using Performance Monitor to capture the counters out to a file. Then you can see how all the counters are behaving over time. For PLE, it's pretty normal to see what looks kind of like a roller coaster where it goes up & up & up and then shoots down. Normally you'll see that the down part is during a nightly data load. But if you see lots of little ones during the day or it stays consistently very low, then you might have issues. From the sounds of the duration on yours, you're probably not under memory pressure within SQL Server. That doesn't mean that the OS where SQL Server is running doesn't have memory issues. You need to look at external counters for that, as outlined in the MSDN article published above.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 21, 2011 at 8:24 am
HI Smith ,
Can you please go through the below links , it might help full to you .
http://msdn.microsoft.com/en-us/library/ms177455%28v=SQL.90%29.aspx
Thanks ,
December 21, 2011 at 12:59 pm
Hi Lavanyasri,
Thanks for sharing the links, but I doubt how much the OP would be really in need of the links now (after 8 days), by which time the problem might have been resolved or might have been escalated to the next level etc..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 22, 2011 at 4:22 am
HI ,
Its not possible to find the performance issue in single shot . We need to analyze what are the reasons for this issue [from App, Db ,net work] .
Links what i provided it might help full for them in future also.
Thanks
Lavanya Sri
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply