eDerm migrates SQL Server to the Azure while upgrading SQL version with minimum downtime while significantly increasing SQL speed

Challenges

  • SQL Server unreliable
  • Slow SQL
  • Lack of senior SQL experience internally

Solution

Benefits

  • Stabilized SQL Server
  • Significant SQL speed increase
  • Expanded SQL Server capacity
  • More SQL Server capacity
  • Savings in hardware upgrade
  • Successful SQL Server migration and upgrade
  • Minimum downtime

Background

eDerm is the largest independent dermatology practice in the country with over 1,800 facilities in 25 states. All of eDerm’s practices are tied into a single centralized server.  When eDerm began experiencing stability and performance issues the impact was felt across all of their locations and none of the internal fixes they deployed addressed the issues.   eDerm engaged Red9 and we were able to successfully stabilize the environment and maximize performance. 

When eDerm decided they needed to upgrade and migrate to a new server and data center they knew that Red9 had the Sr. DBA’s on staff and expertise to handle a project with this level of complexity. There was a lot of internal concern around how potential downtime might impact office locations and patients given their size and scope. 

Red9 had a thorough, well-thought-out plan for each and every step of the migration.  As a result, the process was seamless, eDerm avoided downtime during critical business hours and the project was completed without any major interruptions or rollbacks.

Problem

There were many.

Client wanted to address as many SQL Server problems as possible, while also migrating SQL Server from on premises to to Microsoft Azure, implementing AlwaysOn, disaster recovery, migrating hundreds of SSRS reports, and SSIS packages. Requirements also included implementing the best Win OS practices, setting up SQL Server with best practices for speed and reliability, implementing SQL monitoring and alerting and addressing lots of slow SQL queries.

Solution

At Red9 we often start with our proprietary 145 point comprehensive SQL Server Health Check <link> which we used to uncover a variety of technical issues.

  1. Setup SQL Server with best practices for stability and performance..
  2. Performance tuned worst performing slowest queries.
  3. Deployed custom SQL monitoring and alerting.
  4. Performed SQL Server migration to Azure with just few minutes of downtime. 

 

In preparation for SQL migration, Red9 created in-depth SQL migration project plan. Each plan step was tested, duration measured, owner for execution assigned. Each step contained pre-written TSQL scripts to be run. Red9 also led coordination with multiple technical client teams to ensure everyone was in synch, knew when to execute assigned sections. 

Red9 also did comprehensive testing. This was done by capturing 8 hours worth of SQL Server workload from client’s production SQL SErver and then rerun that workload on the new SQL Server. This allowed to clearly see how SQL Server performance compares between old and new SQL Servers.

Results

All client’s goals were achieved successfully with only few minutes of downtime.

Testimonials

Contact Us

Call us at: 877-891-1870
Or, tell us how can we help and we will contact you.