sys.dm_db_file_space_usage : tells us the total page count in the unallocated extents in tempdb
sys.dm_db_session_space_usage: tells us the total page count that is allocated/reserved for user objects in this session.in other words this reports page allocation and deallocation activity by session
sys.dm_db_task_space_usage:reports page allocation and deallocation activity by task.
sys.dm_db_partition_stats :Returns page and row-count information for every partition in the current database.
No comments:
Post a Comment