SQL Managed Instance How-tos series

Published Aug 13 2021 02:43 AM 8,622 Views
Microsoft

sqlmi-how-tos.pngWe started a series on simple & extremely useful how-tos, and this blog post serves as a principal source of accumulation and reference for it.

The idea behind this series is to serve as a good, high quality reference and to deliver a quick building block for anyone building their scripts library or even doing some automation.
We are primary focusing on the most common tasks, with the first group of posts focusing on the SQL Managed Instance Service Discovery, but with the time more functional and more advanced topics will be landing in this series soon.

You can find and reference the whole series with the following link http://aka.ms/sqlmi-howto which will lead you precisely to this very post.

 

The how-tos themselves will be grouped below according to the functionality, such as Service Discovery, Quick-Fixes, Performance Optimization, between others, and not in the chronological order in which they are published.

 

Service Discovery:

Service Tier basic details SQL MI Service Tier details (Service tier, Hardware Generation)

Number of CPU vCoresSQL MI Number of CPU vCores (with different permission requirements)

Total amount of RAM - SQL MI total & available amounts of RAM

Reserved and Available Disk Space - SQL MI reserved and available Disk Space

 

High Availability:

The timestamp of the last failover - the timestamp of the last SQL MI failover

Failover Group configuration - SQL MI Failover Group configuration

HA Replicas DetailsSQL MI Failover Group and HA Replicas Details

Monitor Databases & Replicasmonitor SQL MI Failover Group & Replicas

 

Quick-Fixes:

Sync Agent Jobs and Logins in Failover Groups Sync Agent Jobs and Logins in Failover Groups


Performance:

Find out addressable Disk Space & Files NumberAddressable Disk Space & Files Number on General Purpose service tier

Discover database files space configurationsDiscover database files space configurations on Azure SQL MI 
Manage & measure database file autogrowth impactManage & measure database file autogrowth impact 

Improving data loading performance on General Purpose service tierImproving data loading performance on General Purpose service tier
Improving data loading performance on Business Critical service tier Improving data loading performance on Business Critical service tier

 

Connectivity:

Failover group connectivity between SQL Managed InstancesFailover group connectivity between primary and secondary SQL MIs

Test TCP connectivity from a SQL Managed InstanceTest TCP connectivity from a SQL Managed Instance

Business Continuity:

Restore across different SQL Managed instances when using TDE with Customer Managed KeysRestore across different SQL Managed instances when using TDE with Customer Managed Keys


As we progress with the new how-tos, this post will be constantly updated to keep with the up-to-date information on the newest additions.

 

2 Comments
Co-Authors
Version history
Last update:
‎Mar 29 2022 08:31 AM
Updated by: