December 11, 2012 at 4:24 pm
Just showing an example in our environment.
BCC SHOWCONTIG scanning 'Table_Name' table...
Table: 'Table_Name' (274100017); index ID: 1, database ID: 13
TABLE level scan performed.
- Pages Scanned................................: 663139
- Extents Scanned..............................: 83063
- Extent Switches..............................: 166349
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 49.83% [82890:169350]
- Logical Scan Fragmentation ..................: 1.94%
- Extent Scan Fragmentation ...................: 24.29%
- Avg. Bytes Free per Page.....................: 277.4
- Avg. Page Density (full).....................: 96.57%
When I check the Scan Density it is 49.8% and Best and Actual count is not matching to close. It is double the count.
I would like to increase the Scan Density %. If I do re index then Best and Actual count is matching to close.
Currently for our Index Maintenance: we are running
If Logical Scan Fragmentation is 5-30% then it would do Reorg.
If Logical Scan Fragmentation is above 30% then it would do Rebuilt.
But, we are unhappy about the scan Density, How Automate a job process on increasing the Scan density?
Any help is greatly appreciated.
Thanks.
December 11, 2012 at 5:57 pm
December 12, 2012 at 8:43 am
We run daily index maint job.
here is the link which used to set up our index Maint job: http://ola.hallengren.com/
Any help how to increase the scan density ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply