Daily runtime hours of Synapse Workspace

Question

Daily runtime hours of Synapse Workspace

Prabhu 60

I would like to analyze the daily runtime hours and associated costs for our Azure Synapse workspace. Specifically, I want to understand the total number of hours the workspace runs each day and the corresponding cost per run.

Accepted answer

0 additional answers

Your answer

Answer 1

Ganesh Gurram 6,040 Microsoft External Staff

@Prabhu

To analyze the daily runtime hours and associated costs of your Azure Synapse workspace, follow these steps:

Understanding Synapse Workspace Usage - Azure Synapse Analytics costs depend on:

Compute Resources - Dedicated SQL pools (billed per active hour), Spark pools, and serverless SQL (billed per query).

Storage Costs - Charges for data stored in Synapse.

Data Movement - Costs incurred when transferring data in/out.

Tracking Runtime Data - To track daily runtime hours, use Azure Monitor and Azure Activity Logs:

Azure Monitor - Logs SQL pool start/stop times.

Activity Logs - Check when the pool was active.

KQL Query to Track SQL Pool Activity in Log Analytics

AzureDiagnostics
| where ResourceType == "DATABASES"
| where Resource == "<Your-SQL-Pool-Name>"
| project TimeGenerated, Resource, OperationName, ActivityStatus

This query helps identify start/stop events to calculate daily runtime.

Calculating Daily Runtime Hours

Dedicated SQL Pools - Sum up the duration between start and pause events.

Serverless SQL Pools - Monitor query execution time (no continuous runtime).

Estimating Costs

Use Azure Cost Management + Billing to filter Synapse costs by date.

Formula:

Total Cost=Runtime Hours×Cost per Hour\text{Total Cost} = \text{Runtime Hours} \times \text{Cost per Hour}Total Cost=Runtime Hours×Cost per Hour

User's image

https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/pricing-calculator

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-query-overview

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics

I hope this information helps.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Prabhu 60 Reputation points

2025-03-25T07:27:09.9533333+00:00

Thanks . Can't i get this details in the cost analysis tab in the subscription without querying the log analytics workspace.
Ganesh Gurram 6,040 Reputation points Microsoft External Staff

2025-03-25T10:30:56.75+00:00
@Prabhu

Yes, you can view cost details related to your Azure Synapse workspace in the Cost Analysis tab in the Azure portal without querying Log Analytics. However, there are some limitations:

The Cost Analysis tab in Azure Cost Management + Billing provides a breakdown of costs by service, resource, and usage over time.

You can filter costs by resource type, resource group, and time range to analyze Synapse-related charges.

While this provides cost insights, it does not directly show runtime hours.

For a detailed breakdown of runtime hours, you will still need to analyze logs via Azure Monitor or Activity Logs, as Cost Analysis focuses on billed usage rather than actual runtime.

If your goal is only to check cost trends, Cost Analysis is sufficient. But if you need exact daily runtime hours, querying logs will provide more accurate results.

You can check Azure Cost Management documentation for more details:

https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/reporting-get-started

Hope this information helps!
Ganesh Gurram 6,040 Reputation points Microsoft External Staff

2025-03-26T04:25:29.7666667+00:00

@Prabhu

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Daily runtime hours of Synapse Workspace

0 additional answers

Your answer