tempdb shrink error : File ID of database was skipped because the file does not have enough free space to reclaim
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.