Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Im currently using the following query to get the Page Life expectancy from sql server:

declare @PLE int

select @PLE=cntr_value from psql1.master.sys.dm_os_performance_counters where counter_name='Page life expectancy' and instance_name=''

The issue I'm having is I don't know if this is in miliseconds, seconds, or what. The value I am currently getting is 88936. This could be in seconds or miliseconds. It would make more sense if it was in miliseconds, but this server isn't used that much currently so something staying in memory for 24 hours (88936/3600=24.7) isn't impossible.

share|improve this question
3  
See this please. I've no idea to be honest stackoverflow.com/questions/4844866/… –  gbn Oct 12 '11 at 18:36
add comment

1 Answer

up vote 3 down vote accepted

I believe that it's in seconds. I've got a script running a loop that's capturing the value once every minute and it's going up steadily by ~60 every 1 minute interval.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.