Sep 9, 2024 · You can automatically enable best practices assessment on multiple Azure Arc-enabled SQL Server instances at scale by using an Azure Policy definition called Configure Arc-enabled Servers with SQL Server extension installed …

Mar 20, 2023 · In this post, I will demonstrate how to setup and use the SQL best practices assessment feature for Azure Arc Enabled SQL Server. Best practices assessment provides a mechanism to evaluate the configuration of your SQL Server.

Mar 25, 2025 · Some of the services provided by SQL Server enabled by Azure Arc, such as Microsoft Defender for Cloud and best practices assessment, require the Azure Monitoring agent (AMA) extension to be installed and connected to an Azure Log Analytics workspace for data collection and reporting.

Go to Best Practices Assessment on your Arc-enabled SQL Server resource page in the Azure portal and re-enable best practices assessment and select a new log analytics workspace. For more assistance, create a support ticket with Microsoft and attach the log files.

Jan 18, 2023 · In this blog, I will introduce you to the Best practices assessment (BPA) feature powered by Azure Arc-enabled SQL Server. This feature allows you to proactively diagnose potential issues with your SQL Server environment running on-premises and in …

Apr 2, 2025 · Moving Azure Arc-enabled SQL Server instances is generally straightforward, similar to relocating other Azure resources. However, it becomes more complex when dependent features like Best Practice Assessment (BPA) are enabled.

Jun 19, 2023 · There is a to explore with the Azure Arc SQL Extension and various ways to use the platform to provide more visibility and control over your SQL servers. A look into Azure Arc SQL Extension and how best practices assessment and what it can extract from an Azure Arc enabled SQL Server.

4 days ago · Configure Arc-enabled Servers with SQL Server extension installed to enable or disable SQL best practices assessment. Enable or disable SQL best practices assessment on the SQL server instances on your Arc-enabled servers to evaluate best practices. Learn more at https://aka.ms/azureArcBestPracticesAssessment.

Mar 21, 2023 · Best practices assessment provides a mechanism to evaluate the configuration of your SQL Server. Once the best practices assessment feature is enabled, your SQL Server instance and databases are scanned to provide recommendations for things like SQL Server and database configurations, index management, deprecated features, enabled or missing ...

Jul 7, 2023 · You can also get the best practices assessment after enabling the Azure Arc-enabled SQL Servers. This assessment will analyze the SQL Server configurations comparing the best practices based on Azure standards and provide recommendations.