Case Study: National Beverage Company boosts Synapse performance and cuts costs with Insight’s PLUS

Well-Known Beverage Manufacturer Optimizes Performance With PLUS

National Beverage Company, a franchised branch of a national beverage company, worked with Insight to improve performance and reduce the cost of its Azure Synapse Analytics data environment. After years of data growth and an outdated structure, the team was facing slow query performance, rising DWU consumption, and increasing time spent troubleshooting.

Insight implemented its Performance and Learning Utility for Synapse (PLUS) to analyze the database, identify best-practice optimizations, and automate much of the remediation work. Insight applied 80 table and storage changes, compressed 66 tables, and completed the project in four weeks, delivering a 301% performance gain across the full test set, up to 612% on small queries, and a 33% reduction in DWU consumption and costs.