Analytics around data entires being made in SQL tables?

Question

We need to analyze how much data is being inserted every month or every day to understand the usage of the db tables in order to scale the DB accordingly.

Answer 1

Hi @Vipul Sharma Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding is that you want to know how much is being inserted every month or every day to understand the usage of DB tables.
In addition to @Alberto Morillo 's answer. The Data ingestion per solution chart on the Usage and Estimated Costs page for each workspace shows the total volume of data sent and how much is being sent by each solution over the previous 31 days. This helps you determine trends such as whether any increase is from overall data usage or usage by a particular solution.

If you can find information on data usage in log analytics workspace.

Regards,
Oury

Answer 2

On a daily basis, you can create the following temporary table at the beginning of the day.

   SELECT o.name as table_name, SUM(p.rows) sum_rows  
   INTO tmpBegOfDate  
   FROM   sys.objects o  
   JOIN   sys.partitions p ON o.object_id = p.object_id  
   WHERE  p.index_id IN (0, 1)  
   GROUP  BY o.name order by sum_rows desc  

At the end of the day create this second temporary table.

   SELECT o.name as table_name, SUM(p.rows) sum_rows  
   INTO tmpEndOfDate  
   FROM   sys.objects o  
   JOIN   sys.partitions p ON o.object_id = p.object_id  
   WHERE  p.index_id IN (0, 1)  
   GROUP  BY o.name order by sum_rows desc  

Now you can run below query to get your statistics for a day.

   SELECT b.table_Name, (e.sum_rows - b.sum_rows) AS RowsInsertedToday  
   FROM tmpBegOfDate b INNER JOIN tmpEndOfDate e  
   ON b.table_name = e.table_name  
   WHERE e.sum_rows is not null AND b.sum_rows is not null