Each EDR site must establish procedures to monitor and manage sufficient storage capacity in order to reduce the likelihood of such capacity being exceeded and resulting in the potential loss or reduction of data. For information about establishing procedures to monitor and manage storage capacity, refer to the following:
Storage reports - https://docs.microsoft.com/en-us/windows-server/storage/fsrm/generate-reports-on-demand
File Server Resource Manager - https://docs.microsoft.com/en-us/windows-server/storage/fsrm/fsrm-overview
Also, it is necessary to implement configuration alerts for exceeding storage capacity according to IHS policy. For information about configuring notifications and email alerts, refer to the following:
Reporting Services - Create data-driven subscriptions to your reports:
Data-driven subscriptions:
MS SQL Server 2019 - https://docs.microsoft.com/en-us/sql/reporting-services/create-a-data-driven-subscription-ssrs-tutorial?view=sql-server-2019
Email delivery:
MS SQL Server 2019 - https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/e-mail-settings-reporting-services-native-mode-configuration-manager?view=sql-server-2019
Email alerts - https://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications
Notes:
To help reduce database size, you may want to retain database backups with all audit records and purge the audit records before a certain point in time in your live database at regular intervals. For help purging audit records, contact the Dentrix Enterprise Support Department.
In addition to the tools provided by Microsoft SQL Server, there are various third-party tools that you can use to monitor storage capacity and receive notifications.