Skip to content

Instantly share code, notes, and snippets.

@tcartwright

tcartwright/Buffer Pool Cached Pages Per DB.sql

Last active September 7, 2017 15:12
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tcartwright/11336fa23a75f8f3f1e5b96c4f4ee26f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tcartwright/11336fa23a75f8f3f1e5b96c4f4ee26f to your computer and use it in GitHub Desktop.
Download ZIP
SQL SERVER: Buffer Pool Cached Pages Per DB
Raw
Buffer Pool Cached Pages Per DB.sql
SELECT [cached_pages_count] = COUNT(*),
[cached_pages_count_mb] = CAST(COUNT(*) / 128.0 AS money),
[database_name] = CASE dobd.[database_id]
WHEN 32767 THEN 'ResourceDb'
ELSE DB_NAME([database_id])
END
FROM [sys].[dm_os_buffer_descriptors] dobd
GROUP BY dobd.[database_id]
ORDER BY [cached_pages_count] DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment