1

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?

Improve this question
7
  • Have you looked at sys.dm_io_virtual_file_stats? Here is a detail write up by Erin Stellato.
    – SqlWorldWide
    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.
    – SqlWorldWide
    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/…
    – SqlWorldWide
    Apr 29, 2019 at 18:56

0

Reset to default

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.