I'm 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 milliseconds, seconds, or what. The value I am currently getting is 88936. This could be in seconds or milliseconds.
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.