question

serverlesssql avatar image
0 Votes"
serverlesssql asked serverlesssql commented

Serverless SQL Pools Data Processed convert MB to GB/TB

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

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered serverlesssql commented

Hello @serverlesssql,

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

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

102808-synapseserverless.gif

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.


· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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.

102921-image.png

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


0 Votes 0 ·
image.png (10.4 KiB)

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:


103082-image.png

Am I calculating GB and TB used as:

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

or

  1. 6627993 \ 1024 = 6,472 (6.4TB)




0 Votes 0 ·
image.png (14.0 KiB)

Hello @serverlesssql,

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

1 Vote 1 ·
serverlesssql avatar image serverlesssql PRADEEPCHEEKATLA-MSFT ·

Thank you.

0 Votes 0 ·