Skip to Content
avatar image
Former Member

DB02/DBACOCKPIT Free Space monitoring clarification

Hi SAP Experts,

This is on SAP ECC 6 on MS SQL Server 2008 and Win OS.

I need your help to clarify that free space % shown in DB02 > Space > Overview > Overview tab and in ‘Data’ – Free [MB] shown 1.93% free, but if I check my OS I have enough space but not this low % shown here in this field.

OS Free Space – %

We have 5 database files and I’ve checked DB02 > Space > Overview > Files tab > ‘Free Pct’ column values are all showing almost same less than 2% (1.88%, 1.90%, 1.88%...) avg of these values shown in Overview tab > Free [MB] ?

Can anybody please help to clear this confusion around this area to understand more about how does it calculate that Free % and what needs to done?


Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 31, 2014 at 04:07 PM

    its very simple

    1) you DB is 1.60 TB and out of this 1.57 TB is used and 30 GB is free in the the database.

    2) At OS level you got freespace out of the space used by the datafile size.

    3) The datafile in RED has no or less space hence you can extend the datafile or add new or extend automatically if enabled.

    The thumb rule is you must have some freespace in your datafile say around 5-10GB each but may be more but depends on your requirement.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2014 at 04:56 PM

    Hello Giridhar,

    We recommend at least 10-15% of free space during normal system operation. This free space check should be performed regularly (e.g. once per month) by your DBA.

    In Juergen's whitepaper we can see:

    SAP with Microsoft SQL Server 2008 and SQL Server 2005: Best Practices for High Availability, Maximum Performance, and S…

    Setting autogrowth.

    On SQL Server 2005 and SQL Server 2008, avoid situations where automatic growth is executed by manually increasing the size of the data files proportionally in advance. Although the data files can be manually manipulated proactively, leave autogrowth on as a safety measure in case of an emergency such as when the database runs full.

    Manually increase your datafiles when necessary.

    Regards,

    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Eduardo,

      This is very useful and I was looking for this massive information.

      Its a wonderful document.

      Regards,

      GK

  • Jan 31, 2014 at 05:50 PM

    Hi Giridhar

    In addition you can enable the Database page compression feature since you are using MS Sql 2008 as per the SAP notes

    1488135: Database compression for SQL Server

    1459005: Enabling index compression for SQL Server

    Regards

    Sriram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2014 at 05:08 AM

    Hi,

    Seems you got confused with OS and Database free space.

    Free space of database @ DB02 is showing the free space available in your database.

    Free space of OS @ file system layout is showing the available space which your data files can use.

    In your case, 1607000MB is your actual database size where free space is just 30937MB (Your database is running with low free space!)

    But you have free space available at your file systems where your data files can grown.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded