PTC Windchill Microsoft SQL Server vs. The Competition
As documented in the Microsoft SQL Server: Improved Performance for PTC Windchill whitepaper benchmark testing results showed that some Pro/ENGINEER and Windchill 9.1 operations performed up to 88 percent faster on SQL Server 2005 than on a competitor’s database, with an average performance advantage of approximately 10 percent.
| Test Performed | Time | SQL Server 2005 Performance Advantage (percent) |
| (Seconds) | ||
| Check out | 210 | -10% |
| Undo check out-all | 157 | -40% |
| Refresh | 9 | No change |
| Update | 80 | No change |
| Set state | 11 | -88% |
| Shares | 72 | -3% |
| Delete | 146 | -42% |
| Synchronize workspace | 53 | -31% |
| Save as | 225 | -19% |
| Checkout | 209 | -14% |
| Search | 4 | -50% |
| Combined results of all transactions | 3922 | -10% |
These results confirm that deploying Windchill 9.1 on Microsoft SQL Server 2005 provides users with a robust database platform, enhancing the performance of Windchill and delivering on users’ strategic PLM initiatives.
That's fine if you're installing PTC Windchill for the first time but what if you're on a competitor database platform? What if you're using Oracle right now?
PTC Windchill 9.1 has the capability to take advantage of the Microsoft SQL Server Migration Assistant (SSMA) tool (as described here on the PTC website: Oracle to SQL Migration Tools )
"With this migration capability, customers will be able to migrate to their database platform of choice without any data or functionality loss while decreasing their total cost of ownership." - PTC
For more information on the Microsoft SQL Server MIgration Assistant see the SSMA Team Blog and the download site for SSMA for Oracle v4.2
For PTC Windchill and Microsoft news, events, and further information, see the PTC and Microsoft Alliance page.
_____________________________________________________________________________________________