MicroStrategy® Incorporated, a leading worldwide provider of business intelligence (BI) software, today announced that in benchmark tests of its MicroStrategy 9.0.2 software, MicroStrategy Intelligence Server exhibited comparable scalability when running on both the Linux and Windows operating systems.
In MicroStrategy’s High Performance and Scalability lab tests, a 4-node clustered configuration of MicroStrategy Intelligence Server with 32 CPU cores operating on Red Hat Enterprise Linux delivered a power rating of 560 KiloCycles, which equates to 560,000 round-trip queries per hour. This query volume was sustained while supporting more than 100,000 active users and delivering average response times under 2 seconds. Meanwhile, the same configuration of MicroStrategy Intelligence Server running on Windows 2008 delivered a power rating of 550 KiloCycles supporting over 98,000 active users with sub 2-second response times. Both Linux and Windows configurations exhibited linear scalability in peak power ratings as the number of CPUs was increased from 1 to 32. Tests were conducted using MicroStrategy version 9.0.2 installed on commodity Intel-based hardware with a typical retail price of $69,844.
Performance Test Details: The performance tests were conducted using a standard test suite of 66 reports and 5 complex dashboards that were designed to incorporate the full range of report sizes and usage patterns consistent with enterprise BI applications. MicroStrategy created the test suite based on the application profiles of a dozen of its larger customers. The smallest report contained 1 row and 60KB of data, while the largest report contained over 218,000 rows and 23,602KB of data. The report complexity ranged from a single SQL pass to 149 SQL passes to calculate the report results. The average number of SQL passes for all reports in the test suite is 17. The database used contained 1TB of data with a 7 billion row fact table running on Oracle 11g. The tests operated against cached data as well as large-scale in-memory databases, within the 144GB memory space used by the MicroStrategy Intelligence Server in-memory cube technology. For more details, visit http://www.microstrategy.com/high-performance-bi/test-results/hp-bi-power-902.pdf.
MicroStrategy’s High Performance Initiative: In April 2010, MicroStrategy announced the launch of its High Performance Initiative, which includes a dedicated team of performance engineers and a multi-million dollar state-of-the-art research laboratory equipped with the latest database hardware, software, and performance testing tools. MicroStrategy’s engineering team runs hundreds of performance tests each week to benchmark software performance, further improve scale and performance, and uncover configuration options and design techniques to deliver higher performance for customers.
For nine consecutive years, MicroStrategy customers have analyzed the largest data volumes as compared to customers of all other BI products, according to The BI Survey, the largest independent survey of the BI market. In the latest BI Survey, 37% of MicroStrategy customers analyze over 1 terabyte vs. an average of 9.7% of BI customers in general. MicroStrategy’s customers have some of the largest and most sophisticated BI deployments in the industry. Here are several examples:
Lowe's Companies: The second-largest home improvement retailer in the world, Lowe’s has more than 38 terabytes of data. Lowe’s has multiple MicroStrategy-based BI applications that support over 16,000 employees across a variety of business functions, including applications that allow store managers to access store reports and business metrics. In addition, Lowe’s uses BI to help its suppliers and vendors monitor the performance of their products.
METRO GROUP: One of the largest and most international retailing companies, METRO GROUP uses MicroStrategy to analyze 80 terabytes of transactional, product, market, and customer data. MicroStrategy provides METRO GROUP with detailed insights to track business performance, optimize product assortment, and make timely decisions to enhance customer responsiveness. More than 15,000 employees across 30 countries use METRO GROUP’s BI applications.
“Our research consistently shows performance is a key concern impacting BI implementations and organizations’ abilities to provide faster and better decision making capabilities,” said David Menninger, Ventana Research VP and Research Director. “A disciplined approach in measuring and improving performance such as MicroStrategy’s High Performance Initiative provides real value to customers by addressing one of the key obstacles to a successful BI implementation.”
“As these benchmark tests demonstrate, MicroStrategy offers its customers the flexibility to operate their BI environments on the operating system of their preference, with the confidence to expect high levels of performance and scalability,” said Sanju Bansal, MicroStrategy’s Chief Operating Officer. “Approximately 35% of MicroStrategy customers choose to run their BI systems on Linux, while 45% run their environments on Windows, and we are able to provide superior scalability on both platforms.”
For more details about MicroStrategy’s high performance test results, visit http://www.microstrategy.com/high-performance-bi/test-results/.
Founded in 1989, MicroStrategy is a global leader in business intelligence (BI) technology. MicroStrategy provides integrated reporting, analysis, and monitoring software that helps leading organizations worldwide make better business decisions every day. Companies choose MicroStrategy for its ease-of-use, sophisticated analytics, and superior data and user scalability. MicroStrategy offers free reporting software that can be downloaded from its Website, http://www.microstrategy.com/freereportingsoftware. More information about MicroStrategy is available at www.microstrategy.com.