Guest Jose_Manuel_Jurado Posted January 21, 2023 Posted January 21, 2023 Yesterday, we got an interested service request where our customer saw SATELLITE_SERVICE_SETUP waits stat in their query execution time. This wait stat is regarding about external execution scripts. Our customer found several performance issue running in paralell multiple executions of Python scripts in the SQL MI database using R with EXECUTE sp_execute_external_script . After an investigation with our Azure Product Team we explained the details found Key differences for Machine Learning Services - Azure SQL Managed Instance | Microsoft Learn As you could see in this URL Key differences for Machine Learning Services - Azure SQL Managed Instance | Microsoft Learn mentioned before we have a resource governance to protect the resource of your managed instance. Resource governance: In SQL Managed Instance, it's not possible to limit R resources through Resource Governor, and external resource pools are not supported. By default, R resources are set to a maximum of 20% of the available SQL Managed Instance resources when extensibility is enabled. To change this default percentage, create an Azure support ticket at Microsoft Azure Support Ticket | Microsoft Azure. The total resources available to SQL Managed Instance depend on which service tier you choose. For more information, see Azure SQL Database purchasing models. Continue reading... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.