Total Pageviews

Sunday, October 30, 2011

Do you Know Improper Autogrowth can cause the timeout error for users (when they are firing DML) and for SQL DB engine itself.



Do you know in SP4 of SQL server 2000 ->Larger autogrowth or wrong autogrowth settings for DB files also affect for the time out error for users when they are firing DML queries or even SQL server will get cancels the expanding of the DB files and usually the message like this :

Autogrow of file ABC_Log' in database 'ABC cancelled or timed out after 29547 ms.
Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.


Go through the Below KB's ->very Interesting..one

http://support.microsoft.com/kb/822641
http://support.microsoft.com/kb/315512
http://support.microsoft.com/kb/305635 

So do the better autogrowth settings for the files so that you can avoid above issues.
(Even Performance, recovery of the databases, restore activities etc..).

No comments: