Following the successful integration of the DBSophic's Qure software, Israel's largest HMO has significantly reduced costs associated with managing its many databases, while increasing operational efficiency.
Jerusalem, Israel, September 15, 2009 -- Clalit Health Services, Israel's largest health maintenance organization (HMO), has successfully completed the installation of DBSophic's flagship software solution Qure, which optimizes SQL Server databases performance.
Following the deployment of DBSophic's innovative Qure solution, Clalit has managed to significantly improve database effectiveness, increase operational efficiency and reduce staff time spent on fixing performance problems. The users reported better response times and a much improved user experience. Timeouts stopped occurring after implementing the Qure recommendations. Additional databases were analyzed with Qure after that and got similar improvement results.
The improvements have translated into a real reduction in Clalit's overall IT costs and helped improve the service provided to close to 4 million customers. This is especially significant as the organization, which operates the largest SQL Server databases in Israel, relies on hundreds of applications and thousands of databases, of which over 500 are considered critical.
DBSophic's flagship product, Qure is an innovative software solution for automatic analysis, identification and resolution of slow performance issues in databases. Qure analyzes all the aspects of the database and generates pinpoint recommendations (including corrective code) for performance optimization in four main areas: smart indexing, query syntax optimization, schema optimization and additional optimizations.
"Since 2006, we have been using an Application Performance Management (APM) suite to help us locate our performance bottlenecks. Qure complements the suite's capabilities. The great thing about using Qure is the added level of awareness it provides us, highlighting not just where the problems reside, but what we need to do to fix them," said Doron Ytshaki, Clalit Health Services' CTO.
"Qure makes recommendations that, without it ,database personnel would have a difficult time identifying and implementing, such as data-type changes," Shalom Ovadia, Clalit's chief SQL Server DBA said. "Qure also cross-references all of its recommendations so that it knows whether adding a certain index, for example, would harm other functions on the same table. This is definitely something we couldn't have done efficiently without Qure due to the high complexity of our systems."
Rabia Mansour, Clalit's chief architect officer added that Qure has helped Clalit improve customer satisfaction. "Even if we bring in a professional to service the database, it is a very long and time-consuming process, especially in a large organization that is constantly seeking agility such as ours," noted Mansour. "By using Qure, time requirements for detecting performance bottlenecks and actually solving them are significantly reduced, which means that the clients are happier, since their problems receive a high quality, fast solution."
"The successful completion of the large-scale and complex project at Clalit demonstrates the unmatched abilities of the Qure solution," said Hagi Erez, CEO and co-founder of DBSophic. "In this case it has been clearly proven that Qure is the most effective, fast and simple solution in the market."
In the case of Clalit Health Services, Qure's analysis results showed that the average duration time of the most frequently used queries within a specific critical database (which services billing purposes) was cut by 92.15 percent to only 4.23 minutes from 53.89 minutes previously. The number of physical reads plunged 92.75% to 11,100 from 1.53 million; and the number of central processing units (CPU) dropped 93.37% to 3.59 minutes from 54.17 minutes. Clalit DBA team is planning on optimizing all of its critical databases with Qure.
About Clalit Health Services
Clalit Health Services is one of the largest health care organizations in the world with facilities comprising over 1,300 clinics, 14 hospitals and 400 pharmacies, servicing over 3.9 million people.