Forum Discussion

Jason Eales's avatar
Jason Eales
Copper Contributor
Mar 11, 2019
Solved

Monitor SQL database size increase

Hi   I want to be able to monitor how the size of my database increases over time.   I have created a SQL server VM and have wired up the Log Analytics and set it to capture the SQL performance c...
azure monitor
SQL Database
  • Jason Eales's avatar
    Jason Eales
    Mar 13, 2019

    Hi Clive

     

    So as it turns out it was measuring correctly! I was not inserting enough data to force the datafile autogrowth to occur.

     

    So when I loaded the insert up we had to occurrences of the datafile growing. This showed on the Perfmon on the SQL server and was captured by the Azure Log Analytics workspace.

CliveWatson's avatar
CliveWatson
Former Employee
Mar 12, 2019

I have a feeling that counter looks at the total size, not the growth as you think.  https://docs.microsoft.com/en-au/sql/relational-databases/performance-monitor/sql-server-databases-object?view=sql-server-2014

  • Jason Eales's avatar
    Jason Eales
    Copper Contributor
    Mar 13, 2019

    Hi Clive

     

    So as it turns out it was measuring correctly! I was not inserting enough data to force the datafile autogrowth to occur.

     

    So when I loaded the insert up we had to occurrences of the datafile growing. This showed on the Perfmon on the SQL server and was captured by the Azure Log Analytics workspace.

Resources