cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Upgrading to SQL Server 2014

Level 17

As a production DBA for over seven years with a large-ish financial services company, I've seen more than my share of upgrades. Over the years I've added and modified my upgrade/migration checklists. The latest version, for SQL Server 2014, is available here:

Upgrading to SQL Server 2014: A Dozen Things to Check

The post covers a variety of topics:

  1. Hardware
  2. Compatibility checks
  3. Data integrity
  4. Upgrade versus migration
  5. Ensuring reliable performance

Have a look and let me know if there is something you have on your checklist that you feel should be on mine.

2 Comments
Level 12

Hi,

- Memory, CPU, NIC teaming and SANs solution

- OS version

- Full Backup and database maintenance

- Creating DNS Alias

- Load Balancing

Also, SolarWinds Database Performance Analyzer (Formerly Confio Ignite) for SQL Server!!!

Resolve SQL Server Performance Problems:

•Identifies the performance problems most impacting end user response time

•Isolates root cause in just four clicks

•Illustrates historical trends explaining performance over days, months & years

•See a direct correlation between SQL Server response time and VMware resource metrics

•Agentless architecture, install and see results in minutes

Level 15

Helpful information.  We have not moved forward to SQL 2014 yet.  Bookmarking this post.

About the Author
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft® Certified Master, SQL Server® MVP, VMware® vExpert, and a Microsoft Certified Trainer. He has over 20 years experience in the IT industry in roles including programmer, developer, analyst, and database administrator.