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.

Understanding serverless pools

Understanding serverless pools

From the course: Microsoft Azure Synapse for Developers

Start my 1-month free trial Buy for my team

Understanding serverless pools

“

- [Instructor] When we created our workspace, inside it we had a default serverless pool, which was built-in, and we could either remove it or change it. In this clip, we are going to see what it is and how we can use it. Unlike dedicated as SQL pools, serverless pools don't have an infrastructure that we have to provision. With a dedicated SQL pool, we had to tell it how much compute power we needed, while with serverless pools, it will figure out by itself and query the data. Similarly to dedicated pools, it uses a scale out architecture that distributes the processing of the queries into compute nodes while dedicated SQL pools use a massive parallel processing engine to distribute the queries across different compute nodes and depending how data was distributed, each node had certain data to process. Some had more data than others depending on the distribution. Serverless pools, on the other hand, use a…

Contents