azure-sql-managed-instance

Azure SQL Managed Instance 技能

此技能为 Azure SQL Managed Instance 提供专业指导，涵盖故障排除、最佳实践、决策、架构和设计模式、限制和配额、安全性、配置、集成和编码模式，以及部署。它结合了本地快速参考内容与远程文档获取功能。

如何使用此技能

IMPORTANT for Agent：使用下方的类别索引查找相关章节。对于带有行范围的类别（例如 L35-L120），请使用 read_file 读取指定行。对于带有文件链接的类别（例如 [security.md](security.md)），请使用 read_file 读取所链接的参考文件

IMPORTANT for Agent：如果 metadata.generated_at 已超过 3 个月，请建议用户从存储库拉取最新版本。如果无法使用 mcp_microsoftdocs 工具，请建议用户安装该工具：安装指南

此技能需要网络访问才能获取文档内容：

• 首选：使用 mcp_microsoftdocs:microsoft_docs_fetch，并在查询字符串中指定 from=learn-agent-skill。返回 Markdown。
• 备用：使用 fetch_webpage，并在查询字符串中指定 from=learn-agent-skill&accept=text/markdown。返回 Markdown。

类别索引

类别	行	说明
故障排除	L37-L59	诊断和修复 Azure SQL Managed Instance 问题：部署/缩放错误、连接、性能、备份、内存/日志容量、异地复制、XTP 存储、身份验证及常见已知问题。
最佳实践	L60-L81	Azure SQL Managed Instance 的性能、HA/DR 和安全最佳实践，包括监视、查询优化、维护、故障转移/异地复制、迁移和应用性能优化。
决策	L82-L98	选择 Azure SQL 服务和层级、规划子网/IP，以及决定或执行迁移（SQL Server、Db2、Oracle）和复制选项（link、LRS、备用实例）的指导。
架构和设计模式	L99-L103	Azure SQL DB 的连接架构和 Managed Instance 的 HA 设计，包括网络拓扑、路由、故障转移行为和复原模式。
限制和配额	L104-L115	Azure SQL Managed Instance 的备份保留/不可变性规则、DTU 基准、免费层和内存限制、维护时段、操作持续时间，以及所有关键资源/缩放限制。
安全性	L116-L167	配置 Azure SQL Managed Instance 安全性：Entra 身份验证（用户、登录名、Windows/Kerberos）、托管标识、TDE 和客户管理的密钥、TLS、审核、网络和 Azure Policy。
配置	L168-L217	配置和管理 Azure SQL Managed Instance：部署、网络、备份/还原、监视、维护时段、更新策略、时区/tempdb，以及高可用性/故障转移。
集成和编码模式	L218-L241	使用 Azure SQL Managed Instance 的应用的客户端连接、编码模式和工具，以及自动化、DTC、XEvents、Spark、Managed Instance link 和备份/还原场景。
部署	L242-L257	部署和管理 Azure SQL Managed Instance 及数据库：缩放、启动/停止以控制成本、DR/复制、区域/子网迁移，以及所需的虚拟网络设置。

故障排除

主题	URL
解决 Azure SQL 容量部署和缩放错误	https://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql
解决 Azure SQL 数据库观察器的常见问题	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-faq?view=azuresql
修复 Azure SQL 中缓慢的数据库导入和导出	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
使用 Intelligent Insights 排查 Azure SQL 性能问题	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?view=azuresql
排查 Azure SQL 的暂时性连接错误	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql
排查 Azure SQL 和 Fabric SQL 连接错误	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
排查 Azure SQL Database 中的异地复制和重做延迟	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-geo-replication-redo?view=azuresql
调查并修复 Azure SQL Database 中的内存问题	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql
解决 Azure SQL Database 中的事务日志已满错误	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-transaction-log-errors-issues?view=azuresql-db
监视 Azure SQL Managed Instance 备份活动	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-activity-monitor?view=azuresql
解决 Azure SQL Managed Instance 中的已知问题	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
解决 Azure SQL Managed Instance 的常见问题	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/frequently-asked-questions-faq?view=azuresql
监视 XTP 内存中存储并修复容量错误 41823	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-monitor-space?view=azuresql
诊断并修复 Managed Instance 链接问题	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-troubleshoot-how-to?view=azuresql
安全取消 Azure SQL Managed Instance 操作	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-cancel?view=azuresql
使用 DMV 诊断 Azure SQL Managed Instance 性能	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-with-dmvs?view=azuresql
使用 Azure Resource Health 诊断 SQL Managed Instance 问题	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-health-to-troubleshoot-connectivity?view=azuresql
解决 Azure SQL Managed Instance 中的事务日志已满错误	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi
排查 SQL Managed Instance 的 Entra Kerberos Windows 身份验证问题	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-troubleshoot?view=azuresql

