We are under construction!

You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.

Forum Discussion

Beeswing's avatar
Beeswing
New Contributor III
3 years ago

How to check disk space

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.

Infrastructure
  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    3 years ago

    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's avatar
    NicoleBruno
    Valued Contributor
    3 years ago

    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's avatar
      Beeswing
      New Contributor III
      3 years ago

      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's avatar
        NicoleBruno
        Valued Contributor
        3 years ago

        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. 

  • MarkMatson's avatar
    MarkMatson
    New Contributor III
    3 years ago

    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