Skip to Content
avatar image
Former Member

SAP SQL : "No Free space in file"

Hi,

I am new to SQL and I have the issue in ST04 that my database is having the error "no free space in file" for OPEDATA1, OPEDATA2, and OPEDATA3.

Yet I have 40Gb free on my server and the files are set to "autogrowth" and "no limit" as I can see in ST04. Does that mean that it will grow from itself once it's trully full on all file (OPEDATA1, OPEDATA2....) ?

Here's the SQL view

Here's the SAP view

what should I do (IF I have something to do at all) ?

Regards,

Dimitri

db2.png (17.3 kB)
db1.png (94.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 09, 2017 at 04:34 PM

    Hi Dimitri,

    You shouldn't rely on autogrowth on your database. You should manually increase the size of data files, but you should leave autogrowth enabled to avoid data full situations. For the size of your data files, the next growth of 60MB on each file is subpar value. You should consider leaving something like 500mb-1GB. Every time the data file has to grow, it is an expensive operation. If you are growing 60mb every time this will be painfully slow. Furthermore, you should have all data files on the same size and the very same free space. This is ensured when you enable the traceflag -1117.

    Please read carefully the SAP Note 1238993.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 15, 2017 at 03:08 PM

    Hi - look at your G:\OPEDATA1 and G:\OPEDATA2 paths, if I have to guess, those are probably mount points, i.e., another volume mounted to a folder. Those are the ones probably not having enough free space for the database files to grow. Extend those mount points and that should address your issue.

    Add comment
    10|10000 characters needed characters exceeded