This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 31%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Hi All,
We got an alert in SCOM 2019 stating that "MSSQL on Windows: Database ROWS Data is Out of Space" from the SCOM Database. Kindly advise me how I can clear the alert.
Thanks in Advance
Regards,
Aswin
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
Hi,
Based as I know, the DBFreeSpacePercent can be calculated by the following Algorithmic formula:
DBFreeSpacePercent=DBFreeSpaceMB/(DBFreeSpaceMB+DBSizeMB).
In our environment, DBFreeSpacePercent=1061733.5/(1061733.5+5057321)=17.35%
For the alert "MSSQL on Windows: Database ROWS Out of Space", we can increase the database size on SQL database to see if it can be fixed.