Member Login
  • Products
    • Qure Suite
    • Qure Analyzer
    • Qure Optimizer
  • Downloads
    • Qure Analyzer (Free)
    • Qure Optimizer (Trial)
  • Support
    • Contact Support
    • Frequently Asked Questions
    • Limitations and Known Issues
  • Resources
    • About Workload Tuning
    • Videos and Tutorials
    • SQL Server Articles
    • Whitepapers
    • Success Stories
    • Attend an Online Demo
    • inTune eMagazine
    • SQL Server Tuning
  • Company
    • About DBSophic
    • Management
    • Partners
    • News
    • Media Coverage
    • Customer Testimonials
    • Selected Customers
    • SQL Server Tuning Blog
  • 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

LEARN MORE
SQL Server Tuning
SQL Server Performance

© 2011 DBSophic Ltd. All rights reserved. | Legal