SR130569 - Advice on portal performance
I've seen this issue logged:
https://support.cireson.com/Problem/Edit/PR130511/
We have a few reports of poor performance and I have taken a look at our environment and collected these stats:
FROM [Service Management].[dbo].[WorkItem] - 354,238 total, 217,711 Closed
Is the recommendation to truncate the tables and resync the portal, with the portal now using the archiver?