Skip to content

Instantly share code, notes, and snippets.

@freemanirl

freemanirl/ple.sql

Created April 5, 2017 18:19
Show Gist options
  • Save freemanirl/a36ff0ad6aef94c8c50164ec7a20f342 to your computer and use it in GitHub Desktop.
Save freemanirl/a36ff0ad6aef94c8c50164ec7a20f342 to your computer and use it in GitHub Desktop.
Download ZIP
Find Page Life Expectancy
Raw
ple.sql
SELECT [object_name],
[counter_name],
[cntr_value] FROM sys.dm_os_performance_counters
WHERE [object_name] LIKE '%Manager%'
AND [counter_name] = 'Page life expectancy'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment