Versions Compared

Old Version 13

changes.mady.by.user Unknown User (6092af18a56f2f006f392eb0)

Saved on

compared with

New Version Current

changes.mady.by.user Nicolas Rios

Saved on

Key

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

The Audited SQL Servers Summary tab (Management Console) displays the status of audit activity across your SQL Server environment. Use the statistics and graphs on this tab to quickly and easily identify issues so you can continue to ensure the correct level of compliance.

Image Added

Understanding System Status

...

Clicking the status link opens the more detailed Registered SQL Servers tab under Administration. Use this tab to view the status of audited databases on this instance, validate audit settings, and check the SQLcompliance SQL Compliance Manager Agent status.
 

Status TypePossible Causes
Alert/Error
  • The Repository is installed on a SQL Server 2005 instance but a SQLcompliance SQL Compliance Manager Agent is deployed to a SQL Server 2012 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 SQL Compliance Manager 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 SQL Compliance Manager Agent missed every heartbeat over the last 24 hours. This issue occurs when the SQLcompliance SQL Compliance Manager Agent service is stopped, the Collection Server is offline, the computer hosting the agent is offline, or network availability is lost.
  • The SQLcompliance SQL Compliance Manager Agent service is no longer running. The SQLcompliance SQL Compliance Manager 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 Compliance Manager cannot begin auditing your environment until instances are registered, SQLcompliance SQL Compliance Manager Agents are deployed, and audit settings are configured.
  • The SQLcompliance SQL Compliance Manager Agent is not yet deployed to an instance that is registered with SQL Compliance Manager. SQL Compliance Manager cannot audit this instance until an agent is deployed and audit settings are configured.
  • A deployed SQLcompliance SQL Compliance Manager Agent has not yet contacted SQL Compliance Manager. This issue occurs when the SQLcompliance SQL Compliance Manager Agent service is stopped, the computer hosting the agent is offline, or network availability is lost.
  • A deployed SQLcompliance SQL Compliance Manager Agent missed two sequential heart beats. This issue occurs when the SQLcompliance SQL Compliance Manager Agent service is stopped, the computer hosting the agent is offline, or network availability is lost.

...

The Recent Alerts pane displays the number of alerts that are generated for each alert category in the selected time span. If you see an unexpected number of alerts, consider reviewing the current alert messages and then modifying your alert rules to better fit your compliance and auditing needs.

...

Register SQL Server

Starts the New Registered SQL Server wizard, allowing you to enable and configure auditing on another SQL Server instance.

Monitor

Opens the Change Log tab under Administration, allowing you to monitor what types of changes are made to audit settings across your environment.

Configure Access

Opens the SQL Logins tab under Administration, allowing you to control who has access to view and report on audit data or change configuration settings.

Self-Audit

Allows you to perform an integrity check on the audit data currently stored in Repository.

Configure Alerting

Opens the Alert Rules tab under Administration, allowing you to configure alerting to track specific activity on SQL Server instances across your environment.

...

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.



Scroll pdf ignore
Newtabfooter
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 | 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse