Scalability and Performance of Dassault Systèmes ENOVIA V6 Running on SQL Server 2008 R2: Impressive Benchmark Testing Results

Enterprises have come to rely on increasingly robust product lifecycle management (PLM) systems to streamline their business processes and to keep costs down. PLM systems, in turn, rely on high-performance databases. Dassault Systèmes ENOVIA V6 is a standards-based, scalable PLM system that can support end-to-end product development processes for all companies, from small and mid-sized…

0

Dassault: Tesla Motors builds for an electric future on SQL Server

 Electric car manufacturer Tesla Motors is upgrading to Dassault Systèmes’ V6 PLM solution running on SQL Server. Tesla has not only been pushing the cutting edge of electric car design, it has for the last four years piloted numerous Dassault Systèmes software and partner solutions. This is speeding the development of the upcoming Model S sedan.  (I would…

0

Dassault: TÜV Rheinland resolving the conflict between the environment and technology

TÜV Rheinland Group  (TÜV) is the world’s leader in comprehensive, global independent product testing and assessment of environmental impact. TÜV has selected ENOVIA V6 PLM solutions running on SQL Server to launch an integrated compliance portal for customers. What is a compliance portal? If you develop products for worldwide distribution, you must insure that your product (and…

0

Migration: Pentair experience migrating to Enovia V6R2009x on SQL Server from Oracle

Pentair has more than 13,000 employees in more than 20 countires produce a wide variety of products. More than 1500 employees regularly used their PLM systems which was running on Oracle.  Pentair is typical of many businesses: if a system is working, don’t upgrade it!  Time marches on, they found that: Dassault Matrix 10.6.2 was no longer unsupported….

0

Tuning Enovia Smarteam – End Solution

[Prior Post in Series] The result of the tuning exercise is TSQL shown below. The items included are those suggested by Database Engine Tuning Advisor (DTA) evaluated as being prime candidates by the author. The performance improvement expected is at least 15% and may be considerably more. A trace log of your operational SmarTeam should…

0

Tuning Enovia SmarTeam -- Statistics

[Prior Post in Series] [Next Post in Series] Adding statistics helps SQL Server to determine which tables to scan first when there are joins. To understand statistics better, see Statistics Used by the Query Optimizer in Microsoft SQL Server 2005. Statistics are typically added after indexes because if there is an index on the column…

0

Migration: The value gained moving from Oracle to SQL Server 2008R2

[DB2 Migration Value]  [Sybase Migration Value] In the early 1980’s I was an Oracle Developer on mainframes and on MS-DOS using Oracle 5.1 on MS-DOS (distributed on some 20+ diskettes — I still have them). It was an interesting time because PC products like dBase II were power-user friendly but did not scale. Oracle scaled, but was…

0

Migration: The value gained moving from DB2 to SQL Server 2008R2

[Oracle Migration Value]   [Sybase Migration Value] Two decades ago, I made my living as a DB2 developer working for GTENW (now Verizon). In this year’s spring-cleaning, I came across my old DB2 certificates; perhaps it is time to do a spring-cleaning of perceptions about DB2 and SQL Server. As a developer, I have become hopelessly biased for…

0

Tuning Enovia SmarTeam - Indexes - Conclusion

[Prior Post in Series] [Next Post in Series] In this part, I will deal with the fact that many remaining tables do not have clustered indexes on them. In my humble opinion, ANY reasonable order of the disk will perform better than a random order, so putting a clustered index on every table is a…

0

Tuning Enovia SmarTeam – Indexes – Part 2

[Prior Post in Series]  [Next Post in Series] In this post I continue on with index analysis from my prior post. First, I will intentionally walk you into a dead end to illustrate when things go wrong and what you should do. Second I will take the right path and show the results. I took…

0