none
SCCM Alert: Critical low free space alert for database on site: CCM RRS feed

  • Question

  • Hi all 

    This alert was sent from SCCM every night

    SCCM has detected an alert: Critical low free space alert for database on site: CCM. Database files have free disk space critical alert for site CCM. Current database files free disk space is 4 GB which is less than the critical threshold of 5 GB. 
    
    Alert type: Database free space critical
    
    Severity: Critical
    
    Active time (UTC): 6/17/2019 12:01 AM
    
    Condition:  Generate a critical alert if the free space on disk that contains the database file is less than 5 GB.
    
    Comment:

    there is over 20 gb free space on the disk of database and the database configured with unlimited size.

    what could be the reason of the alert ?

    thanks

    Monday, June 17, 2019 9:17 AM

Answers

  • Hello,
     
    Yes, it should be the reason.
     
    It is easy to test. Just set the criteria of the alert a litter lower and higher than the free space. Then refresh the alert status and check the results.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by RASH MAAR Tuesday, June 18, 2019 8:51 AM
    Tuesday, June 18, 2019 8:47 AM

All replies

  • Hello RASH MARR,
     
    The free space data on which the alert is based is collect from Hardware Inventory. Use the following script to see the data stored in WMI and check if it meets the criteria of the alert and if it matches the actual space on the SQL server.
     
    get-wmiobject -Namespace root\sms\site_<sitecode> -class sms_G_system_logical_disk -Filter "systemname='SQLSERVERNAME'" | select deviceid,freespace
     
    We also could check it in Resource Explorer > Hardware > Logical Disk.
     
    If the results do not match the actual situation on the SQL, we need to run a hardware inventory on the SQL to refresh the data on the site server.
     
    As a workaround, we could set the criteria of the alert based on the results to cancel the active alert.
     
    Hope my answer could help you and look forward to your feedback.
     
    Best Regards,
    Ray 

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, June 17, 2019 10:41 AM
  • Hi Ray

    thank you for answer

    there is a drive for SQL logs with 5 gb free space now. Could this be the problem?

    thanls

    Tuesday, June 18, 2019 8:35 AM
  • Hello,
     
    Yes, it should be the reason.
     
    It is easy to test. Just set the criteria of the alert a litter lower and higher than the free space. Then refresh the alert status and check the results.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by RASH MAAR Tuesday, June 18, 2019 8:51 AM
    Tuesday, June 18, 2019 8:47 AM