Home Forums SQL Server 2008 SQL Server 2008 Administration DMV query to get at data stored in tempdb tables, as well as metadata information on currently active tempdb tables RE: DMV query to get at data stored in tempdb tables, as well as metadata information on currently active tempdb tables

  • January 21, 2011 at 6:31 am

    #1276506

    I am not sure if you have tried using the below DMV's for querying tempdb.

    You may try to collect some information as well from the below.

    sys.dm_db_file_space_usage

    sys.dm_db_task_space_usage

    sys.dm_db_session_space_usage

    M&M