How to check disk space

[Beeswing]

Hi,

I've had a dig around, but I can't seem to find it.  Anyone know where I can see the disk space utilisation?

We've set up a number of new apps in our environment recently, and I'm concerned we might be running out of space.

[NicolasArgente]

Hi Beeswing,
I do not think you can find this directly and the reason behind is that the space increases automatically on Azure elastic pools. I think you could have a look under System > Environement>OS DB Server and do a filter on ElasticPoolStorageMB. That is the closest thing i can help with.

Please give a kudo if it helps 🙂

[NicoleBruno]

Hello! 
We're on the cloud and this is how we review our application space: 

Bottom right corner of the dashboard lists the GB used by application in the environment where you've originated the dashboard (ie. DEV or PROD environments). Hope that's useful! 

[Beeswing]

Hi..  I know it's been a while, but hoping you could provide some more info.  
I don't have the Database Statistics Dashboard that you mentioned, and I can't find it on the market place.  Is this one you created yourself?  Or is it indeed from something in the market place?

Thanks

[NicoleBruno]

Hi, 

It's not a marketplace tool. Can you try searching your dashboards for "storage chart" and see if it's there?

I assume it's out of the box OS as we didn't create it. If you can't find it, I'd suggest contacting your OS customer success/account manager or maybe submitting a OS support ticket for more direction. 

[Beeswing]

I tried searching, but it's not there.  Maybe it's because we're a few versions back.  We're still on 6.2.

[NicoleBruno]

Hi, 

Maybe. I just searched my email and it looks like it was provided as an XML file from OS cloud support team in July 2020. 

Send me a message with your email and I can forward it to you if you'd like. 

[SandeepSingh]

Hi Nicole,

How you doin? Was going through a need of finding DB size and came through your response. Can you please send me that XML which was sent out to you.

Thanks..Sandeep S

[NicoleBruno]

Hi Sandeep, 

Sure, DM me your email address and I'll forward.

[KhanhNguyen]

Hi Nicole,

Hopy you are doing well. Could you send me the xml please? 

My email is "khanh.nguyen@kleegroup.com"

Thank you very much in advance,

Khanh

[vc26516]

Hello Nicole,

Hope everything is fine with you. Could you please share the Dashboard xml for finding DB size to my email ID: vijeshcp.delarue@gmail.com.

Thanks,

Vijesh

[NicoleBruno]

Just sent! 

[BabuJayaraman]

Hi Nichole, Can you send me the XML to my email jayaraman.babu@gmail.com. Thanks in advance.

[MarkMatson]

Hi, you can check an individual database size with an extensibility rule containing code like this:

Dim sql As String = "EXEC sp_spaceused;"
Dim dbConnApp As DbConnInfoApp = brapi.Database.CreateApplicationDbConnInfo(si)

Using dbConnApp
Using dt As DataTable = BRAPi.Database.ExecuteSql(dbConnApp, sql.ToString, True)
If Not dt Is Nothing Then
'Reference dt to access data table results
For Each dr As DataRow In dt.Rows
'Process rows
brapi.ErrorLog.LogMessage(si, "database_size: " + dr("database_size"))
brapi.ErrorLog.LogMessage(si, "unallocated space: " + dr("unallocated space"))
Next

End If
End Using
End Using