Versions Compared

Old Version 6

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 7

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The System Status pane displays the overall status of your SQL Server environment.

Status

Indicates whether IDERA SQL Compliance Manager encountered any issues while auditing your SQL Server environment.

...

Status TypePossible Causes
Alert/Error
  • The Repository is installed on a SQL Server 2000 instance but a SQLcompliance Agent is deployed to a SQL Server 2005 or later instance. For example, to audit activity on instances running SQL Server 2005, install a second Repository on a SQL Server 2005 instance.
  • A version 1.1 SQLcompliance Agent is deployed to a SQL Server 2005 or later instance. Version 1.1 does not support auditing SQL Server 2005 instances. To continuing auditing SQL Server 2005 instances, upgrade the agents to the latest version.
  • The SQLcompliance Agent missed every heartbeat over the last 24 hours. This issue occurs when the SQLcompliance Agent service is stopped, the Collection Server is offline, the computer hosting the agent is offline, or network availability is lost.
  • The SQLcompliance Agent service is no longer running. The SQLcompliance Agent service is stopped by a SQL Server login or a third-party application.
  • A system alert is triggered. System alerts notify you when the health of your SQL Compliance Manager deployment may be compromised. For more information, see the Activity Log tab.
OKSQL Compliance Manager is performing as expected.
Warning
  • No SQL Server instances are registered with SQL Compliance Manager. SQL CM Compliance Manager cannot begin auditing your environment until instances are registered, SQLcompliance Agents are deployed, and audit settings are configured.
  • The SQLcompliance Agent is not yet deployed to an instance that is registered with SQL Compliance Manager. SQL CM Compliance Manager cannot audit this instance until an agent is deployed and audit settings are configured.
  • A deployed SQLcompliance Agent has not yet contacted SQL Compliance Manager. This issue occurs when the SQLcompliance Agent service is stopped, the computer hosting the agent is offline, or network availability is lost.
  • A deployed SQLcompliance Agent missed two sequential heart beats. This issue occurs when the SQLcompliance Agent service is stopped, the computer hosting the agent is offline, or network availability is lost.

...

Displays the number of SQL Server instances that are registered with SQL CMCompliance Manager.

Audited SQL Servers

Displays the number of instances currently audited. This number does not include instances where auditing is not yet configured or is disabled.

...

Displays the number of databases currently audited. These databases are hosted by SQL Server instances that are registered with SQL CMCompliance Manager. This number does not include databases where auditing is not yet configured or is disabled.

...

Each tab of the Enterprise Activity Report Card provides an auditing status for the corresponding event category. Use this status to help determine whether you are effectively auditing events in your environment.

You can also use auditing thresholds to display critical issues or warnings should a particular activity, such as privileged user events, be higher than expected. These thresholds can notify you about issues related to increased activity levels, such as a security breach, that may be occurring on this instance. Use thresholds to supplement the alert rules you have configured for your environment.

...

The Enterprise Activity Report Card tabs (Report Card) chart recent activity for each of the common audit event categories and provide the status of each registered SQL Server instance. This activity and status is calculated for the selected time span from the processed audit events stored in the Repository event databases.

Use the Report Card to track the rate of activity in specific event categories and identify when exceptional activity occurs. Auditing thresholds can also help you track and identify activity that could reflect a SQL Server performance or security issue.

...

Allows you to change the number of days (time span) for which the Summary tab displays status, alerts, and activity. By default, this tab displays data for the last seven days.

 

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >
Idera IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal