Share via

Minimum advised Synapse SQL pool service level to start working for a prod environment

pmscorca 1,052 Reputation points
2024-03-18T12:29:34.72+00:00

Hi,

which is the minimum Synapse service level that Microsoft advises for a dedicated SQL pool of a prod environment?

Thanks

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Answer accepted by question author

Charlie Wei 3,335 Reputation points
2024-03-18T14:36:30.34+00:00

Hello pmscorca,

I suggest that you initially refer to the documents "How many data warehouse units do I need" and "Finding the right size of data warehouse units" to determine the number of DWUs required.

Additionally, defining the Recovery Time Objective (RTO) for the production environment is crucial. If Automatic Restore Points do not meet your requirements, you might want to consider User-defined restore points.

Best regards,
Charlie

If you find my response helpful, please consider accepting this answer and voting 'yes' to support the community. Thank you!

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.