Member Login
  • Products
    • Qure Suite
    • Qure Analyzer
    • Qure Optimizer
  • Downloads
    • Qure Analyzer (Free)
    • Qure Optimizer (Free Trial)
  • Support
    • Contact Support
    • Frequently Asked Questions
    • Limitations and Known Issues
  • Resources
    • SQL Server Articles
    • Whitepapers
    • Videos and Tutorials
    • Attend an Online Demo
    • inTune eMagazine
    • SQL Server Tuning Blog
  • Learn More
    • About Workload Tuning
    • SQL Server Tuning
    • SQL Server Performance
    • SQL Server Performance Tuning
    • Tips
  • Company
    • About DBSophic
    • Management
    • Partners
    • News
    • Success Stories
    • Customer Testimonials
    • Selected Customers
  • Contact Us

MediaMind

50% overall database performance improvement at MediaMind

MediaMind is a global provider of digital advertising solutions that optimize the use of media, creative and data for enhanced campaign performance.

MediaMind is a fast growing company and is constantly improving its IT infrastructures to accommodate fast growth while maintaining response times and service levels. The company has invested considerable resources, including the purchase of an expensive APM suite and tools in order to improve database performance.

MediaMind has recruited a highly skilled, expert DBA team. Qure automatically analyzed a backup of the main production server and generated dozens of recommendations. Most of the recommendations were implemented on the production server after a short period of testing. A benchmark that was performed on the workload after applying all recommendations revealed 53% total improvement in query duration, 63% in CPU resource consumption, and 50% in logical reads (disk IO and memory resources). The duration of two most resource-consuming queries in the workload, which had previously extracted a severe performance penalty on the production system, dropped from 26 minutes to 1.5 minutes, and from 10 minutes to 10 seconds, respectively.

<< Back to case study list

Total Resource Usage Improvement:

For a two-hour workload

eyeblasterTable 1 eyeblasterGraph 1

 

Top Query Performance Improvement:

Improved from 26 minutes to 83 seconds!

eyeblasterTable 2 eyeblasterGraph 2
© 2011 DBSophic Ltd. All rights reserved. | Legal