January 10, 2011 at 5:00 am
Hi All,
As a DBA of the company I am suppose to schedule a plan for defragment of my server .
The server has less space and I cannot delete any data.
I am confused as what steps to follow?
The steps what is being noted by ex-dba is
1. defrag the server.
2. rebuild the index.
3. defrag the server.
etc... checking of site working/links etc.
I am not confident with the values returned by DBCC showcontig as I am not getting clear as what it really means. I have read the BOL but I am still not able to judge whether to use reindex or not.
I need to know
1. how to determine from the result of dbcc showcontig whether I have to reindex.
2. Which is better DBCC reindex or defrag the index.
3. How frequently should i schdule for defragment, and also when to restart the main server machine, before or after defrag.
If anything else I have not added for the checklist please do tell me.
Thanks,
Harsha:-)
January 10, 2011 at 3:10 pm
1. how to determine from the result of dbcc showcontig whether I have to reindex. - Index ID must be greater than 0 (0 means it is a heap). Pages scanned greater than 10,000 (Microsoft will not rebuild an index on a page count smaller then 10,000. Rebuild when Logical Scan 20% or greater, Reorg when Average Page Density is low.
2. Which is better DBCC reindex or defrag the index. - Not comparing apples to apples.
3. How frequently should i schdule for defragment, and also when to restart the main server machine, before or after defrag. - Depending on size, usage, etc. Do you have a baseline you can go off of? If not, now would be a great time to start. Clean everything up, wait a week (if large or substantial usage), or month (if small and low usage), rescan and track.
Please review the following article from TechNet
http://msdn.microsoft.com/en-us/library/ms175008.aspx
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply