- 论坛徽章:
- 0
|
1>; alter database acct on datdev1=1000
2>; go
Extending database by 512000 pages on disk datdev1
1>; sp_helpdb acct
2>; go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
acct 7045.0 MB sa 28
Jun 17, 2004
no options set
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
datdev1 135.0 MB data only 138240
datdev1 865.0 MB data only 885200 datdev3 45.0 MB data only 0
datdev3 500.0 MB data only 64
datdev3 1000.0 MB data only 0
datdev4 2000.0 MB data only 416
idxdev2 500.0 MB data only 0
idxdev2 500.0 MB data only 127824
idxdev2 1000.0 MB data only 1024000
tranlog1 15.0 MB log only 15360
tranlog1 100.0 MB log only 73184
tranlog1 185.0 MB log only 189440
tranlog1 200.0 MB log only 204800
(return status = 0)
我明明是一次扩展了1000M,为什么成功后先是好像是做了两次扩展呢? 一次是135M, 一次是865M, 哪位大虾知道原因阿? |
|