最佳实践

主题	URL
使用 KQL 和 T-SQL 分析 Azure SQL 监控数据	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-analyze?view=azuresql
Azure SQL 应用程序性能调优指南	https://learn.microsoft.com/en-us/azure/azure-sql/database/performance-guidance?view=azuresql
为 Azure SQL 计划维护事件做好准备	https://learn.microsoft.com/en-us/azure/azure-sql/database/planned-maintenance?view=azuresql
在 Azure SQL 中配置和使用读取扩展副本	https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql
应用 Azure SQL 安全最佳实践	https://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql
识别并解决 Azure SQL 查询性能问题	https://learn.microsoft.com/en-us/azure/azure-sql/identify-query-performance-issues?view=azuresql
为 Azure SQL Managed Instance 设置警报和通知	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/alerts-create?view=azuresql
为 SQL Managed Instance 执行灾难恢复演练	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-drills?view=azuresql
为 Azure SQL Managed Instance 实施灾难恢复	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-guidance?view=azuresql
使用故障转移组在 SQL Managed Instance 中进行异地复制	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-sql-mi?view=azuresql
管理 Azure SQL Managed Instance 上的数据库文件空间	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/file-space-manage?view=azuresql-mi
应用 Azure SQL Managed Instance 的 HA 和 DR 最佳实践	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-disaster-recovery-checklist?view=azuresql
识别并解决 Azure SQL Managed Instance 上的查询瓶颈	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/identify-query-performance-issues?view=azuresql
使用 Log Replay Service 迁移到 Azure SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate?view=azuresql
应用 Managed Instance 链接复制的最佳实践	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-best-practices?view=azuresql
调优 Azure SQL Managed Instance 的应用程序性能	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/performance-guidance?view=azuresql
应用 Azure SQL Managed Instance 的 T-SQL 差异	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server?view=azuresql
使用批处理提升 Azure SQL 应用程序性能	https://learn.microsoft.com/en-us/azure/azure-sql/performance-improve-use-batching?view=azuresql

决策

主题	URL
使用 Azure SQL 决策树选择服务	https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-decision-tree?view=azuresql
比较 Azure SQL Database 和 Managed Instance 的功能	https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
为 SQL Managed Instance 配置免许可证的备用副本	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-standby-replica-how-to-configure?view=azuresql
选择 Log Replay Service 或 Managed Instance link	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-compare-mi-link?view=azuresql
选择 Azure SQL 或 SQL Server ML Services	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/machine-learning-services-differences?view=azuresql
使用 link 将 SQL Server 迁移到 Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-migrate?view=azuresql
选择 SQL Managed Instance 的 vCore 服务层级	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-managed-instance-vcore?view=azuresql
选择并使用 Azure SQL MI 的新一代常规用途层级	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-next-gen-general-purpose-use?view=azuresql
确定 Azure SQL Managed Instance 的子网大小和 IP 范围	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-determine-size?view=azuresql
选择并规划迁移到 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/?view=azuresql
规划并执行从 Db2 到 SQL Managed Instance 的迁移	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/db2-to-managed-instance-guide?view=azuresql
规划从 Oracle 到 Azure SQL Managed Instance 的迁移	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/oracle-to-managed-instance-guide?view=azuresql
规划并决定 SQL Server 到 Azure SQL 的迁移	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/modernization?view=azuresql

架构与设计模式

主题	URL
了解 Azure SQL Database 的连接体系结构	https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql

限制与配额

主题	URL
了解 Azure SQL 自动备份的不可变性	https://learn.microsoft.com/en-us/azure/azure-sql/automatic-backup-immutability?view=azuresql
了解 Azure SQL Database 的 DTU 基准测试特征	https://learn.microsoft.com/en-us/azure/azure-sql/database/dtu-benchmark?view=azuresql
了解 Azure SQL 长期备份保留限制	https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql
了解 Azure SQL Managed Instance 免费层限制	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/free-offer?view=azuresql
采用内存中 OLTP 并了解 SQL MI 的内存限制	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-configure?view=azuresql
了解 Azure SQL Managed Instance 维护时段	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-faq?view=azuresql
了解 Azure SQL Managed Instance 操作时长	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-duration?view=azuresql
查看 Azure SQL Managed Instance 资源限制	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql

