We switched to SQL in Oct 2018 at the same time we upgraded from 10.1 to 11.0. Caused us quite a bit of grief.
After we upgraded, there were random slowdowns. Some users had it. Others did not. Some that didn't have started having it at some point. I don't know what the percentage of users that were affected were though.
When someone would make a change in Creo and save it to their workspace, it sometimes took forever. Sometimes it took so long that the user forced closed Creo. On the bright side, almost every time they forced close, the action actually completed.
Sometimes when a user would just edit a parameter in their workspace through the embedded browser, it would take a long time.
Any of the tasks (all of them were interactions between Creo and PDMLink) could take anywhere for a minute or two to as much as 25 minutes or even longer.
We submitted a ticket with PTC about it and that also took forever to resolve.I opened a call April 2019 and finally seemed to have sorted it out early this year.
They had me set up logging on a few users that were known to have it. The problem is that it didn't happen all the time.
It turns out that there is something in the database that wasn't updating the statistics.
One set of logs we sent in the tech said this:
Every row returned here has the no recompute option, which means SQL Server will not automatically update those stats.
He also said PTC does not set this option.
https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/update-statistics-task-maintenance-plan?view=sql-server-ver15&data=02%7C01%7Ccs_sfdc_dev@ptc.com%7Cbc1821b5373246ad41cf08d78aecf837%7Cb9921086ff774d0d828acb3381f678e2%7C0%7C0%7C637130622710205396&sdata=tebljRTy1wv2i4WeMHgidA...
It was a nightmare to find but they were persistent and really, really dug deep into the logs.
Other than this issue, it's been fine.
