Windchill 12 Performance Slow. Queues get high quicky and degrades performance

[NB_9728632]

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

[TDT]

Hi @NB_9728632,

Are you certain that the issue is related to the MS SQL database?

Have you tried running the SQL Server Performance Diagnostic script mentioned in below article?

https://www.ptc.com/en/support/article/CS123644?source=search

[NB_9728632]

Thanks for the suggestion. apparently, the slowness of Windchill was due to unorphaned objects and this was resolved in the meantime.

Nevertheless, we have created a PTC case for the build of notification queues to idenfity the rootcause.

Thanks again