- 论坛徽章:
- 0
|
1>; sp_helpdb tempdb
2>; go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
tempdb 1003.0 MB sa 2
Nov 02, 2004
select into/bulkcopy/pllsort, trunc log on chkpt
(1 row affected)
name attribute_class
attribute int_value
char_value
comments
------------------------------ ------------------------------
------------------------------ -----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
tempdb buffer manager
cache binding 1
tempdb_cache
NULL
device_fragments size usage
created free kbytes
------------------------------ ------------- --------------------
------------------- ------------------------------
master 3.0 MB data only
Nov 7 2003 4:39PM 1848
sybtempdb20031027 1000.0 MB data and log
Nov 7 2003 5:11PM 1019398
device
segment
------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
master
-- unused by any segments --
sybtempdb20031027
default
sybtempdb20031027
logsegment
sybtempdb20031027
system
(return status = 0)
1>; |
|