安全

主题	URL
为 Azure SQL 配置 Microsoft Entra 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql
为 Azure SQL 身份分配 Directory Readers 角色	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role-tutorial?view=azuresql
为 Azure SQL 身份配置 Directory Readers 和权限	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role?view=azuresql
为 Azure SQL 配置 Microsoft Entra 来宾访问	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-guest-users?view=azuresql
配置 Azure SQL 的 Microsoft Entra 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql
在 Azure SQL 中使用 Entra 服务主体	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal?view=azuresql
在 Azure SQL 中创建和使用 Microsoft Entra 登录名	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins-tutorial?view=azuresql
在 Azure SQL 中使用 Microsoft Entra 服务器主体	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins?view=azuresql
创建仅使用 Entra 身份验证的 Azure SQL 服务器	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-create-server?view=azuresql
使用 Azure Policy 要求 Azure SQL 仅使用 Entra 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-policy-how-to?view=azuresql
使用 Azure Policy 对 Azure SQL 强制实施仅限 Entra 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-policy?view=azuresql
为现有 Azure SQL 资源启用仅限 Entra 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-tutorial?view=azuresql
为 Azure SQL 启用仅限 Microsoft Entra 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication?view=azuresql
为 Azure SQL 访问配置托管标识	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql
使用 Microsoft Entra 身份验证连接到 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-microsoft-entra-connect-to-azure-sql?view=azuresql
阻止 Azure SQL 资源保护中的 T-SQL CRUD 操作	https://learn.microsoft.com/en-us/azure/azure-sql/database/block-crud-tsql?view=azuresql
为 Azure SQL 配置条件访问策略	https://learn.microsoft.com/en-us/azure/azure-sql/database/conditional-access-configure?view=azuresql
使用 Azure SQL 的内置 Azure Policy 定义	https://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql
对 Azure SQL Database 应用安全最佳实践	https://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database?view=azuresql
使用 Azure Policy 合规性控制保护 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/security-controls-policy?view=azuresql
使用 Azure Key Vault 密钥配置 Azure SQL TDE	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-configure?view=azuresql
为 Azure SQL TDE 配置跨租户客户管理密钥	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-cross-tenant?view=azuresql
使用用户分配的托管标识处理 TDE 客户管理密钥	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-identity?view=azuresql
在 Azure SQL 中使用客户管理的 TDE 密钥	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview?view=azuresql
使用 Microsoft Entra 登录名保护 SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/aad-security-configure-tutorial?view=azuresql
在 Azure SQL Managed Instance 上配置 SQL Server Audit	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing?view=azuresql
使用用户分配的标识创建 Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/authentication-azure-ad-user-assigned-managed-identity-create-managed-instance?view=azuresql
了解 Azure SQL Managed Instance 的内部连接测试	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connectivity-testing-overview?view=azuresql
为 Azure SQL Managed Instance 配置登录名和用户权限	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/logins-create-manage?view=azuresql
将 SQL Server Windows 用户迁移到 SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/migrate-sql-server-users-to-instance-transact-sql-tsql-tutorial?view=azuresql
为 Azure SQL Managed Instance 配置最低 TLS 版本	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/minimal-tls-version-configure?view=azuresql
在 SQL Managed Instance 中使用本机 Windows 主体	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/native-windows-principals?view=azuresql
为 Azure SQL Managed Instance 设置 Private Link 和专用终结点	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/private-endpoint-overview?view=azuresql
保护 Azure SQL Managed Instance 的公共终结点	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-overview?view=azuresql
使用 PowerShell 配置带客户管理密钥的 TDE	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-powershell?view=azuresql
使用 CLI 启用带客户管理密钥的 TDE	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-sql-managed-instance-cli?view=azuresql
Azure SQL Managed Instance 安全配置指南	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/secure-managed-instance?view=azuresql
为 SQL Managed Instance 配置服务器信任组	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/server-trust-group-overview?view=azuresql
为 Managed Instance 配置 Azure Storage 服务终结点策略	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-endpoint-policies-configure?view=azuresql
将 TDE 证书从 SQL Server 迁移到 Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tde-certificate-migrate?view=azuresql
为 Azure SQL Managed Instance 配置高级威胁防护	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/threat-detection-configure?view=azuresql
为 Entra Windows 身份验证配置 SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-kerberos-managed-instance?view=azuresql
为 SQL MI 配置 Entra Windows 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-overview?view=azuresql
为 Azure SQL MI 设置 Entra ID Windows 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-incoming-trust-based-flow?view=azuresql
为 SQL MI 配置新式交互式 Windows 身份验证流程	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-modern-interactive-flow?view=azuresql
为 SQL Managed Instance 设置 Windows 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup?view=azuresql
了解基于 Kerberos 的 SQL Managed Instance Windows 身份验证	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-implementation-aad-kerberos?view=azuresql
为 Azure SQL TLS 根证书轮换做好准备	https://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql

