we’ve made a downgrade from Enterprise Evaluation Edition to Standard and we saw the over night jobs all running much longer these are ETL packages and SQL Stored Procedures to load data from application server to DW server(which was downgraded from Enterprise to Standard). All other haven’t changed including configurations, network etc. It seems the performance took hard hit but we don’t know where to start with? If you could help with some thoughts and advice that would be much appreciated. Please note, the downgrade was performed by a third party vendor and steps are as suggested on MSSQLTIP website - https://www.mssqltips.com/sqlservertip/3079/downgrade-from-sql-server-enterprise-edition-to-standard-edition/

Thanks In Advance Yang

  • 1
    There are performance improvements in Enterprise Edition, but not sure if you are hitting those or not. I'd start here and edit your post with the info in this post (I wrote it): brentozar.com/archive/2017/10/getting-help-slow-server
    – Tara Kizer
    Oct 16, 2017 at 15:14
  • Check Cross-Box Scale Limits section of this document. You can also collect aggregate wait stats during the ETL package run which might give you a lead, where to look at. Oct 16, 2017 at 17:22
  • If the third party brought in your previous system databases, I would expect that all of your configurations would be the same. However, it's possible that some configuration settings have different acceptable values under Enterprise vs. Standard. I'd review my configuration values (sp_configure), and make sure everything looks to be set correctly, just to be sure.
    – RDFozz
    Oct 16, 2017 at 20:03
  • How was downgrade done? Did you move to a new server? Oct 17, 2017 at 8:16
  • Thanks Tara for the referred post. Peter, the downgrade was done followed by the article as I mentioned in the post. We didn't move to a new server just reinstalled SQL; copy out and back in the sys databases. SqlWorldWide, we've checked the scale limits, we have 16 cores and max memory set to 70G, DW size around 900G which all within the range of limit of Standard Edition. And I believe, the core engine is the same as Enterprise, we do not utilise any features in Scale and Performance box too. @RDFozz, configurations all the same as master db copied.
    – yang
    Oct 17, 2017 at 14:36


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.