Hi All, I am using the following autogrowth settings on all my sql servers based upon the data the growth observed so far but the Users still complain the application is slow,am i missing something. USE [master] GO ALTER DATABASE [model] MODIFY FILE ( NAME = N'modeldev', SIZE = 1024000KB , FILEGROWTH = 512000KB ) GO ALTER DATABASE [model] MODIFY FILE ( NAME = N'modellog', SIZE = 2048000KB , MAXSIZE = 24576000KB , FILEGROWTH = 1024000KB ) GO And i just realised that the databases are not inheriting these default growth settings that i have applied to the model database,going through the blogs found that this is a known issue and since it has a workaround this is not going to be fixed,not sure what the work around is.
https://connect.microsoft.com/SQLServer/feedback/details/778069/default-datafile-settings-not-applied Thank you, BT
2 issues here: 1. You haven't got your user databases set with the autogrowth settings that you wanted - fix: you are going to have to go and amend these settings manually or carefully through scripting/Powershell 2. Users are complaining of a slow database. How is this connected to autogrowth? Have you identified that the performance is being hurt when an autogrowth event happens? If so, then fixing the settings should alleviate it.