Home Forums SQLServerCentral.com SQLServerCentral.com Test Forum How view will help in performance and how can i identify tempdb is full RE: How view will help in performance and how can i identify tempdb is full

  • December 30, 2011 at 2:49 am

    #1426813

    Hi,

    Here you go:

    use tempdb

    select name,(size*8)/1024 as Current_Size_MB,(max_size*8)/1024 as Total_Size_MB from sys.database_files