Manage your SQL Server instances at scale from a single point of control
SQL Server enabled by Azure Arc extends Azure services to SQL Server instances hosted outside of Azure: in your data center, in edge site locations like retail stores, or any public cloud or hosting provider.
Azure Arc enables you to manage all of your SQL Server instances from a single point of control: Azure. As you connect your SQL Server instances to Azure, you get a single place to view the detailed inventory of your SQL Server instances and databases.
- Look at details for a given SQL Server in the Azure portal such as the name, version, edition, number of cores, and host operating system.
- Query across all of your SQL Server instances using Azure Resource Graph Explorer to answer questions like:
- “How many SQL Server instances do I have that are SQL Server 2014?”
- “What are the names of all the SQL Server instances that are running on Linux?”
- Quickly create charts from these queries and pin them to customizable dashboards.
- View a list of every database on a SQL Server and do cross-SQL Server queries of databases to see:
- Databases that haven’t been backed up recently.
- Databases that aren’t encrypted.
Best Practices assessment
You can optimize the configuration of your SQL Server instances for best performance and security by running a best practices assessment. The assessment report shows you specific ways to improve your configuration. The assessment compares your configuration to best practices established by Microsoft Support through many years of real-world experience. Each suggestion includes the details on how to change the configuration.
Pay-as-you-go for SQL Server
Now, with SQL Server enabled by Azure Arc, you have the option of purchasing SQL Server using a ‘pay-as-you-go’ model instead of purchasing licenses. This model is a great alternative if you’re looking to save costs on SQL Server instances that have variable demand for compute capacity over time. For example, when you can turn off a SQL Server at night or on weekends, or even just scale down the number of cores used during less busy times. It’s also a great option if you only plan to use a SQL Server for a short period of time and then won’t need it anymore. Pay-as-you-go, billed through Azure, is now available for all versions of SQL Server from 2012 to 2022.
Don’t hesitate to contact us for more questions: microsoft.be@tdsynnex.com
The Microsoft team at TD SYNNEX