InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:05:26 GMT20http://www.sqlservercentral.com/Forums/Topic1424142-146-1.aspxThanks both for the replies as always.Perhaps I recall wrong Gail, I come to have more and more mistrust in my memory each day! It didnt seem a good idea hence my post!Thanks againTue, 26 Feb 2013 10:27:28 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1424142-146-1.aspx[quote][b]david.alcock (2/26/2013)[/b][hr]Just wanted to ask for confirmation really I read regarding a databases auto growth. Say if it is set to 10% and you experience a fair aount of growth during the day does the actual auto grow process have a noticable effect on system performance.[/quote]It can do, especially if the IO subsystem is overloaded and instant init is not on[quote]Reason I ask is that I read once that it is not uncommon for admins to configue the size of a database to cover the growth and then shrink the db's out of wroking hours afterwards?[/quote]I hope that's not common, that's a horrid practice. Why shrink overnight (fragmenting indexes) just to grow the next day (probably getting file system fragmentation too). That's a major waste of resources and time. Grow the DB to a sensible size, monitor free space, when free space drops below a comfortable threshold grow the DB again.Tue, 26 Feb 2013 09:39:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1424142-146-1.aspxDepends really....If [b]Instant File Initialisation [/b] is turned off then yes, auto growth on a large DB can affect performance temporarily.Say you have a DB of 200GB size, when auto growth kicks in, imagine how long it's going to take SQL Server to zero out 20GB worth of disk space? A couple of minutes at least....Tue, 26 Feb 2013 09:38:37 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1424142-146-1.aspxJust wanted to ask for confirmation really I read regarding a databases auto growth. Say if it is set to 10% and you experience a fair aount of growth during the day does the actual auto grow process have a noticable effect on system performance.Reason I ask is that I read once that it is not uncommon for admins to configue the size of a database to cover the growth and then shrink the db's out of wroking hours afterwards?Tue, 26 Feb 2013 09:23:22 GMTdavid.alcock