1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
| 1> sp_spaceused
2> go
database_name database_size
------------------------------ -------------
XXXccdb 3850.0 MB
reserved data index_size unused
--------------- --------------- --------------- ---------------
2124416 KB 1942068 KB 144792 KB 37556 KB
(return status = 0)
1> sp_helpdb XXXccdb
2> go
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ -------------- ------------------------------------------------------------------------------------------------------
XXXccdb 3850.0 MB DBS 52 Nov 04, 2002 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full
(1 row affected)
device_fragments size usage created free kbytes
------------------------------ ------------- -------------------- ------------------- ----------------
db3 1000.0 MB data only May 28 2006 10:10AM 7986
log3 100.0 MB log only May 28 2006 10:10AM not applicable
log1 385.0 MB log only May 28 2006 10:10AM not applicable
log2 200.0 MB log only May 28 2006 10:10AM not applicable
db1 200.0 MB data only May 28 2006 10:10AM 0
db4 100.0 MB data only May 28 2006 10:10AM 0
db8 500.0 MB data only May 28 2006 10:10AM 16
log7 115.0 MB log only May 28 2006 10:10AM not applicable
log7 700.0 MB log only May 28 2006 10:10AM not applicable
db8 200.0 MB data only Jul 13 2006 4:02PM 0
db8 350.0 MB data only Jan 3 2007 5:24PM 264582
--------------------------------------------------------------
log only free kbytes = 1529998
device segment
------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
db1 default
db1 system
db3 default
db3 system
db4 default
db4 system
db8 default
db8 system
log1 logsegment
log2 logsegment
log3 logsegment
log7 logsegment
(return status = 0)
1> sp_spaceused uac_comtmt_hdr
2> go
name rowtotal reserved data index_size unused
-------------------- ----------- --------------- --------------- --------------- ---------------
uac_comtmt_hdr 79783 47734 KB 40790 KB 4478 KB 2466 KB
(1 row affected)
(return status = 0)
1> sp_spaceused uac_comtmt_line
2> go
name rowtotal reserved data index_size unused
-------------------- ----------- --------------- --------------- --------------- ---------------
uac_comtmt_line 100303 25522 KB 22692 KB 1502 KB 1328 KB
(1 row affected)
(return status = 0)
1> sp_spaceused uac_comtmt_line_year
2> go
name rowtotal reserved data index_size unused
-------------------- ----------- --------------- --------------- --------------- ---------------
uac_comtmt_line_year 740783 147736 KB 132276 KB 9196 KB 6264 KB |
Partager