Provider of web-based transportation management software uses DBSophic’s Qure Optimizer to tune performance of SQL Server based application
JERUSALEM, Israel, January 24 2012 – DBSophic, an innovative provider of performance management products for SQL Server based applications, announced the successful deployment of its Qure Optimizer solution at SmartFreightWare. Qure Optimizer is the first product to implement workload tuning, a new approach to SQL Server performance optimization. Unlike traditional query-by-query tuning techniques, workload tuning optimizes the entire database workload automatically.
SmartFreightWare provides intuitive and affordable Transportation Management Software (TMS), backed by expert logistics consulting services. SmartFreightWare’s web-based TMS solution, SmartTMS®, helps companies lower transportation costs and reduce administrative and operational tasks associated with transportation and shipping.
With the increased adoption of SmartFreightWare’s SmartTMS®, the company has focused on maintaining the highest levels of application performance. “We found that the performance of the underlying SQL Server database was becoming a major bottleneck,” recalls Kurt Hadermann, SmartFreightWare’s CIO. “Timeouts and long-running queries were becoming a concern and adversely impacting system performance”.
Faced with these issues, SmartFreightWare turned to DBSophic’s SQL Server tuning solution to optimize the database workload. After an automated analysis of the TMS workload, Qure Optimizer provided hundreds of specific recommendations, complete with executable scripts for applying the recommendations to production. “We’ve already deployed 334 Qure recommendations to our production system, including 75 new indexes and 27 SQL code rewrites,” explains Hadermann. “The results have been outstanding. Qure Optimizer has greatly increased the efficiency of our application, with some queries now running as much as ten times faster.”
A free trial version of Qure Optimizer, as well as a white paper about workload tuning, may be downloaded from the DBSophic website.
SmartFreightWare provides intuitive and affordable Transportation Management Software (TMS), backed by expert logistics consulting services. SmartFreightWare’s web-based TMS solution helps companies lower transportation costs and reduce administrative and operational tasks associated with transportation and shipping. The company’s offering includes SmartSaver, a quick and simple low-risk option that gives companies a jump-start to lowering transportation costs, and SmartTMS®, a more robust and customizable option for companies that need a broader scope of transportation management functionality.
DBSophic is an innovative provider of performance management products for SQL Server based applications. While traditional SQL Server tuning tools focus on individual query optimization, DBSophic delivers automatic workload tuning. By optimizing the entire application-to-database workload, DBSophic's solutions help companies achieve unparalleled gains in SQL Server performance for their enterprise applications. The company is headquartered in Jerusalem.