Post reply

Perfmormance impact after downgrade from Enterprise to Standard

  • March 3, 2017 at 1:09 am

    #401717

    I noticed performance impact after downgrade (Enterprise was removed and Standard was installed).
    Generally during day, wait stats are similar, but check db slowed down terribly. From 30 min to 3 hours.
    The backup time is the same. Any ideas?

  • March 3, 2017 at 1:11 am

    #1931414

    You downgraded from Enterprise (which has a lot of performance features over the other editions) to Standard. You should expect that things are slower.
    The one that's probably biting you is the "Parallel consistency check", which only Enterprise edition has

    https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

    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 3, 2017 at 1:34 am

    #1931420

    Thanks for your explanation. Now I see. Before downgrade %processor time was average 65%, now is about 10%.

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

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