Scalable, Reliable, Secure, and Cost-Effective (Dassault Systems ENOVIA V6 on SQL Server 2008)

  • Article

Engineers from Dassault Systèmes and Microsoft ran benchmarking tests to measure the performance and scalability for ENOVIA V6 with SQL Server 2008.  The tests were designed to reflect real-world usage patterns of ENOVIA V6 customers. The benchmarking tests simulated up to 5,000 collaborative users (a number typical for a large enterprise environment).

The transaction times for typical PLM tasks, such as running searches and editing data, were measured.

 

SQL Server 2008 maintained a consistent average transaction time as the number of users increased, confirming that SQL Server 2008 is a strong choice for the database platform for ENOVIA V6.  

As described in Buying a Vehicle vs. Buying a Database Platform when using the Enterprise Edition of SQL Server 2008 (unlike some competitor platforms) reliability is not an "added option" as the following High Availability features are included:

  • Database Mirroring
  • Failover Clustering
  • Replication
  • Log Shipping

As described in Why Pay More For Less Microsoft SQL Server is the most cost effective Enterprise level database platform and offers:

  • Lower cost with advanced features included in the base license
  • Lower cost with better multicore licensing
  • Lower cost with better user licensing
  • Lower cost with better standby server licensing

Check out the Performance and Scalability of ENOVIA V6 on SQL Server 2008 Benchmark Report for more information.