Download View this book as PDF
Transcript
Chapter 2 Installation Requirements Table 2-11: Database requirements for varying page sizes Databases Default database size 2K page 2MB 4K page 4MB 8K page 8MB 16K page 16MB master database model database 6MB 3MB 12MB 4MB 24MB 8MB 48MB 16MB tempdb database 3MB 4MB 8MB 16MB Larger logical page sizes can contain more data. Table 2-12 lists the maximum data for each logical page size. Table 2-12: Data limits for tables according to page size Tables Maximum number of data bytes per text or image file 2K page 1800 4K page 3600 8K page 7650 16K page 16200 Bytes per index key User-visible row length DOL table User-visible row length APL table 600 1958 1250 4006 2600 8102 5300 16294 1960 4008 8104 16296 Adaptive Server devices and system databases Devices are files or portions of a disk that are used to store databases and database objects. You can initialize devices, using raw disk partitions (for production systems) or operating system files (for nonproduction uses). Adaptive Server requires the following devices: • master device – to store system databases. • sysprocsdev device – to store system procedures. The master and sysprocsdev devices are created when you create a new Adaptive Server. master device The master device contains the following databases: 23