Page History
The IDERA SQL Compliance Manager Instance Summary tab displays the status of audit activity for a particular SQL Server instance in your environment. Use the statistics and graphs on this tab to quickly and easily identify server-level issues so you can continue to ensure the correct level of compliance.
Understanding Server Status
...
Provides the most recent date and time that the SQLcompliance SQL Compliance Manager Agent deployed for this instance contacted the Collection Server.
...
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 this instance.
| Status Type | Indication | Meaning |
|---|---|---|
| Audited without thresholds | gray check | This event category is audited on instances in your environment, but auditing thresholds are not set for this event category. Consider setting audit thresholds so you can track peaks in activity and identify any suspicious events. |
| Critical | red icon | The event activity during the selected time span is higher than the defined critical threshold. To see more information about this activity, navigate to the Audit Events tab and search for events in the event category that is flagged. You can view the detailed properties of an event by double-clicking the listed event. |
| OK | green check | This event category is audited on instances in your environment and auditing thresholds are set for this event category. |
| Not audited | red icon | This event category is not audited on instances in your environment even though auditing thresholds are set for this event category. To track this activity, change your audit settings to include the corresponding event category. To ignore this activity, disable the auditing threshold set for this event category. |
| Not audited and no thresholds set | gray circle | This event category is not audited on any instances in your environment. Auditing thresholds are not set for this event category. Review whether you need to audit and track this activity on any of your SQL Server instance. |
| Warning | yellow icon | The event activity during the selected time span is higher than the defined warning threshold. To see more information about this activity, navigate to the Audit Events tab and search for events in the event category that is flagged. You can view the detailed properties of an event by double-clicking the listed event. |
Understanding the Server Activity Report Card tabs
...
Configure Alerting
Opens the Alert Rules tab under Administration, allowing you to configure alerting to track specific activity on this instance or other SQL Server instances across your environment.
...
Allows you to unregister the selected SQL Server instance. When you remove a SQL Server instance, SQL Compliance Manager disables all auditing at the server and database levels on the SQL Server instance. If the selected instance is the last instance to be audited on this SQL Server, SQL Compliance Manager also uninstalls the SQLcompliance SQL Compliance Manager Agent. If you manually deployed the SQLcompliance SQL Compliance Manager Agent, you you must manually uninstall it from the SQL Server computer.
| Note | ||||||
|---|---|---|---|---|---|---|
If there are any backlogged audit trace files that you need to process for the instance you are considering to decommission, make sure to disable auditing and decommissioning your server only after processing these backlogged audit trace files. For additional information on how to process backlogged trace files, please contact
|
Add Audited Databases
Starts the New Audited Database wizard, allowing you to enable auditing on additional databases hosted by this SQL Server instance. For more information, see Add Audited Databases.
Disable Auditing
Allows you to disable auditing on the selected SQL Server instance. When you disable auditing, the SQLcompliance SQL Compliance Manager Agent stops collecting new event data, and stops the corresponding SQL trace. You can continue to view and report on previously audited events or archived events. For more information. see Disable auditing on a SQL Server.
To re-enable auditing, right-click the instance from the Explore Activity tree, and then click Enable Auditing on the context menu.
...
Allows you to change the audit settings for the selected SQL Server instance. For more information, see Registered SQL Server Properties.
Apply Regulation Guideline
Allows you to select one or more regulations to apply to all of the audited databases within this SQL Server instance. If you want to apply regulation guidelines only to specific databases, use the Apply Regulation Guideline feature from the Explore Activity - Database Summary tab. This option is unavailable if you have no databases selected for audit. For more information, see Apply Regulation Guideline.
Privileged Users
Allows you to change how privileged user activity is audited on the selected SQL Server instance. For more information, see Privileged User Auditing tab.
Import
Allows you to import audit settings previously exported from another SQL Server instance. Using the Import Audit Settings wizard, you can specify whether you want to import settings at the server or database level.
...
Collect Audit Data
Allows you to force the SQLcompliance SQL Compliance Manager Agent to send trace files to the Collection Server for processing. Typically, the SQLcompliance SQL Compliance Manager Agent sends trace files to the Collection Server at the specified collection interval. By default, a trace file collection occurs every two minutes.
...
Allows you to view or change the properties, such as the heartbeat interval and the collection interval, of the SQLcompliance SQL Compliance Manager Agent deployed to the selected SQL Server instance. For more information, see SQL Compliance Manager Agent Properties.
Span
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 7 days.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |
...
...