Browse by Tags

• alter database
• auto grow
• configuration
• dashboard
• disk space
• error log
• monitoring
• performance
• reporting
• sql server

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

SQL Server 2005 Performance Dashboard Reports - making most out of it!
26 June 07 02:19 AM | SQL Master | 4 Comments   

Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow Read More...

Filed under: performance, sql server, reporting, databases, dba, dashboard