@Handian Sudianto
Thank you for the question and for using Microsoft Q&A platform.
The migration to the SQL-targeted Azure Monitoring Agent (AMA) auto provisioning process for Defender for SQL servers on machines is designed to be seamless and should not cause downtime for your SQL servers. However, for SQL Server versions 2017 and older, a restart of the SQL server instance might be necessary.
Regarding costs, there are no additional charges specifically for enabling the new auto provisioning process itself. However, the overall cost of using Microsoft Defender for SQL servers on machines will depend on the pricing details outlined on the Azure pricing page.
For more information, please refer to the below links:
https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-usage
https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-autoprovisioning
Hope this helps. Do let us know if you have any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.