Azure Stream Analytics的工作对于小数据而言昂贵吗? [英] Azure Stream Analytics job expensive for small data?

问题描述

为了将传感器数据从IoT设备写入云中的SQL数据库，我使用了Azure流分析作业. SA作业具有IoT中心输入和SQL数据库输出.该查询很简单；它只是通过发送所有数据). 根据MS价格计算器，完成此操作的最便宜方法(在西欧)每月约为75欧元(请参见屏幕截图).

In order to write sensor data from an IoT device to a SQL database in the cloud I use an Azure Streaming Analytics job. The SA job has an IoT Hub input and a SQL database output. The query is trivial; it just sends all data through). According to the MS price calculator, the cheapest way of accomplishing this (in western Europe) is around 75 euros per month (see screenshot).

实际上，每分钟仅通过集线器发送一条消息，并且每月固定价格(与消息量无关).如此琐碎的小数据任务的价格令我感到惊讶.对于如此低的容量需求，是否会有更便宜的选择?也许是Azure函数?

Actually, only 1 message per minute is send through the hub and the price is fixed per month (regardless of the amount of messages). I am surprised by the price for such a trivial task on small data. Would there be a cheaper alternative for such low capacity needs? Perhaps an Azure function?

推荐答案

如果您不实时处理数据，则不需要SA，您可以使用事件中心来提取传感器数据并将其转发.有多种选项可将数据从事件中心移到SQL.正如您在问题中提到的那样，您可以使用Azure函数，或者，如果您需要无代码解决方案，则可以使用Logic App.

If you are not processing the data real-time then SA is not needed, you could just use an Event Hub to ingest your sensor data and forward it on. There are several options to move data from the Event Hub to SQL. As you mentioned in your question, you could use an Azure Function or if you want a no-code solution, you could us a Logic App.

https://docs .microsoft.com/en-us/azure/connectors/connectors-create-api-azure-event-hubs

https://docs.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure

这篇关于Azure Stream Analytics的工作对于小数据而言昂贵吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！