Post reply

can we run DBCC FREEPORCHACE in produciton if not why

  • September 19, 2014 at 2:52 am

    #151375

    can we run DBCC FREEPORCHACE in produciton if not why

    Thanks

    Naga.Rohitkumar

    Thanks
    Naga.Rohitkumar

  • September 19, 2014 at 3:19 am

    #1746631

    You can. It will force every single query to recompile, increasing CPU usage and slowing everything down, but you can run it if you really want.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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