CODEWITHSUNDEEP
azure-synapse
Patterson
Patterson

Reputation: 2759

How to increase performance on Azure inbuilt SQL Serverless Pool in Synapse

We are currently extracting multiple tables from Azure SQL Servereless pool in Synapse. Unlike a regular Azure SQL Database it is very easy to increase the performance from Basic all the way through to Premium or Business continuity.

Can someone let me know how to go about increasing the performance of Azure SQL Serverles Pool in synapse?

Upvotes: 0

Views: 552

Answers (1)

Aswin
Aswin

Reputation: 7126

Serverless SQL pool is a distributed data processing system and it doesn't have any inbuilt storage to store data. It uses external table to query the data from Azure data lake storage. Therefore, data cannot be copied to the serverless SQL pool. If data needs to be extracted from serverless SQL pool, you can extract data directly from the underlying external storage. If the target datastore supports polybase data loading, use that to load to the target table from ADLS.

Upvotes: 1

Related Questions