Sybase DC35823-01-1500-04 manual Managing Adaptive Server Databases, Managing database devices

C H A P T E R 9

Managing Adaptive Server Databases

The administration of Adaptive Server databases includes both routine tasks and performance and tuning considerations.

•The System Administration Guide discusses most of the administrative tasks in detail.

•The Performance and Tuning Guide provides in-depth explanations of performance issues.

Topic

Managing database devices

Page

109

Managing database devices

The term database device refers to a disk or a portion of a disk that stores

Adaptive Server databases and database objects.

Device requirements

Adaptive Server devices and databases are subject to the following limits:

•The maximum device size is 4TB.

•The minimum usable device size depends on the servers logical page size. Databases manage space in groups of 256 logical pages, and the smallest specifiable disk piece size is 1MB, so the smallest usable device is the larger of 1MB or 256 logical pages:

•The minimum device size for a 2K page server is 1MB

•The minimum device size for a 4K page server is 1MB

•The minimum device size for an 8K page server is 2MB

Configuration Guide 109