SQL Server “upgraded” (without the hardware cost) using Red9 SQL Managed Services for Leland Management

Challenges

  • Unpredictably slow SQL Server
  • No proactive care
  • Missing best practices

Solution

Benefits

  • Stable SQL Server
  • Significantly faster SQL processing
  • Satisfactory SLAs
  • Faster key business processing
  • More SQL Server capacity
  • Savings in hardware upgrade
  • Happy internal and external customers

Background

Leland Management is one of the largest and most well-respected real estate management companies in the state of Florida.  In the past 20 years, Leland has grown from a single employee to more than 400 employees managing 400+ communities throughout 14 offices statewide. 

In 2019, Leland started experiencing major slowdowns with its third-party property management software.  The systems were so slow that it impacted their ability to complete their monthly invoicing on time, as well as other critical business functions.  When they approached their software vendor regarding the speed issues, they were told to upgrade their hardware which often comes with a six-figure price tag. 

Leland engaged Red9 to validate the advice of their third-party software vendor. After running a thorough evaluation including our proprietary 145 point health check, Red9 determined that the hardware upgrade was not only costly and unnecessary but would not resolve the speed issues.  In fact, the issues Leland was experiencing were being caused by the way the queries were written within the third-party software.  

Leland had two choices to resolve their issues, build custom software in-house to replace their property management vendor or continue to try to work with what they had.  

Ripping and replacing their existing solution would have not only been costly for Leland, but time-consuming.  Instead, Leland chose to work with Red9 and joined our managed services program.  Every month, Red9 tunes and optimizes Leland’s database to continually make it faster and more stable.  As a result,  Red9 was able to resolve Leland’s speed issues which allowed them to forgo the expense of the hardware upgrade and/or replacing their existing software.

Problem

Red9 identified multiple SQL Server problems:

  1. The client received bad guidance from its third-party software vendor due to the vendor’s lack of experience in high-volume SQL Servers.
  2. Third-party software vendor software was inundated with extremely inefficiently written SQL queries. 
  3. SQL Server was lacking numerous SQL Server best practices, maintenance and monitoring.

Solution

At Red9 we always start with our proprietary 145 point SQL Server Health Check which we used to uncover a variety of technical issues.

  1. SQL Server Health check analyzed and prioritized all SQL-related issues.
  2. SQL Server best practices deployed, including security, maintenance, configuration, Windows OS settings,  storage configuration changes, how databases and files were spread across disks, and more.
  3. Deployed SQL Server monitoring and alerting to catch problems proactively.
  4. Worked with the third-party software vendor to identify how to best work together. We came up with an innovative way to deploy SQL performance tuning changes safely without interfering with the third-party software vendor and their patching process without voiding software support.
  5. Red9 has been continuously tracking down worst-performing queries and performance tuning them. Slow queries being identified using two methods: 1. Leland identified a screen of the software which was slow and  Red9 then identified which SQL statements were invoked. 2. Red9 identified the slowest SQL statements client ran over the last 14 or 30 days, aggregated, and made SQL performance improvements.

Results

  • The six-figure SQL Server hardware upgrade project was deemed unnecessary and postponed indefinitely. Mostly because SQL performance tuning achieved necessary performance metrics.
  • Higher SQL Server capacity and speed
    1. Since the start of engagement about 75 slow queries have been performance tuned 
    2. Average query run duration was decreased: 9x times
    3. Average storage cycle consumption was decreased by 146x times
    4. Average CPU processing time necessary reduced by 83x times
  • Reduced complaints – internal employees and external customers are no longer complaining about how slow software works, increasing satisfaction in clients’ services.

Testimonials

Contact Us

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