Post reply

dbcc dbreindex does not seem to reindex

  • April 28, 2008 at 7:32 pm

    #189643

    Hi All

    I am using a script from this site in helping me to manage my indices.

    I run a dbcc showcntig before, do the dbcc dbreindex and then do another showcontig.

    In 54 different table I seem to get no results - ie the show contig are the same before and after the dbcc dbreindex.

    Can someone please outline when this happens, and how do I get around it. I would like to get these tables defraged, so that I can start from a known point.

    The only common point I can think of this that all these tables have pages less than 25 - not sure if this has any bearing.

    thanks

  • April 28, 2008 at 11:07 pm

    #808117

    Found my answer.

    Apparently expected behaviour - have a look at this post.

    http://www.sqlservercentral.com/Forums/FindPost275092.aspx

  • April 29, 2008 at 5:44 am

    #808244

    I posted the same question at Connect. One of the MS reps gave me a good response.

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=244214

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 29, 2008 at 7:44 am

    #808345

    use the new sql 2005 commands, they are a lot better than the old sql 2000 ones

  • April 29, 2008 at 1:49 pm

    #808648

    thanks guys for your comments.

    Read the MS reply and it makes sense and its bears out what some other people have said on this site.

    Have to stick with the sql 2k commands as its a sql 2k installation still.

    I will be using the sql 2k5 commands for that type of installation

    once again thanks

  • April 30, 2008 at 11:53 am

    #809228

    One additional comment: it doesn't do much good to defrag indexes in a database that doesn't have sufficient free space in it either. And given the number of clients I have had that have virtually no free space (often due to default database growth settings) this could also be adding to the problem.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • April 30, 2008 at 1:22 pm

    #809287

    thanks TheSQLGuru

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply