You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

The General tab of the Registered SQL Server Properties window allows you to change the description of this registered SQL Server instance, and view general properties such as audit settings.

Available actions

Update now

Allows you to send audit setting updates to the SQLcompliance Agent running on this SQL Server instance. This action is available when you update audit settings between heartbeats, and the Collection Server has not yet sent your changes to the SQLcompliance Agent.

To diagnose SQLcompliance Agent issues, check the SQLcompliance Agent status and review the SQLcompliance Agent properties.

Available fields

SQL Server

Provides the name of the selected SQL Server instance. If you are auditing a local instance, the SQL Server instance name is the name of the physical computer hosting this instance.

Version

Provides the version number of SQL Server running on this registered instance.

Description

Allows you to specify a description for this instance. The Management Console uses this description when you view SQL Server properties or report on audit data. Consider including information about the databases hosted on this instance, or the organization to which this instance belongs.

Status

Provides the current status of this instance. The current status indicates whether SQL Server is available and the SQLcompliance Agent Service and Collection Service are running. Use the Registered SQL Servers tab to see an overview of the status of all registered SQL Server instances.

Date created

Provides the date and time when this instance was registered. By default, auditing is enabled when the instance is registered with SQL Compliance Manager.

Last modified

Provides the date and time when audit settings were last modified on this instance.

Last heartbeat

Provides the date and time when the SQLcompliance Agent auditing this instance contacted the Collect Server. This communication is called a heartbeat. Typically, the SQLcompliance Agent receives audit setting updates during a heartbeat.

Events received

Provides the date and time when the Collection Server last received audited events (SQL trace files) from the SQLcompliance Agent.

Audit Settings

Provides the following information about the status of your audit settings:

      • Whether auditing is enabled on this instance
      • When the SQLcompliance Agent auditing this instance received the last audit setting updates
      • Whether the audit settings are current

If the audit settings are not current, you can send your updates to the SQLcompliance Agent by clicking Update now.

Event Database Information

Provides the following information about audited events collected on this instance:

      • Name of the database where audited events processed by the Collection Server are stored
      • Whether the Repository databases passed the last audit data integrity check
      • When the last audit data integrity check was performed

Time of Last Archive

Provides the date and time when audited events collected for this SQL Server instance were last archived.

Last Archive Results

Provides the results of the data integrity check. SQL Compliance Manager automatically performs a data integrity check each time you archive audited events from the Repository databases.


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

  • No labels