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.
4,659 questions
Command sp_create_sbs_file in pool SQL - Azure Synapse
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 45%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Felipe Barbosa Cerqueira Carvalho
40
Reputation points
Hi,
We discovered last week that pool SQL from Synapse ran the query “sp_create_sbs_file” multiple times and the usual queries were not being run.
I would like to know why this command executes and what actions we can take to work around the problem. I would like a documentation about this command as well.
Below is an image of the command executions:
Att,
João Felipe B. C. Carvalho
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 28,936 Reputation points Microsoft Employee2024-07-15T17:25:42.4833333+00:00 Hello João Felipe Barbosa Cerqueira Carvalho,
Are you running any streaming operation? The issue is with Serverless SQL pool or dedicated SQL pool?
Please provide more details of the issue that you are facing.
-
João Felipe Barbosa Cerqueira Carvalho 40 Reputation points
2024-07-16T13:06:52.8366667+00:00 Hi,
No, we are not currently running any streaming operations. The issue is with Serveless SQL pool.
Sign in to comment