question

ChrisBracchi-4434 avatar image
0 Votes"
ChrisBracchi-4434 asked HimanshuSinha-MSFT commented

Dedicated pool to azure sql database

If executing workload in dedicated pool, through stored procedure for example, is it possible to log to azure sql database?

Considering single row inserts in dedicated pool are relatively slow. Also, if all logging needs to be available in azure sql database.

Thanks for any help,
Chris

azure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ChrisBracchi-4434 ,
Thanks for the ask and using Microsoft Q&A platform .

I understand the use of procs for the implementing a logic , but I am not sure as to what are you trying to log in the table ? May be record counts from one query in the SP , is that correct ? I am not sure as to how we can make a call from an inside from a SP for an insert call to Azure SQL .
Please elalorate more on the ask .

Thanks
Himanshu

0 Votes 0 ·

0 Answers