Determine the Size of a Database Device

SAP ASE requires baseline values for each database device.

See the release bulletin for any last-minute changes to these values.

SAP ASE Database Devices
Device	Purpose	Minimum size	Minimum recommended size
`master`	Stores system databases	24MB for 2K pages 45MB for 4K pages 89MB for 8K pages 177MB for 16K pages	30MB 60MB 120MB 240MB
`sysprocsdev` (also called the `sybsystemprocs` device)	Stores the `sybsystemprocs` database	160MB	172MB (plus any space for holding stored procedures you have created)
`sybsystemdb`	Transaction processing	3MB for 2K pages 6MB for 4K pages 12MB for 8K pages 24MB for 16K pages	5 – 24MB
`sybsecurity` (optional)	Required for auditing	10MB or size of the `model` database, whichever is larger	Depends on specific auditing needs

Support for Raw Partitions or Files
You can use either a raw partition or a file system for all databases.
Preparation of a Raw Partition Device
Increase performance and avoid file damange by using best practices when preparing a raw partition device.

Parent topic: SAP ASE Devices and System Databases

Related concepts

sybsecurity Device and Database

Database Management System Auditing

Created June 25, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com