For an Azure sql server MI, we have multiple external users consuming data, I would like to know how much data an user is consuming/extracting from the DB?

Can this be checked from, 1.) From SSMS using queries or UI? 2.) Azure portal?

  • Have you looked at sys.dm_io_virtual_file_stats? Here is a detail write up by Erin Stellato. Apr 29, 2019 at 12:27
  • @SqlWorldWide I guess the number of reads and number of writes would do good, but 'sys.dm_io_virtual_file_stats' provides on the whole at DB level. Can we get this for each user for a particular DB? example, Num_of_reads by 'user1' in a DB. Btw, Thank you for the response.
    – Venkat
    Apr 29, 2019 at 14:01
  • I have not tested this myself. I suggest these two extended events (and maybe there are others), sqlserver.file_read and sqlserver.file_write_completed in combination with actions (to filter by username) will give you what you are looking for. Apr 29, 2019 at 14:50
  • @SqlWorldWide Does this require us to create an extended event task? Or is it kind of a default option or something?
    – Venkat
    Apr 29, 2019 at 18:37
  • You will need to create an extended event trace, save the data a sql server table, do some aggregation to get the data you are looking for. red-gate.com/simple-talk/sql/database-administration/… Apr 29, 2019 at 18:56


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.