Clalit Health Services Installs DBSophic's Database Performance Optimization Solution

Share Article

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.

News Image

Past News Releases

RSS

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.

About DBSophic
DBSophic develops innovative software solutions for database performance optimization. DBSophic provides comprehensive, fully automated, yet simple solutions for performance tuning and optimization of database systems.

DBSophic's flagship software solution 'Qure' provides organizations with a rapid return on investment, resulting from reduced staff time spent on addressing database performance problems. Qure reduces the DBA's time spent looking for the causes of performance problems and helps organizations to continuously improve their databases' performances.

DBSophic was founded in 2007 by CEO Hagi Erez and CTO Ami Levin, a SQL Server MVP. The company's headquarters and R&D are located in the high-tech village- in Givat Ram, Jerusalem, Israel.

For more information about DBSophic or to download the company SQL databases performance optimization free trial version, please visit http://www.dbsophic.com.

Contact information:
Inbal Barit
DBSophic
Phone: +972-2-6542742
Fax: +972-1532-6542742

# # #

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Inbal Barit
DBSophic
+972-2-6542742
Email >
Visit website