Aras Provides New Level of Scalability on Microsoft SQL Server Database
February 25, 2014 No CommentsANDOVER, Mass. and Munich, Germany – February 25, 2014 – Aras®, the next leader in enterprise Product Lifecycle Management (PLM) software, today announced the results of independent testing conducted by Logic 20/20 for the scalability of Aras Innovator 10 running Microsoft SQL Server 2012 Enterprise Edition on HP ProLiant servers with the HP ioDrive2 Duo IO accelerator technology from Fusion-io. Results validate optimal performance and resource utilization for 500,000 named users with 125,000 concurrent users – the largest testing conducted to date in the enterprise PLM industry.
Logic 20/20 Scalability Benchmark Methodology and Performance Results report available at http://aras.com/plm/002298
“SQL Server 2012 is designed to provide the performance and scalability required by the most demanding mission-critical applications whether they are running in the data center or the Cloud,” said Simon Floyd, Director of Product Lifecycle Management Solutions at Microsoft. “Together Aras, Microsoft, HP and Fusion-io deliver predictable scalability, high user concurrency and performance required by the world’s largest manufacturers to compete and innovate in a fast changing global market place.”
Tests were conducted on Aras Innovator 10 running SQL Server 2012 Enterprise Edition with standard Microsoft recommended settings and best practices. HP ProLiant DL980G7 and DL585G7 servers were used, and the DL980G7 was tested both with and without the HP ioDrive2 Duo IO accelerator technology from Fusion-io. Testing occurred with 500,000 named users at 25,000, 75,000 and 125,000 concurrent user loads with real-world scenarios and data structures to simulate actual usage.
“The results of the tests indicate that Aras Innovator 10 performance scales consistently and nearly linearly with hardware,” said Anders Westby, Director of Cloud Services and Testing at Logic 20/20. “Testing validates that Aras Innovator 10 running on SQL Server 2012 Enterprise Edition can handle very high numbers of concurrent users when running on standard server configurations.”
Logic 20/20’s Performance Conclusions
• Aras Innovator 10 and SQL Server 2012 Enterprise Edition running on standard HP server configurations showed strong performance and excellent resource utilization across all tests.
• During testing average CPU utilization was consistently below 25 percent and total percentage of CPU utilization never exceeded 30 percent.
• The average response times were fast across the different concurrent user loads tested from 25,000 to 125,000.
• As expected in an online transaction processing (OLTP) workload like Aras Innovator 10, the greatest constraint was in the I/O subsystem’s ability to read and write to disk.
• The benchmark testing results validate that Aras Innovator 10 running on SQL Server 2012 Enterprise Edition scales nearly linearly with hardware upgrades and is architected for very high numbers of concurrent users.
• The performance of Aras Innovator 10 is not constrained by its architecture. The design puts the burden of work on the hardware, so it can be scaled-up and scaled-out with server hardware.
The Aras architecture supports scale-out on the file system and web servers with scale-up on the database by moving non-transactional data to the scale-out servers, allowing Aras Innovator 10 to handle very large levels of throughput by using frequent, short database transactions. Optimized exclusively for Microsoft SQL Server, Aras Innovator 10 is able to achieve this new level of PLM scalability because of Aras’s unique technology innovation, a model-based service oriented architecture (model-based SOA). The model-based SOA is designed for scalability, flexibility and extensibility while delivering consistent performance at scale whether running applications out-of-the-box or highly customized.
“We recognize that increasing product complexity, global design teams and outsourcing strategies are all forcing the need for greater application scalability,” said Peter Schroer, President of Aras. “Our architectural approach fundamentally rethinks the platform design in order to provide greater flexibility to customize applications while at the same time enabling a new level of scalability today and into the future.”
About Logic20/20, Inc.
Founded in 2005, Logic20/20 (www.logic2020.com) is a Seattle-based full-service business and technology consulting firm with more than 100 full-time employees and 20-40 offshore dedicated technology staff. From Fortune 100 companies to well-funded start-ups, the firm serves businesses and non-profits, offering its clients range of cutting-edge services. These services include: cloud computing, business intelligence, business process / strategy, systems integration, business and performance transformation, project/program management and go-to-market solutions. The team supporting Aras brought an average of 20+ years of deep technical and business experience through their industry exposure allowing for immediate impact.
About Aras
We offer the best Product Lifecycle Management (PLM) software for global businesses with complex products and processes. Advanced PLM platform technology makes Aras more scalable, flexible and secure for the world’s largest organizations, and a full set of applications provide complete functionality for companies of all sizes. Customers include GE, GETRAG, Hitachi, Honda, Motorola, TEVA Pharmaceuticals, Textron and XEROX. Aras is privately held with global headquarters in Andover, Mass. More at www.aras.com and Twitter @aras_plm
Product and service names mentioned herein are the trademarks of their respective owners.