MSSql Work Book | UserPreferences |
master tempdb msdb model
page 8kb - header 96 bytes
extent 64kb - table, index's default unit.
mixed extent -> 8 pages over : regular extent
mdf master data file
ndf
ldf log data file
GAM global allocation map - process 4gb (64000 extents) 1 is unallocated, 0 is allocated.
SGAM shared global allocation map - process 4gb (64000 extents) 1 is mixed, and could be allocated, 0 is not mixed extent, or allocated.
table type data stream - protocol ; sql2000 - 8.0, sql7.0 - 7.0, sql6.5, 6.0, 4.21 - 4.2
transaction log
awe address windowing extensions - advanced server 8gb, datacenter serve 64gb ; È®Àå ¸Þ¸ð¸®´Â °¢ ÀνºÅϽº¿¡ Á¤ÀûÀ¸·Î ÇÒ´çµÊ
data definition language
data manipulate language
sql-dmf distributed manage framework
automation : server agent, jobs, event and warning, trigger, manager?
import/export : dts, replication, bulkcopy(bcp), distributed query
dbcc database