PayLease is the leading online payment processor for property managers and HOAs. The company serves thousands of property management clients across the United States and was seeking a solution to help them better manage their massive amount of data and minimize slow periods.
Before VividCortex, they had to sort through nearly 10 gigabytes of data each time there was an issue, a cumbersome process that often proved ineffective. PayLease also wanted a tool that would better equip them to prevent future issues. They needed a predictive solution to flag issues that could become high priority down the road.
PayLease chose VividCortex because of the intuitive interface, level of granularity and functionality. They saw the difference immediately. Todd Newell, the Database Engineer, “I look at top queries on a daily basis. I recognize what is there, what should be there, and am able to quickly pull something out that is garnering way too many resources and re-architect it. The top queries view shows which queries were running, each version of those queries, the number of executions, and the amount of resources consumed. On an investigation level, this is extremely helpful.”
Now, they are able to recognize problems at the time of code release and immediately act. The granular detail of VividCortex allows them to see specific queries having issues and eases the pain of diagnosis. What typically took 3 – 4 hours and yielded uncertain results now renders actionable results immediately. The usability of the interface allows them to share this information with team member and management to prevents future issues and make their needs known. Beyond that, PayLease is no longer having to store and search through slow query logs, reducing their query storage from between 35 GB and 100 GB per day to less than 1 GB.
The full case study is available for download here. If you think this level of analysis could benefit your company, start your free trial today! As Kevin Palmer, Senior Systems and Software Engineer at PayLease stated, “It has features I never knew I needed like the ability to compare queries over time. It is becoming more and more integral in preventing and finding issues.”
To view the archives of case studies, visit here.