CODEWITHSUNDEEP
sqlsql-server
Lucas Álvarez Lacasa
Lucas Álvarez Lacasa

Reputation: 113

SQL Page Life Expectancy cntr_value is in seconds or ms?

I'm just wondering if the value that you get through the sys.dm_os_performance_counters for Page Life Expectancy is in seconds or ms. If I run it for a SQL Server that does not have much use, I get 245073 in cntr_value, which seems to be a super high value to be considered in seconds.

SELECT * 
        FROM
            sys.dm_os_performance_counters
        WHERE
            object_name LIKE '%MSSQLSERVER2012:Buffer Manager%'
            AND counter_name = 'Page life expectancy'

Upvotes: 1

Views: 1634

Answers (1)

Yennefer
Yennefer

Reputation: 6234

PLE (Page Life Expectancy) is expressed in seconds. The metric can be useful to understand the memory pressure of your server.

However, you should have a look at PLE only in a wider context, as having plenty of memory does not necessarily mean that the server is performing well.

For further information, please have a look at this question here, where there is a more detailed explanation.

Upvotes: 1

Related Questions