has anybody else SQL Servers with SharePoint databases inventoried?

by Jan 13, 2017

If yes, could you please check if you have the same issue I have, with the following query:

SELECT
(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

Cheers,

Daniel