Pre-requisites for Monitoring SSIS

As stated earlier, in addition to using the Windows Perfmon utility, the eG monitor runs queries on the SSIS database to pull metrics. To enable the eG agent to run these queries, the following pre-requisites should be fulfilled:

  • Configure the eG agent with the correct version of SSIS being monitored;
  • Configure the eG agent with the database port number – i.e., the port number of the SQL instance in which the SSISDB (i.e., the SSIS database) is available - so that the agent can connect to the database;
  • Configure the eG agent with the credentials of a user with the privileges to run queries on the SSISDB

Click on the links below to know how to fulfill each of these pre-requisites.

Configuring the eG Agent with the SSIS Version

Configuring the eG Agent with the Database Port Number

Configuring the eG Agent with Query Execution Permissions