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
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:
Post a Comment