Teamcenter 2007 Validated to Easily Support 5,000 Concurrent Users with SQL Server 2008
Siemens PLM Software engineers recently visited the Microsoft Engineering Excellence Center Laboratory in Redmond, Washington to conduct heavy-load tests of Teamcenter running on SQL Server 2008 Enterprise Edition (64-bit) and the Windows Server 2008 for 64-Bit Systems operating system, running on Quad-Core Intel Xeon processors.
“Certifying SQL Server 2008 was important to us because more and more of our customers want to deploy our PLM solution using the Microsoft Application Platform,” says Christian Kelley, Vice President, Partner and Platform Marketing, Siemens PLM Software. “Our testing demonstrates that SQL Server 2008 provides Enterprise-class performance—with a low total cost of ownership.”
Siemens engineers found that Teamcenter upgraded seamlessly to SQL Server 2008 and provided enhanced performance compared to SQL Server 2005. David Mitchell, Chief Technical Officer, Teamcenter, Siemens PLM Software recounts, “Using desktops logged in through a load balancer to a set of Web servers, we used load cannons to simulate 5,000 concurrent users. We used a 50/50 split between reads and writes, while in normal operations you’d expect to see only about 10 percent writes.”
The results were impressive, demonstrating:
Faster Response Rate. Testing found a 20 percent improvement over SQL Server 2005 in average database response times.
High Concurrency for Scalability. The Siemens team found that with SQL Server 2008, Teamcenter “easily scales” to 5,000 concurrent users. Even at peak loads the testing found only a 20.75 percent CPU utilization. “The ability to support 5,000 concurrent users translates into the ability to easily serve a 50,000-seat deployment,” says Mitchell. “This is because organizations typically see only 10 percent of potential users concurrently using the system.”
CPU and RAM Savings. SQL Server 2008 showed a 10 percent reduction in CPU utilization during peak usage and a 5 percent reduction in RAM usage compared to SQL Server 2005.
Compression. Testing found that the Data Compression feature of SQL Server 2008 provided an average of 50 percent compression —while only increasing CPU overhead by 1 to 2 percent. “Our customers will benefit from compression in SQL Server 2008,” says Mitchell. “With SQL Server 2008 we’re excited about compression and how it can be used to reduce disk space needs.”
Low TCO. The impressive test results were accomplished using industry-standard hardware powered by Intel® Xeon® Quad-Core processors. The SQL Server processor licensing model only charges per processor, regardless of the number of cores. Mitchell notes: The ability to use readily available hardware and the Microsoft Application Platform provides a low TCO for deploying our PLM software.”
Microsoft SQL Server 2008
SQL Server 2008 is a secure, reliable and scalable platform for business critical applications with transparent encryption, comprehensive auditing and enhanced mirroring, while reducing the time and cost of managing data with enterprise wide policies. SQL Server simplifies development of data driven applications with integration of Visual Studio and .NET Framework, support for any type of data, and consistent storage from the device to the data center. SQL Server delivers the right information to all users with advanced visualizations, powerful reports and integrated analysis.
For more information about SQL Server 2008, go to: www.microsoft.com/sqlserver
Learn more about Teamcenter and SQL 2008 at UGS Connection 2008 in June!
This article is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.
