January 10, 2011 at 1:42 pm
We are running SQL Server 2005 SP3 on Windows 2003. I have a few questions about some of the database tasks.
1. Under Shrink Database Task:
Is it best to Retain Free Space in Database Files? Does this reduce fragmentation by holding on to contiguous space?
2. Under Reorganize Index Task:
Compact large objects - does page level locking has to be enabled? Where would you enable it?
3. Reorganize Index and Rebuild Index Tasks:
Should both tasks be used? Are they a little redundant?
Should these tasks be used with System Databases?
What is the most efficient (or best) sequence to execute these two tasks?
4. All of my databases have the Compatibility Level set to "SQL Server 2005 (90)" but yet I received the following warning on all of the database tasks in the Maintenance Plan:
"Check Database integrity on Local server connection Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped."
Thanks in advance, Kevin
January 10, 2011 at 1:54 pm
I don't do those types of tasks in a Maint Plan. I rebuild specific indexes based on fragmentation. Run a script to identify those that need rebuilding.
As for shrinking, there are LOTS of threads explaining why shrinking is bad for performance (causes fragmentation) and should only be done in rare circumstances.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply