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?
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.
blog: Increase the Size of a Database using sql server studio & transactional sql