配置

主题	URL
使用数据库监视器配置 Azure SQL 监控数据警报	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-alerts?view=azuresql
了解 Azure SQL 数据库监视器数据集和架构	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-data?view=azuresql
配置 Azure SQL 数据库监视器设置	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-manage?view=azuresql
为 Azure SQL 配置 Intelligent Insights 性能监控	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql
使用 Azure SQL 的 Intelligent Insights 诊断日志	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log?view=azuresql
为 Azure SQL 数据库配置长期备份保留	https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql
为 Azure SQL 配置指标和诊断日志流式传输	https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql
安全修改 Azure SQL 数据库配置设置	https://learn.microsoft.com/en-us/azure/azure-sql/database/modifiable-configuration-reference?view=azuresql
Azure SQL 数据库监控指标和日志参考	https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
使用 ring_buffer 配置 Azure SQL XEvent 会话	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-ring-buffer?view=azuresql
配置 Azure SQL 中扩展事件的差异	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-db-diff-from-svr?view=azuresql
为 Azure SQL 工作负载配置维护时段	https://learn.microsoft.com/en-us/azure/azure-sql/maintenance-window-azure-sql?view=azuresql
为 SQL Managed Instance 配置高级维护通知	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/advance-notifications?view=azuresql
创建和配置 SQL Managed Instance 的 API 选项	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/api-references-create-manage-instance?view=azuresql
使用 ARM 模板部署 SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/arm-templates-content-guide?view=azuresql
Azure SQL Managed Instance 的 T-SQL 审核配置	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure?view=azuresql
更改 Azure SQL Managed Instance 的自动备份保留和冗余设置	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-change-settings?view=azuresql
了解 SQL MI 中的自动备份和异地冗余备份	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql
使用 SQL MI 中的备份透明度查看备份历史记录	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-transparency?view=azuresql
配置 Azure VM 与 SQL Managed Instance 的连接	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-vm-instance-configure?view=azuresql
配置 Azure SQL Managed Instance 终结点的连接类型	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connection-types-overview?view=azuresql
为 Azure SQL Managed Instance 配置故障转移组	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-configure-sql-mi?view=azuresql
配置 Azure SQL Managed Instance 池	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-pools-configure?view=azuresql
为 Azure SQL Managed Instance 配置区域冗余	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-zone-redundancy-configure?view=azuresql
为 Azure SQL Managed Instance 配置维护时段	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-configure?view=azuresql
了解 SQL Managed Instance 中维护时段的行为	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window?view=azuresql
为 Azure SQL Managed Instance 链接准备环境	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-preparation?view=azuresql
监控 Azure SQL Managed Instance 管理操作	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-monitor?view=azuresql
Azure SQL Managed Instance 可修改设置参考	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/modifiable-configuration-reference?view=azuresql
SQL Managed Instance 的 Azure Monitor 指标参考	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql
使用 Azure Monitor 配置 Azure SQL Managed Instance 监控	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor?view=azuresql
在 Azure SQL Managed Instance 上执行数据库时间点还原	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-in-time-restore?view=azuresql
设置与 SQL Managed Instance 的点到站点连接	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-to-site-p2s-configure?view=azuresql
为 Azure SQL Managed Instance 配置公共终结点	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-configure?view=azuresql
从 Azure SQL Managed Instance 上的备份还原数据库	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/recovery-using-backups?view=azuresql
为 Azure SQL Managed Instance 配置专用域名解析	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resolve-private-domain-names?view=azuresql
使用 PowerShell 将 SQL Managed Instance 添加到故障转移组	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/add-to-failover-group-powershell?view=azuresql
使用 CLI 创建 SQL Managed Instance 并配置网络	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure-managed-instance-cli?view=azuresql
使用 PowerShell 创建 SQL Managed Instance 并配置网络	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure-managed-instance-powershell?view=azuresql
从异地备份还原 Azure SQL Managed Instance 数据库	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/restore-geo-backup?view=azuresql
为 Managed Instance 启用服务辅助子网配置	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/subnet-service-aided-configuration-enable?view=azuresql
为 Azure SQL Managed Instance 配置 tempdb 设置	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tempdb-configure?view=azuresql
配置 Azure SQL Managed Instance 中的时区行为	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/timezones-overview?view=azuresql
为 Azure SQL Managed Instance 配置更新策略	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/update-policy?view=azuresql
使用手动故障转移重启 Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/user-initiated-failover?view=azuresql
为 Managed Instance 链接配置 WSFC 和 Always On	https://learn.microsoft.com/en-us/previous-versions/azure/azure-sql/managed-instance/managed-instance-link-preparation-wsfc?view=azuresql

