Browse by Tags

• alter database
• auto grow
• configuration
• dba
• disk space
• message
• monitoring
• performance
• recovery
• sql server
• sqlagent
• suspect

Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
21 February 08 05:22 AM | SQL Master | 2 Comments   

The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands Read More...

Filed under: performance, sql server, databases, dba, error log, disk space, monitoring, configuration, auto grow, alter database

Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
05 September 07 01:13 AM | SQL Master | 2 Comments   

Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for Read More...

Filed under: performance, sql server, message, databases, sqlagent, recovery, suspect, error log