From the course: Microsoft Azure Synapse for Developers

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Cost management

Cost management

From the course: Microsoft Azure Synapse for Developers

Start my 1-month free trial Buy for my team

Cost management

“

- [Instructor] Since serverless SQL pools do not need any provisioning, they'll automatically provision all the necessary resources in order to query the data. But what if we have a lot of data, and by mistake we run a query and we let it run all night? That will result in a lot of charges for us. And mistakes can easily be made by letting a query run in the background and not noticing. A good way to manage the cost is by setting limits. To set limits, first, we need to navigate to the Manage tab in our Synapse Studio and we need to navigate to SQL Pools. Here, we have two, we have the built-in and a sales data warehouse dedicated SQL pool. If the sales data warehouse dedicated pool's status is online, it might be a good idea to pause it. There should be a pause button here where the resume is. If you pause it then you can resume it at any time later, so no charges incur. But for the demo, we are going to manage our…

Contents