Post reply

Migrating to 2014

  • December 24, 2015 at 6:49 am

    #303405

    Hi,

    We have SQL Server 2008r2 stand alone.

    We are planning to migrate to SQL 2014 cluster. Do we need to upgrade SQL Version then migrate to cluster or first we have to migrate to cluster then do the SQL Upgrade?

    Please let me know the best approach and possibility of issues while doing migration

  • December 24, 2015 at 9:00 am

    #1847942

    IMO, the best bet would be to create the 2014 cluster on new hardware and then migrate database(s),logins, jobs,etc to new instance. your databases will get upgraded when restoring them to the 2014 instance. doing it this way will leave you with a quick fall back if this don't go right.

    as always, test the upgrade in a non-production environment as well as the application.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • December 24, 2015 at 1:28 pm

    #1847983

    Robert klimes (12/24/2015)

    IMO, the best bet would be to create the 2014 cluster on new hardware and then migrate database(s),logins, jobs,etc to new instance.

    This.

    I don't think you can convert a standalone instance to a clustered instance.

    Test carefully before you upgrade. Because of the changes to the cardinality estimator, you WILL get performance changes. Most will be good, some will be very bad. You want to have those fixed before the production upgrade.

    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

  • December 30, 2015 at 12:39 pm

    #1848824

    Thanks for the replies.

    What do you mean changes to the cardinality estimator?

  • December 30, 2015 at 2:54 pm

    #1848851

    https://www.google.com/?q=SQL+Server+2014+changes+to+the+cardinality+estimator

    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

  • December 31, 2015 at 6:20 am

    #1848918

    Just bear in mind that if for whatever reason your databases are using the older compatibility level then the changes to the CE will not take effect.

    Here are some testing recommendations from Microsoft, you might find that useful.

    https://msdn.microsoft.com/en-us/library/dn600374.aspx

    'Only he who wanders finds new paths'

  • January 11, 2016 at 3:19 pm

    #1851174

    Are you thinking of traditional Clustering with Shared Storage or Always ON Availability Group Clustering nonshared storage?

Viewing 7 posts - 1 through 6 (of 6 total)

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