SQLAdmin Collector

The SQLAdmin Collector node has the collection of SQL Server information in the domain. These collections has Collector scheduels that are with the local SQLAdmin Collector. The SQLAdmin Collector collects SQL Server information on all components in the technology stack.

• Database Engine
• Integration Services
• Analysis Services
• Master Data Services
• Data Quality Services
• Reporting Services

With the split of SQL Server tools from the common installation set the SQLAdmin Inventory will also have information about tools and other external components like

• Microsoft SQL Server Management Studio
• Microsoft SQL Server ODBC driver
• Microsoft SQL Server JDBC driver
• Microsoft SQL Server Native Client

The collector will also import data from other external sources to contribute to a more complete picture of the SQL Server infrastructure.

The current prototype of the SQLAdmin Collector is scripted in PowerShell, but to comply with the Fast principle in the Service Strategy the implementation should be in a more predictable way like C++.