Windchill 12 Performance Slow. Queues get high quicky and degrades performance
Since Migration from Oracle to MS SQL Database, windchill performance is unstable.
Performance degrades over time after Restart.
Only Restart helps to make it better for a short time after which it degrades again.
The Workflows become very slow. Tasks which shall be triggered in less than a minute takes more than 10-20 minutes, sometimes more.
Sync robots are extremely delayed as well.
We try clearing the blocking sessions in DB, but not much help

