Dec 13, 2006

DMV: dm_db_file_space_usage

Select
SUM (user_object_reserved_page_count)*8/1024 as user_objects_mb,
SUM (internal_object_reserved_page_count)*8/1024 as internal_objects_mb,
SUM (version_store_reserved_page_count)*8 as version_store_kb,
SUM (unallocated_extent_page_count)*8/1024 as freespace_mb
From sys.dm_db_file_space_usage
where database_id=2

DMV: dm_os_memory_objects

select type, sum(pages_allocated_count) total_pages_allocated_count
from sys.dm_os_memory_objects
group by type
order by 2 desc

DMV: dm_os_memory_clerks

--
--Check Memory Usage
--
select top 15
type,
sum(single_pages_kb)/1024 single_pages_mb,
sum(multi_pages_kb)/1204 multi_pages_mb,
sum(awe_allocated_kb)/1024 awe_allocated_mb
from sys.dm_os_memory_clerks
group by type
order by 2 desc