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, and 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.dbo.sysattributes.
