如何衡量用户在azure SQL Server数据库中消耗的数据？ [英] How to measure data consumed by an user in azure SQL server database?

问题描述

对于天蓝色的SQL服务器MI，我们有多个用户在使用数据，我想知道用户从数据库中消耗/提取的数据量是多少？

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

可以从中检查，

1。）使用查询或用户界面来自SSMS吗？

1.) From SSMS using queries or UI?

2.）Azure门户？

2.) Azure portal?

推荐答案

Hi Venkat，

Hi Venkat,

Azure Monitor是深入研究和调查此信息的最佳解决方案。由于MI部署到Azure VM，因此可能会公开perf计数器数据，Azure Monitor可以提供客户数据消费的见解：  收集有关Azure虚拟机的
数据

Azure Monitor is the best solution to dig into and investigate this information. Since MI is deployed to an Azure VM it might be possible that perf counter data is exposed and Azure Monitor can provide the insights to client data consumption: Collect data about Azure Virtual Machines

另一个选项是为SQL实例启用日志分析，并使用Azure Monitor来提取和分析收集的日志数据：  查看或分析使用Log Analytics日志搜索收集的
数据

Another option is to enable log analytics for the SQL instance and use Azure Monitor to ingest and analyze the collected log data: View or analyze data collected with Log Analytics log search

可用工具有多种选项：  Azure SQL数据库：监控和调优

There are multiple options for available tools: Azure SQL Database: Monitoring and tuning

如果您无法在数据库级别跟踪客户端消耗，可能有一个上游应用程序可以利用它来跟踪连接和MB的传输和相关数据点。 

If you are unable to track client consumption at the database level, perhaps there is an upstream application that can be leveraged to track connections and MB's transferred and related data points. 

我希望这会有所帮助。

I hope this helps.

这篇关于如何衡量用户在azure SQL Server数据库中消耗的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！