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.
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 🙂
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!
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
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.
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
