RSA Scripts

Quick Tempdb Summary

  1. Sql Server
  2. Tempdb
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

-- Quick Tempdb Summary
SELECT
    SUM(user_object_reserved_page_count) * 8.192 AS UserObjectsKB,
    SUM(internal_object_reserved_page_count) * 8.192 AS InternalObjectsKB,
    SUM(version_store_reserved_page_count) * 8.192 AS VersonStoreKB,
    SUM(unallocated_extent_page_count) * 8.192 AS FreeSpaceKB
FROM sys.dm_db_file_space_usage