Go Up
You are here: AdministrationMonitor Netwrix Auditor HealthMonitor Health Status DashboardDatabase Statistics

Database Statistics

Databases may tend to run out of free space due to poor capacity provisioning or to retention settings not configured properly. Use the Database statistics widget to examine database size and adjust retention accordingly. The widget displays the name of default SQL Server instance hosting all Netwrix Auditor databases, the overall database capacity at the moment and its change over the last day (24 hours).

NOTE: Transaction logs size is not included in the calculations.

After you click View details, the following information will be displayed for the specified SQL Server instance:

The Database name column contains the list of Netwrix Auditor databases hosted by the specified instance of the SQL Server:

  • Special databases are created automatically on the default SQL Server instance to store alerts (Netwrix_AlertsDB database), activity records collected using Integration API (Netwrix_Auditor_API database) and internal event records (Netwrix_Auditor_EventLog database).
  • To store data from the data sources included in the monitoring plan, dedicated Audit databases are created and named by user (default name format is Netwrix_Auditor_<monitoring_plan_name>)

The following capacity metrics are displayed for each database:

  • State—Database state summary
  • Size—Current database size (logs are not included)
  • Activity records—Number of the activity records stored in the database at the moment

After you expand the database node, the detailed database properties will be shown:

These properties are as follows:

Property Value Description

Size limit

<size_limit>

-OR-

Unlimited

Shows database size limitations for SQL Server Express Edition.

State description

Capacity error

Database is running low on disk space.

-OR-

Size limit for SQL Server Express Edition will be reached soon (threshold is 500 MB, i.e. 5% of 10 GB limit remaining).

Failed to store data

Failed to store data to the database due to some issues.

Unavailable

Failed to connect to the database.

 

Upgrade in progress

Database is being upgraded.

Monitoring plans

<monitoring_plan>

 

All monitoring plans for which this database is a target.

NOTE: Usually it is recommended to configure a dedicated database for each plan.

You can use the Search field, or apply a filter to display the information you need. For example, in the Apply Filters dialog you can select the Show only plans with issues to display only the monitoring plans that require attention and corrective actions.

This information will help you to troubleshoot the product operation, detect and eliminate the root cause of the monitoring errors, providing for auditing continuity and compliance.

Go Up