Post reply

DBCC ShrinkDatabase + Insert Query same time

  • March 19, 2014 at 6:40 am

    #284750

    Hi,

    This is general one not specific to Database version(2k/2k5/2k8)

    DBCC ShrinkDatabase + Insert Query same time

    While shrink operation is happening can we insert a query ?

  • March 19, 2014 at 7:41 am

    #1698368

    Sure. Shrink is a fully online operation. Not something that should be run often, only under exceptional situations though.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 19, 2014 at 7:46 am

    #1698371

    Will there be any impact in insert or select or delete or update statement like slowness

  • March 19, 2014 at 7:55 am

    #1698377

    Sure. Shrink's an IO intensive operation.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 19, 2014 at 8:33 am

    #1698393

    GilaMonster (3/19/2014)

    Sure. Shrink's an IO intensive operation.

    You are saying that there will be impact or how?

    Sorry unable to get you.

  • March 19, 2014 at 8:39 am

    #1698396

    Yes, there will be impact. Shrink is an IO-intensive operation (does a huge amount of IO operations)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 20, 2014 at 3:08 am

    #1698596

    GilaMonster (3/19/2014)

    Yes, there will be impact. Shrink is an IO-intensive operation (does a huge amount of IO operations)

    Actually DBCC Shrinkdatabase is back ground operation , it should not affect usual works right.

  • March 20, 2014 at 3:16 am

    #1698599

    yuvipoy (3/20/2014)

    Actually DBCC Shrinkdatabase is back ground operation , it should not affect usual works right.

    Um, I've told you twice it will have an impact. Is this just a case of ignoring what you don't want to hear?

    Yes, there will be impact. Shrink is an IO-intensive operation (does a huge amount of IO operations)

    It is not a 'background operation', it's an online operation which does a lot of IOs and will have an impact on the rest of the system.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 20, 2014 at 3:46 am

    #1698610

    On top of what Gail has said, depending on the DB you are carrying out the Shrink work on - its size, how many indexes, etc. - you may experience performance issues due to the heavy, almost 100% fragmentation of the indexes of that DB caused by the shrink operation (see Paul Randal's article Why You SHould Not Shrink Your Data Files[/url]). Not an operation I would like to be doing, except in 'exceptional' circumstances.

Viewing 9 posts - 1 through 8 (of 8 total)

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