Serverless SQL Pools Data Processed convert MB to GB/TB

Question

Serverless SQL Pools Data Processed convert MB to GB/TB

Serverless SQL 216 MVP

Hi, when I query the sys.dm_external_data_processed table to show me the current data processed metrics for Serverless SQL Pools I'm wondering which conversion to use to convert from MB to GB/TB? E.G should I calculate GB = MB / 1000 or MB / 1024?

Thanks

Accepted answer

0 additional answers

Your answer

Answer 1

PRADEEPCHEEKATLA 90,641 Moderator

Hello @Serverless SQL ,

Thanks for the question and using MS Q&A platform.

As per the pricing calculator, 1 GB is 1,000 MB as shown below.

For more details, refer to Azure Pricing Calculator.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Serverless SQL 216 Reputation points MVP

2021-06-07T06:49:24.14+00:00

Hi, what you’ve shown there is Dedicated SQL Pools storage and not Serverless SQL Pools “data processed”.

There is a system view called sys.dm_external_data_processed which shows data processed but at MB level. I need to know how to convert this to GB and TB by dividing by 1000 or 1024
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-07T07:10:02.893+00:00

Hello @AndyDCutler,

I just used the above Dedicated SQL Pools storage example to show how data is calculated in Azure Synapse Analytics.

You can calculate 1 GB is equal to 1,000 MB as shown above.

This functionality allows you use T-SQL to query data from your data lake in Azure rather than provision resources ahead of time. You only pay for executed queries and the pricing is based on the amount of data processed by each query. Metadata-only queries (DDL statements) do not incur a cost. Queries will incur a minimum charge of 10 MB and each query will be rounded up to the nearest 1 MB of data processed.

Hope this helps. Do let us know if you any further queries.
Serverless SQL 216 Reputation points MVP

2021-06-07T14:45:38.26+00:00
What I'm trying to understand is the calculation to turn the MB that is returned by the system view called sys.dm_external_data_processed in GB or TB. For example, if I run a query like this on my Serverless SQL Pools database I get the following result:

Am I calculating GB and TB used as:

6627993 \ 1000 = 6,627 GB (6.6TB)

or

6627993 \ 1024 = 6,472 (6.4TB)
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-08T03:13:20.377+00:00

Hello @Serverless SQL ,

As I said above you need to divide by 1000 to convert into MB => GB => TB

6627993/1000 MB => 6627.993/1000 GB => 6.627993 TB
Serverless SQL 216 Reputation points MVP

2021-06-08T09:36:32.067+00:00

Thank you.

Share via

Serverless SQL Pools Data Processed convert MB to GB/TB

0 additional answers

Your answer