Forum Discussion

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

Jason Eales
Mar 12, 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.

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
Copper Contributor
Mar 12, 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.