IDERA SQL Query Tuner vs Terracotta BigMemory comparison

To maintain end-user satisfaction, it is critical to optimize the performance of the SQL queries that applications use to communicate with the underlying databases. SQL Query Tuner optimizes SQL queries by quickly discovering, diagnosing, and optimizing poor-performing SQL queries. Visually tune complex SQL queries. Load test in simulated production environments. Streamline SQL query tuning for SQL Server.

Go big, go fast with the world’s premier distributed in-memory data management platform that delivers extremely low, predictable latency at any scale. It’s the simplest, most cost-effective way to get lightning-fast, predictable access to big data—cutting processing time from minutes to seconds, or even less.

BigMemory makes your data available—in real-time—to your applications. Snap it into enterprise apps to speed up access to unlimited amounts of data in-memory, distributed across any size server array. Access 100s of TBs of data—or more—in real time. Scale up, scale out—even scale to the cloud.

Because BigMemory works without any proprietary virtual machines or special hardware, it’s easy to install. You can get started with as few as two lines of configuration change. It’s also wildly cost effective. At terabyte scale, BigMemory can slash application server footprint by 100x or more.