Database server - Azure SQL Managed Instance

Edit online

Azure SQL Managed Instance is a scalable cloud database service with an underlying infrastructure managed by Microsoft. Turbonomic discovers SQL Managed Instances through your Azure targets, and represents them as database server entities in the supply chain.

Database Server in the Supply Chain
Note:

Currently, SQL Managed Instances in Azure Government subscriptions are not supported.

Monitored resources

Note:

Configure Azure database watcher to enable the discovery of metrics for vMem, maximum concurrent sessions, maximum concurrent workers, and DB cache hit rate.

Turbonomic monitors the following resources:

  • Virtual CPU (vCPU)

    Virtual CPU is the measurement of CPU that is in use.

  • Virtual memory (vMem)

    Virtual memory (vMem) is the measurement of memory that is in use.

  • Storage amount

    Storage amount is the measurement of storage capacity that is in use.

  • Storage access (IOPS)

    Storage access, also known as IOPS, is the per-second measurement of read and write access operations on a storage entity.

    Note:

    Due to an Azure limitation, Turbonomic discovers IOPS for the Next-gen General Purpose and Business Critical service tiers only.

  • Maximum concurrent sessions

    Maximum concurrent sessions is the maximum number of database connections at a time.

  • Maximum concurrent workers

    Maximum concurrent workers is the maximum number of database processes that can handle queries at a time.

  • DB cache hit rate

    DB cache hit rate is the measurement of Database Server accesses that result in cache hits, measured as a percentage of hits versus total attempts. A high cache hit rate indicates efficiency.

Actions

Turbonomic supports the following actions:

  • Scale

    Change the Managed Instance to use a different instance type or tier to optimize performance and costs.

    For details, see Scale actions for SQL Managed Instances.

  • Stop and start (also known as 'parking' actions)

    For an idle SQL Managed Instance, stop the instance temporarily as a cost-saving measure, and then start it at a later time.

    For details, see Park: stop or start cloud resources.