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.
Tuesday, January 26, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment