Note The default settings that are used in the Troubleshoot-DatabaseSpace.ps1 script are defined in the StoreTSConstants.ps1 script that is located in the following path:
Method 1Create an SCOM override to disable the database space troubleshooter that checks for free disk space. To do this, refer to the Workaround section in the following Microsoft website:
Method 2Make one of the following changes in the StoreTSConstants.ps1 script:
- Set the PercentEdbFreeSpaceDefaultThreshold value to 16. This enables the database space troubleshooter to retrieve the quarantine action when there is less than 20 percent of free disk space on the database or log volume. The value is as follows:Note The PercentEdbFreeSpaceDefaultThreshold value can be greater than or equal to the PercentEdbFreeSpaceAlertThreshold value that is specified in the StoreTSConstants.ps1 script as follows:
# The percentage of disk space for the EDB file at which we should start quarantining users.
$PercentEdbFreeSpaceDefaultThreshold = 16
# The percentage of disk space for the EDB file at which we are at alert levels.
$PercentEdbFreeSpaceAlertThreshold = 16
- Set the HourDefaultThreshold value to 1 so that the database space troubleshooter will retrieve the quarantine action. The quarantine action is retrieved when the JET Log Bytes Generated/hour performance counter indicates that the log generation consumes the remaining free disk space of the log or database volume within one hour. The value is as follows:
#The number of hours we can wait before running out of space.
$HourDefaultThreshold = 1