Browse by Tags

• alter database
• auto grow
• backups
• baseline
• benchmarking
• best practice
• blog
• cache
• configuration
• cpu
• dashboard
• dba
• dbcc shrinkfile
• disk space
• downloads
• environment
• error log
• huge
• indexed view
• indexes
• management
• memory
• microsoft
• operating system
• performance
• performance monitoring
• security
• sql server

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases Read More...

Filed under: sql server, cache, memory, indexes, databases, cpu, monitoring, operating system, huge, dbcc shrinkfile

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 performance monitoring requirement and specifications, heard about baseline and benchmarking?
19 December 07 05:06 AM | SQL Master | 3 Comments   

How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes' for all the Read More...

Filed under: performance, sql server, microsoft, security, blog, databases, dashboard, best practice, backups, monitoring, baseline, performance monitoring, downloads, environment, benchmarking

Guidelines for enabling indexes and online index operations
08 October 07 06:50 AM | SQL Master | 4 Comments   

As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version. Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and Read More...

Filed under: performance, sql server, management, indexes, databases, dashboard, indexed view, monitoring