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.
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
Azure Synapse Analytics
SQL Server | Other
{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 31,361 Reputation points Microsoft Employee Moderator2024-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.
-
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2024-07-16T22:03:43.2866667+00:00 Sorry, I don't see the command
sp_create_sbs_filedocumented anywhere.Can you please check the troubleshooting document below and see if it helps?
Sign in to comment
Sign in to answer