name db_size owner dbid created status ------------------------ ------------- ------------------------ ------ ------------------ ------------------------------------------------------------------------ tempdb 2051.0 MB sa 2 Mar 26, 2011 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full device_fragments size usage created free kbytes ------------------------------ ------------- -------------------- ------------------------- ---------------- master_dxl_r_ASE1#2_01 3.0 MB data only Feb 6 2008 11:12PM 1850 tempdb_dx_r_RAM_01 768.0 MB data only Apr 21 2009 9:45AM 783220 tempdb_l_r_RAM_01 1280.0 MB log only Apr 21 2009 9:46AM not applicable device segment ------------------------------ ------------ master -- unused tempdb_dx_r_RAM_01 default tempdb_dx_r_RAM_01 system tempdb_l_r_RAM_01 logsegment name db_size owner dbid created status ------------------------ ------------- ------------------------ ------ ------------------ ---------------------------------------------------------------------------------------------- tempdb2 2048.0 MB sa 5 Mar 26, 2011 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full, user created temp db device_fragments size usage created free kbytes ------------------------------ ------------- -------------------- ------------------------- ---------------- tempdb2_dx_r_RAM_01 768.0 MB data only Apr 21 2009 9:53AM 782150 tempdb2_l_r_RAM_01 1280.0 MB log only Apr 21 2009 9:53AM not applicable device segment ------------------------------ ----------- tempdb2_dx_r_RAM_01 default tempdb2_dx_r_RAM_01 system tempdb2_l_r_RAM_01 logsegment name db_size owner dbid created status ------------------------ ------------- ------------------------ ------ ------------------ ------------------------------------------------------------------------------------------------------ tempdb3 2048.0 MB sa 6 Mar 26, 2011 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full, user created temp db device_fragments size usage created free kbytes ------------------------------ ------------- -------------------- ------------------------- ---------------- tempdb3_dx_r_RAM_01 768.0 MB data only Apr 21 2009 9:55AM 782120 tempdb3_l_r_RAM_01 1280.0 MB log only Apr 21 2009 9:55AM not applicable device segment ------------------------------ ---------- tempdb3_dx_r_RAM_01 default tempdb3_dx_r_RAM_01 system tempdb3_l_r_RAM_01 logsegment name db_size owner dbid created status ------------------------ ------------- ------------------------ ------ ------------------ ------------------------------------------------------------------------------------------------------ tempdb4 2048.0 MB sa 11 Mar 26, 2011 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full, user created temp db device_fragments size usage created free kbytes ------------------------------ ------------- -------------------- ------------------------- ---------------- tempdb4_dx_r_RAM_01 768.0 MB data only Apr 21 2009 9:55AM 782134 tempdb4_l_r_RAM_01 1280.0 MB log only Apr 21 2009 9:55AM not applicable device segment ------------------------------ -------- tempdb4_dx_r_RAM_01 default tempdb4_dx_r_RAM_01 system tempdb4_l_r_RAM_01 logsegment name db_size owner dbid created status ------------------------ ------------- ------------------------ ------ ------------------ ------------------------------------------------------------------------------------------------------ tempDBAIBM 511.5 MB sa 4 Mar 26, 2011 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full, mixed log and data, user cre device_fragments size usage created free kbytes ------------------------------ ------------- -------------------- ------------------------- ---------------- tempDBAIBM_dxl_r_tempdb1#2_01 511.5 MB data and log Jun 17 2008 4:39PM 520504 device segment ------------------------------ --------- tempDBAIBM_dxl_r_tempdb1#2_01 default tempDBAIBM_dxl_r_tempdb1#2_01 logsegment tempDBAIBM_dxl_r_tempdb1#2_01 system name db_size owner dbid created status ------------------------ ------------- ------------------------ ------ ------------------ ------------------------------------------------------------------------------------------------------ tempdbbatch 8191.0 MB sa 12 Mar 26, 2011 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full, mixed log and data, user cre device_fragments size usage created free kbytes ------------------------------ ------------- -------------------- ------------------------- ---------------- tempdbbatch_dxl_r_tempdb1#2_1 8191.0 MB data and log Mar 18 2008 11:51AM 8347492 device segment ------------------------------ -------- tempdbbatch_dxl_r_tempdb1#2_1 default tempdbbatch_dxl_r_tempdb1#2_1 logsegment tempdbbatch_dxl_r_tempdb1#2_1 system