How Long Is the Database Audit Data Stored by Default?

Database audit can store online and archived audit data for at least 180 days.

On the Dashboard of database audit, you can select the database and audit period to view audit data.

However, the storage duration also depends on the disk capacity of the log database. To store your audit data long enough, you are advised to:

Choose a database audit edition suitable for your business.
- To audit a small volume of data, apply for the basic edition.
- To audit a large volume of data, apply for the professional or advanced edition.
For more information, see Table 1.
Back up audit logs.

**Table 1** Database audit editions
Version	Maximum Databases	System Resource	Performance
Basic	3	CPU: 4 vCPUs Memory: 16 GB Disk: 500 GB	Peak QPS: 3,000 queries/second Database load rate: 3.6 million statements/hour Stores 400 million online SQL statements. Stores 5 billion archived SQL statements.
Professional	6	CPU: 8 vCPUs Memory: 32 GB Disk: 1 TB	Peak QPS: 6,000 queries/second Database load rate: 7.2 million statements/hour Stores 600 million online SQL statements. Stores 10 billion archived SQL statements.

A database instance is uniquely defined by its database IP address and port.
The number of database instances equals the number of database ports. If a database IP address has N database ports, there are N database instances.

Example: A user has two database IP addresses, IP₁ and IP₂. IP₁ has a database port. IP₂ has three database ports. IP₁ and IP₂ have four database instances in total. To audit all of them, select professional edition DBSS, which supports a maximum of six database instances.
To change the edition of a DBSS instance, unsubscribe from it and apply for a new one.
Online SQL statements are counted based on the assumption that the capacity of an SQL statement is 1 KB.