Post reply

SQL Server Index and Statistics Maintenance

  • December 11, 2012 at 4:24 pm

    #271615

    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

    #1567658

    How often you run the job for the re-org and re-index maintainance ?

    Scan density <100% means to frangmentaion existance.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • December 12, 2012 at 8:43 am

    #1567924

    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