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