If yes, could you please check if you have the same issue I have, with the following query:
(SELECT COUNT(*) FROM applications) AS total_rows,
(SELECT COUNT(*) FROM applications WHERE name LIKE '[TSS%') AS sharepoint_rows
I'm having 5.98 Mio rows in total with 5.96 Mio rows from sharepoint connections alone.
Apparently sharepoint creates lots of connections with unique application names like
[TSS<guid>].Net SqlClient Data Provider
This seems to slow down my Inventory Manager 2.3 installation massively
Powered by IDERA