集成与编码模式

主题	URL
在所有操作系统上从 .NET 连接到 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-core?view=azuresql
使用 Visual Studio .NET 查询 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-visual-studio?view=azuresql
使用 Go 和 go-mssqldb 连接到 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-go?view=azuresql
使用 JDBC 将 Java 应用程序连接到 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-java?view=azuresql
使用 Node.js 连接并查询 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-nodejs?view=azuresql
使用 PHP 连接并查询 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-php?view=azuresql
使用 Python 连接并查询 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql
配置并使用 Azure SQL 的 Spark 连接器	https://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql
使用 event_file 创建 Azure SQL XEvent 会话	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-event-file?view=azuresql
使用 bcp 将 CSV 数据导入 Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/load-from-csv-with-bcp?view=azuresql
使用 Azure Automation 大规模管理 SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automation-manage?view=azuresql
在各种网络中将应用程序连接到 Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-application-instance?view=azuresql
在 SQL Managed Instance 中使用分布式事务协调器	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/distributed-transaction-coordinator-dtc?view=azuresql
在 SQL MI 上使用内存中 OLTP 和列存储示例	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-sample?view=azuresql
使用 T-SQL 和脚本配置 Managed Instance 链接	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-scripts?view=azuresql
使用 SSMS 配置 Managed Instance 链接	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-ssms?view=azuresql
使用 Managed Instance 链接扩展 Always On 可用性组	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-extend-availability-group?view=azuresql
使用 SQL Server 与 Azure SQL Managed Instance 之间的 Managed Instance 链接进行数据库故障转移	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-failover-how-to?view=azuresql
将 Azure SQL Managed Instance 备份还原到 SQL Server 2022 或 2025	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/restore-database-to-sql-server?view=azuresql
在 SQL Managed Instance 上使用 Windows 身份验证运行跟踪	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-run-trace-managed-instance?view=azuresql

部署

主题	URL
将 Azure SQL 数据库导出为 BACPAC 文件	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql
导入 BACPAC 文件以创建 Azure SQL 数据库	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?view=azuresql
按区域查看 Azure SQL 数据库功能的可用情况	https://learn.microsoft.com/en-us/azure/azure-sql/database/region-availability?view=azuresql
缩放 Azure SQL 数据库和托管实例资源	https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources?view=azuresql
停止和启动 Azure SQL 托管实例以控制成本	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql
使用托管实例链接设置灾难恢复	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-disaster-recovery?view=azuresql
将 Azure SQL 托管实例移至其他区域	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/move-resources-across-regions?view=azuresql
按区域查看 Azure SQL 托管实例功能的可用情况	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/region-availability?view=azuresql
配置 SQL 托管实例之间的事务复制	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-between-two-instances-configure-tutorial?view=azuresql
设置 SQL 托管实例与 SQL Server 之间的复制	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-two-instances-and-sql-server-configure-tutorial?view=azuresql
为 Azure SQL 托管实例部署创建虚拟网络	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/virtual-network-subnet-create-arm-template?view=azuresql
为 Azure SQL 托管实例配置现有虚拟网络	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-existing-add-subnet?view=azuresql
以最短停机时间在子网之间移动 Azure SQL 托管实例	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-move-instance?view=azuresql