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 for Government Standard 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 for Government Standard 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 for Government Standard 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 for Government Standard supports the following actions: