SQL DBA-ASR
Tuesday, August 23, 2011
Query for finding the number of pages in all databases
SELECT
DB_NAME(database_id) as DB_NAME,
COUNT(page_id)as number_pages
FROM sys.dm_os_buffer_descriptors
WHERE database_id !=32767
GROUP BY database_id
ORDER BY database_id
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment