default database size

default database size sets the default number of megabytes allocated to a new user database if create database is issued without any size parameters.

Summary Information

Default value

3MB

Range of values

2a –10000

(the minimum determined by server’s logical page size)

Status

Dynamic

Display level

Intermediate

Required role

System administrator

Configuration group

SQL Server Administration

A database size given in a create database statement takes precedence over the value set by this configuration parameter.

If most of the new databases on your SAP ASE require more than one logical page size, you may want to increase the default.

Note: If you alter the model database, you must also increase the default database size, because the create database command copies model to create a new user database.