tempdb shrink error : File ID of database was skipped because the file does not have enough free space to reclaim

Posted By Sagar Patil

 

 

SELECT    TOP 10
session_id,
database_id,
user_objects_alloc_page_count + internal_objects_alloc_page_count / 129
AS tempdb_usage_MB
FROM sys.dm_db_session_space_usage
ORDER BY user_objects_alloc_page_count + internal_objects_alloc_page_count DESC;

Leave a Reply

You must be logged in to post a comment.

Top of Page

Top menu