locked
sql2012 and sql 2016 comparison RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi everyone,

    W are just doing a migration from sql 2012 enterprise  to sql 2016 standard. This involves migrating lots of sql jobs running on sql 2012. I would like to make sure that performance doesn't degrades after we migrate. I would like to check and compare all configurations ( Sever  as well as DB level) on two machines. can someone help with quick sql script which I can ran on both machines and see if there is any differences?

    Thanks,

    Rohit

    Monday, July 6, 2020 3:41 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    is this a better way to do this?

     

    SELECT *
    FROM sys.configurations
    ---where value_in_use = 1
    ORDER BY name ;
    GO

    Monday, July 6, 2020 4:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    How do you migrate your dbs?

    Use DMA or other migration tools?

    Tuesday, July 7, 2020 7:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    No I just did a simple restore with backup of old DB.
    Wednesday, July 8, 2020 12:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi 

    If you wnant to compare the difference after restore in one new version,please monitor the performacne with Qury Store.

    Helpful information: query-store-usage-scenarios

    BR,

    MIAOYUXI

    Wednesday, July 8, 2020 6:43 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi SSIS123,

    Is the reply helpful?

    BR,

    MIAOYUXI

    Thursday, July 9, 2020 1:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I'm following this open case and is the issue solved?

    You can choose to mark the helpful reply as answer  to close this case.

    BR,

    MIAOYUXI

    Friday, July 24, 2020 9:26 AM