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	2^a –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.