Microsoft SQL Database Upgrade 2017-10-21T04:33:24+00:00

Microsoft SQL Database Upgrade Services

Minimize downtime, maximize performance, and reduce risk with detailed planning and testing for seamless upgrade and system cutover

Performance Tuning’s Microsoft SQL Upgrade Services allow you to leverage advanced Microsoft expertise to successfully upgrade MS SQL systems, ensuring efficient planning, testing, implementation, and cutover.

Microsoft SQL Upgrade Services consist of three service areas:

  • Migration/Upgrade Pre-implementation Planning
  • Test Upgrade Implementation and Planning for Final  Cutover
  • Final Upgrade and Cutover

Upgrade Pre-implementation Planning

A pre-implementation service, this cross functional planning workshop helps ensure that a proper upgrade methodology and test plan is defined and documented, according to best practices and PTC’s proven expertise. The deliverable is a clear Upgrade Plan. This service assumes that a system has been sized and architected to meet requirements. Planning is required for all Upgrade Services to ensure success. Task areas for this service include:

  • Review technical requirements and deliverables
  • Identify and coordinate key project stakeholders and team members for delivery
  • Identify network connectivity and systems access requirements
  • Validate physical environment – OS, Database, network, storage, application servers, etc.
  • Review downtime requirements
  • Review optional methodologies for upgrading with pros and cons
  • Review Scheduling and Resources
  • Create Upgrade Test Plan – a detailed step by step plan that will be tested and validated in the next phase, and includes a Rollback Plan

Test Upgrade Implementation and Planning for Final Cutover

A test upgrade may involve two phases – an initial upgrade of the test environment, and a full upgrade of the test system QA purposes. Considerations include:

  • Validate data integrity
  • Identify and isolate invalid objects
  • Record timings for each step (export, import, ETL)
  • Test database and port
  • Test operational and administrative tasks
  • Prepare for Final QA Testing and Performance Testing by Client
  • Create Production Upgrade Plan

Final Upgrade and Cutover

Once the QA system is validated and proven, and any necessary changes are made to the Final Upgrade Plan, the updates and cutover into Production will be performed.

  • Perform final upgrade
  • Perform system switchover
  • Assess system performance and functionality; determine debug, continue, or roll back
  • Provide remote support after go-live

Latest From the Blog

Move Oracle Database Audit Trails To A New Tablespace

Move Oracle Database Audit Trails To A New Tablespace Auditing is the monitoring and recording of selected user database actions. For Oracle Database, the Oracle Database Audit Trails assist in the auditing process.  In [...]

What Our Clients Say

“Performance Tuning was able to quickly troubleshoot and resolve many technical issues that often eluded other consulting companies we’ve worked with. I was most impressed by their quick response in emergency situations. They’ ve been instrumental in the delivery of Oracle technologies such as Oracle RAC, Grid Control and Data Guard.”

James Jech, Dell

“Performance Tuning was able to offer unique insights to database design and performance tuning optimization on a world class level. They did a superb job of load testing, which was cited by Microsoft (a team member) as, the best we’ve seen in three years and 50 customers to come through our SQL Server Performance Tuning Lab. This statement came from the SQL Server Product Group in Redmond – a tough crowd to please. In addition, they accelerated several products including our flagship Thomson ONE Analytics and were a key part of a project whose success has lead to case studies by Intel, Microsoft, and Unisys.”

Jeremy Lehman, Thomson

“The Instructor was able to customize the course slightly to meet the needs and levels of experience in the class. It was great to get some real hands on to cement in what was reviewed and explained.”

Chad Aberle, Microsoft

“We recently had a problem with SQL Server performance after introducing virtualization and a SAN in our server environment. After working with two different consulting companies without success, we contacted Performance Tuning Corporation. PTC rapidly set up a remote engagement with us, and within one week was able to identify a problem with a virtual device driver. We are very satisfied with the work PFC performed, and feel it is some of the best consulting money that we have spent in several years.”

Howard Brill, PHD, Monroe Plan

PTC has been phenomenal. It’s a scary time when your most critical data is being moved while users are in the system working. Especially on the heals of our previous vendor’s failed attempt. I can only describe it as a calming effect when true professionals are running the show.

IT Healthcare Manager, Opelousas General Health System

“We are very pleased with the work that PTC performed. They were able to extract information from SQL Server and use that information to identify the exact causes of our performance bottlenecks. They provided us with information, tools, and instructions on how we can locate the cause of our performance problems. The final report contained good information and gives us a benchmark for doing future performance reviews.”

Jon Robertson, MedEvolve

“This is a well balanced course (Optimizing Oracle RAC on Linux) covering all major topics from System Administration to Database Administration unlike most of the courses”

Manish Bijlani, RealtyData Corp.

Our Clients

Over 1000 clients from all industries have benefitted from our database services