Post reply

result set from dbcc showcontig

  • December 3, 2007 at 4:44 pm

    #118992

    morning, evening all

    this is more about getting some reassurance than a problem as such.

    I have run Rodrigo Acosta script to list out the fragmentation within a database and its recommendation on whether the object requires defrag or not.

    I did this last week prior to a large multinational company doing some work on the database.

    We recieved a copy of the database - backup and restored it yesterday and this morning I ran the exact same script.

    NONE of the numbers - row count, % framentation etc have changed.

    I then ran another script to identify the unused space etc and again this is the same as the ones I ran before the work was done.

    As a test in another db I ran a dbcc dbreindex against a 334K table, ran the showcontig before and after and this time the numbers are different.

    Before I bring this up with management I REALLY need to be 110% sure. It 'looks' to me that they have rebuilt any of the indices.

    I did run a script to tell me when the last upstatistics was run and this showed that the dates were recent.

    So am I right in think a dbcc dbreindex was not done or is there another explanation?

    thanks

  • December 3, 2007 at 5:56 pm

    #756753

    what exactly u wanna prove? would liek to elaborate?

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • December 4, 2007 at 6:39 am

    #756903

    Well if the figures are identical, including rowcounts, then yes, you could assume that no reindexing was done.

    If I were in your situation, I would let your boss know what's happening and get onto the company who did the work and find out what they actually did. As you are the client, your well within your rights to ask them to provide a logsheet of what work was completed. Afterall, what you are seeing indicates the company has not done what you paid them for. Ask if they exported the results/output to a file.

    And just to ask the obvious question, have you restored the database they sent back to you and not the one you sent them?

  • December 4, 2007 at 1:38 pm

    #757122

    thanks for the replies - found the problem. Service providers restored the wrong backup!

Viewing 4 posts - 1 through 3 (of 3 total)

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