| _覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
|
|
旧 磯殊 覦煙 焔レ 企至 覲讌 ろ碁ゼ 企慨. 2000覯 blocksize朱 れ螳 覓語 讌襷, maxtransfersize 覓語讌 旧企. 企 覓語 誤螻伎 cpu i/o 螳 4096byte手 覲 . 蠏碁 蠏碁一 blocksize螳 4096byte 蟆曙郁 螳 焔レ 譬. 蟆磯朱 blocksize, maxtransfersize 旧 覃 10% 伎 焔ロレ 螻 覲 も螻 蟆. ろ 蟆郁骸. 谿瑚襦 CPU 2.4 GHz, RAM 2G, Disk 1螳 PC ろ . 譯殊 蟆 蟆曙 磯殊 旧 譟一伎 る 蟆企. 蠍 る 螳れ 旧 .
[edit]
1 旧 #backup database sample to disk = 'f:\sample.bak'
--BACKUP DATABASE(螳) 407185伎襯 45.081豐(73.992MB/豐)襷 豌襴給. [edit]
2 blocksize旧 #backup database sample to disk = 'f:\sample.bak' with blocksize = 65536
--BACKUP DATABASE(螳) 407186伎襯 44.837豐(74.395MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 32768
--BACKUP DATABASE(螳) 405063伎襯 42.789豐(77.549MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 16384
--BACKUP DATABASE(螳) 424447伎襯 45.562豐(76.315MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 8192
--BACKUP DATABASE(螳) 407185伎襯 41.560豐(80.261MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 4096
--BACKUP DATABASE(螳) 407185伎襯 41.487豐(80.402MB/豐)襷 豌襴給. ======> 蠍!! backup database sample to disk = 'f:\sample.bak' with blocksize = 2048
--BACKUP DATABASE(螳) 407185伎襯 41.991豐(79.437MB/豐)襷 豌襴給. [edit]
3 blocksize, maxtransfersize 旧 #backup database sample to disk = 'f:\sample.bak' with blocksize = 65536, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407186伎襯 44.837豐(74.395MB/豐)襷 豌襴給. --maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 37.741豐(88.382MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 32768, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 405063伎襯 42.789豐(77.549MB/豐)襷 豌襴給. --maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407191伎襯 35.431豐(94.146MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 16384, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 424447伎襯 45.562豐(76.315MB/豐)襷 豌襴給. --maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 34.327豐(97.172MB/豐)襷 豌襴給. ======> 蠍!! backup database sample to disk = 'f:\sample.bak' with blocksize = 8192, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407185伎襯 41.560豐(80.261MB/豐)襷 豌襴給. --maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 34.993豐(95.323MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 4096, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407185伎襯 41.487豐(80.402MB/豐)襷 豌襴給. --maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 34.898豐(95.582MB/豐)襷 豌襴給. backup database sample to disk = 'f:\sample.bak' with blocksize = 2048, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407185伎襯 41.991豐(79.437MB/豐)襷 豌襴給. --maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 40.486豐(82.390MB/豐)襷 豌襴給. [edit]
4 ろ語 覦煙 ろ #backup database sample
to disk = '\\1.1.1.10\f$\sample.bak' with blocksize = 16384, maxtransfersize = 65536, buffercount = 200 --with blocksize = 16384, maxtransfersize = 65536, buffercount = 100
--BACKUP DATABASE(螳) 536985螳 伎襯 64.417豐 豌襴給(68.289MB/豐). --with blocksize = 16384, maxtransfersize = 65536, buffercount = 200
--BACKUP DATABASE(螳) 536985螳 伎襯 64.157豐 豌襴給(68.565MB/豐). TO DISK='\\1.1.1.10\d$\sample1.bak', DISK='\\1.1.1.10\e$\sample2.bak2', DISK='\\1.1.1.10\f$\sample3.bak', disk='\\1.1.1.10\g$\sample4.bak' with blocksize = 16384, maxtransfersize = 65536, buffercount = 200 --BACKUP DATABASE(螳) 536985螳 伎襯 57.390豐 豌襴給(76.650MB/豐). BACKUP DATABASE sample
TO DISK='\\1.1.1.10\d$\sample1.bak', DISK='\\1.1.1.10\e$\sample2.bak2', DISK='\\1.1.1.10\f$\sample3.bak', disk='\\1.1.1.10\g$\sample4.bak', disk='\\1.1.1.10\h$\sample5.bak', disk='\\1.1.1.10\i$\sample6.bak', disk='\\1.1.1.10\j$\sample7.bak' with blocksize = 16384, maxtransfersize = 65536, buffercount = 200 /* 1 一危磯伎 'sample', 'sample_Data' 268480螳 伎襯 豌襴給 . 1 一危磯伎 'sample', 'sample_Data1' 268504螳 伎襯 豌襴給 . 1 一危磯伎 'sample', 'sample_Log' 1螳 伎襯 豌襴給 . BACKUP DATABASE(螳) 536985螳 伎襯 44.453豐 豌襴給(98.958MB/豐). */
鏤
|
螻 覦覯 麹. 覦螻 覦 豎 螳 蟆 殊れ 螳螳 覈 襯 襷り鍵 覓語企. (譟 貊磯ゴ) |