Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Storage and Database checklist for Deep Security

    • Updated:
    • 16 Aug 2019
    • Product/Version:
    • Platform:
    • N/A N/A
Summary

This KB lists the things to check if you are experiencing large database disk space.

Details
Public

Below are the things to check for when experiencing large disk space used by the Deep Security Database:

  1. Check the largest table in the Deep Security Database.
    1. Open SQL Server Management Studio.
    2. Right-click on the Deep Security Database.
    3. Select Reports > Standard Reports > Disk Usage by Top Tables.

    Disk usage by Top Tables

  2. Check the pruning settings of the DSM Console and adjust the settings according to your preference. Do the following:
    1. Login to the DSM Console.
    2. Navigate to Administration > System settings > Storage Tab.

    DSM Console - Storage tab

  3. Check the SQL transaction logs. Refer to this KB article:
    Microsoft SQL transaction log has grown to an extremely large size
  4. Review the Log and event storage best practices.
 
Customer environments with large retention requirements should rely on SIEM or Syslog server for log storage. If logs were stored in SIEM or Syslog, lesser data would be stored in the Deep security Database, and thus requires lesser space.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1123520
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.