The Collection Server Properties window allows you to review the basic properties and status of the Collection Server. You can review the following items:

  • Whether the Collection Server is available (up and running)
  • Official status
  • Name of the computer that hosts the Collection Server
  • Port the Collection Server is using to communicate with the Management Console and the SQL Compliance Manager Agent
  • Version of Collection Server software (should be the same as the IDERA SQL Compliance Manager build and version number)
  • Date and time the last heartbeat was received from the SQL Compliance Manager Agent
  • Logging levels set at the Collection Server and the SQL Compliance Manager Agent
  • Collection Server heartbeat interval
  • Location of trace file directory

Available actions

Change Collection Server log level

Allows you to select the logging level at which the Collection Server writes events to the Application log on the host computer.

Change heartbeat interval

Allows you to specify the interval (in minutes) at which the Collection Service processes any status alerts associated with the Collection Server. These alerts are written to the Repository. It also manages any SQL CM maintenance activities, such as re-indexing the Repository databases. By default, the heartbeat interval is five minutes.

Start Service

Allows you to restart the Collection Service from the Management Console. Use this feature if the Collection Service has stopped running on the Collection Server computer and requires a manual restart.

Stop Service

Allows you to stop the Collection Service from the Management Console. You can use this feature to stop the Collection Service currently running on the Collection Server computer.

Refresh Status

Allows you to refresh the status fields with the most recent data from the Collection Server.


SQL Compliance Manager audits all activity on your server. Learn more > >

IDERA Website | Products Buy Support Community About Us | Resources Legal

  • No labels