Azure SQL维护 [英] Azure SQL maintenance
问题描述
我目前正在使用快速增长的Azure SQL数据库.正如我在这里和Microsoft文档中所读到的,没有SQL Server代理可以安排诸如重建索引之类的任务.我的问题是设置某种维护的最佳实践是什么,以及在不固定数据库或使表不可用的情况下重建索引的最佳方法是什么?在某些表上重建索引会释放5-30GBS的空间,具体取决于大小,但会使表脱机.
Im currently working with a quickly growing Azure SQL database. As I've read here and Microsoft docs that there is no SQL Server Agent to schedule tasks such as rebuilding indexes. My question is what is the best practice for setting up some sort of maintenance and whats the best way to rebuild the indexes without pegging the DB or making the table unavailable? Rebuilding indexes on some of these tables are freeing 5 - 30GBS of space depending on size, but taking the table offline.
推荐答案
您可以使用Elastic Database jobs
.
下面是弹性作业的作用
Elastic Database作业当前是由客户托管的Azure云服务,可用于执行即席和计划的管理任务,称为作业.使用作业,您可以通过运行Transact-SQL脚本执行管理操作来轻松可靠地管理大量Azure SQL数据库.
Elastic Database jobs is currently a customer-hosted Azure Cloud Service that enables the execution of ad-hoc and scheduled administrative tasks, which are called jobs. With jobs, you can easily and reliably manage large groups of Azure SQL Databases by running Transact-SQL scripts to perform administrative operations.
下面是可以帮助您入门的链接
below are the links which can help you in getting started
https://docs.microsoft.com/zh-CN/azure/sql-database/sql-database-elastic-jobs-service-installation
您还可以创建链接服务器以进行蔚蓝处理并执行这些管理任务
You also can create linked servers to azure and do these administrative tasks
https://stackoverflow.com/a/41145784/2975396
这篇关于Azure SQL维护的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!