sp_dbextend allows you to customize the database and device expansion process, based on site-specific rules. Database administrators can configure the size or percentage by which each database and segment pair should be expanded, and the size or percentage by which each device should be expanded.
You can also limit the expansion of a database segment or device by specifying a maximum size beyond which no further expansion is possible.
You can use sp_dbexpand in a test mode, to simulate the expansion processes based on your chosen policies.
sp_dbextend provides ways to list the current settings and drop site-specific policy rules.
This information is stored as new attribute definitions in master.db.sysattributes.
