Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!

Tags:
Former Member
Former Member replied

Thanks Sunil,

Your input is very helpful.

I was trying to understand the consolidation of this behavior.

However below are some more discussion chains and Notes referring here so that this may help somebody in future.

Detailed Note: 363018 - File management for SQL Server

http://scn.sap.com/thread/1846581

blog: Increase the Size of a Database using sql server studio & transactional sql

Regards,

GK

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question