SQL Server Autogrowth settings

 

Do not use default setttings. See
http://support.microsoft.com/kb/315512

You can view the current settings through the database properties in SQL Enterprise Manager (SEM). Or, you can run the following Transact-SQL command:

sp_helpdb [ [ @dbname= ] 'name' ]

Leave a comment