Share via


AssessedSqlDatabaseV2 interface

Assessed SQL database web model class.

Extends

Properties

assessedSqlInstanceArmId

Assessed SQL instance arm id. NOTE: This property will not be serialized. It can only be populated by the server.

azureSqlDBSuitabilityDetails

Gets or sets the azure SQL DB suitability details. NOTE: This property will not be serialized. It can only be populated by the server.

azureSqlMISuitabilityDetails

Gets or sets the azure SQL MI suitability details. NOTE: This property will not be serialized. It can only be populated by the server.

bufferCacheSizeInMB

Gets or sets the aggregated cache size of this database. This is a performance data metric for this DB. NOTE: This property will not be serialized. It can only be populated by the server.

compatibilityLevel

Database compatibility level. NOTE: This property will not be serialized. It can only be populated by the server.

confidenceRatingInPercentage

Confidence Rating in Percentage. NOTE: This property will not be serialized. It can only be populated by the server.

createdTimestamp

When was assessed SQL database first created. NOTE: This property will not be serialized. It can only be populated by the server.

databaseName

SQL database name. NOTE: This property will not be serialized. It can only be populated by the server.

databaseSizeInMB

SQL database size in megabytes. NOTE: This property will not be serialized. It can only be populated by the server.

instanceName

SQL instance name. NOTE: This property will not be serialized. It can only be populated by the server.

isDatabaseHighlyAvailable

Gets a value indicating whether the assessed SQL database is highly available or not. NOTE: This property will not be serialized. It can only be populated by the server.

linkedAvailabilityGroupOverview

Gets the linked availability group overview if the database being assessed is highly available. NOTE: This property will not be serialized. It can only be populated by the server.

machineArmId

Machine arm id. NOTE: This property will not be serialized. It can only be populated by the server.

machineName

Machine display name. NOTE: This property will not be serialized. It can only be populated by the server.

megabytesPerSecondOfRead

The read throughput of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

megabytesPerSecondOfWrite

The write throughput of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

numberOfReadOperationsPerSecond

The read operations per second of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

numberOfWriteOperationsPerSecond

The write operations per second of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

percentageCoresUtilization

The percentage of the total number of cores being utilized by the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

productSupportStatus

Gets the product support status related details. NOTE: This property will not be serialized. It can only be populated by the server.

recommendedAzureSqlTargetType

Gets or sets the recommended azure SQL target type. NOTE: This property will not be serialized. It can only be populated by the server.

recommendedSuitability

Gets or sets the recommended azure SQL suitability. NOTE: This property will not be serialized. It can only be populated by the server.

sizingCriterion

Assessment sizing criterion. NOTE: This property will not be serialized. It can only be populated by the server.

sqlDatabaseSdsArmId

SQL database SDS arm id. NOTE: This property will not be serialized. It can only be populated by the server.

updatedTimestamp

When was assessed SQL database last updated. NOTE: This property will not be serialized. It can only be populated by the server.

Inherited Properties

id

Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} NOTE: This property will not be serialized. It can only be populated by the server.

name

The name of the resource NOTE: This property will not be serialized. It can only be populated by the server.

systemData

Azure Resource Manager metadata containing createdBy and modifiedBy information. NOTE: This property will not be serialized. It can only be populated by the server.

type

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" NOTE: This property will not be serialized. It can only be populated by the server.

Property Details

assessedSqlInstanceArmId

Assessed SQL instance arm id. NOTE: This property will not be serialized. It can only be populated by the server.

assessedSqlInstanceArmId?: string

Property Value

string

azureSqlDBSuitabilityDetails

Gets or sets the azure SQL DB suitability details. NOTE: This property will not be serialized. It can only be populated by the server.

azureSqlDBSuitabilityDetails?: SqlAssessmentV2PaasSuitabilityData

Property Value

azureSqlMISuitabilityDetails

Gets or sets the azure SQL MI suitability details. NOTE: This property will not be serialized. It can only be populated by the server.

azureSqlMISuitabilityDetails?: SqlAssessmentV2PaasSuitabilityData

Property Value

bufferCacheSizeInMB

Gets or sets the aggregated cache size of this database. This is a performance data metric for this DB. NOTE: This property will not be serialized. It can only be populated by the server.

bufferCacheSizeInMB?: number

Property Value

number

compatibilityLevel

Database compatibility level. NOTE: This property will not be serialized. It can only be populated by the server.

compatibilityLevel?: string

Property Value

string

confidenceRatingInPercentage

Confidence Rating in Percentage. NOTE: This property will not be serialized. It can only be populated by the server.

confidenceRatingInPercentage?: number

Property Value

number

createdTimestamp

When was assessed SQL database first created. NOTE: This property will not be serialized. It can only be populated by the server.

createdTimestamp?: Date

Property Value

Date

databaseName

SQL database name. NOTE: This property will not be serialized. It can only be populated by the server.

databaseName?: string

Property Value

string

databaseSizeInMB

SQL database size in megabytes. NOTE: This property will not be serialized. It can only be populated by the server.

databaseSizeInMB?: number

Property Value

number

instanceName

SQL instance name. NOTE: This property will not be serialized. It can only be populated by the server.

instanceName?: string

Property Value

string

isDatabaseHighlyAvailable

Gets a value indicating whether the assessed SQL database is highly available or not. NOTE: This property will not be serialized. It can only be populated by the server.

isDatabaseHighlyAvailable?: boolean

Property Value

boolean

linkedAvailabilityGroupOverview

Gets the linked availability group overview if the database being assessed is highly available. NOTE: This property will not be serialized. It can only be populated by the server.

linkedAvailabilityGroupOverview?: SqlAvailabilityGroupDataOverview

Property Value

machineArmId

Machine arm id. NOTE: This property will not be serialized. It can only be populated by the server.

machineArmId?: string

Property Value

string

machineName

Machine display name. NOTE: This property will not be serialized. It can only be populated by the server.

machineName?: string

Property Value

string

megabytesPerSecondOfRead

The read throughput of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

megabytesPerSecondOfRead?: number

Property Value

number

megabytesPerSecondOfWrite

The write throughput of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

megabytesPerSecondOfWrite?: number

Property Value

number

numberOfReadOperationsPerSecond

The read operations per second of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

numberOfReadOperationsPerSecond?: number

Property Value

number

numberOfWriteOperationsPerSecond

The write operations per second of the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

numberOfWriteOperationsPerSecond?: number

Property Value

number

percentageCoresUtilization

The percentage of the total number of cores being utilized by the SQL database. NOTE: This property will not be serialized. It can only be populated by the server.

percentageCoresUtilization?: number

Property Value

number

productSupportStatus

Gets the product support status related details. NOTE: This property will not be serialized. It can only be populated by the server.

productSupportStatus?: ProductSupportStatus

Property Value

recommendedAzureSqlTargetType

Gets or sets the recommended azure SQL target type. NOTE: This property will not be serialized. It can only be populated by the server.

recommendedAzureSqlTargetType?: string

Property Value

string

recommendedSuitability

Gets or sets the recommended azure SQL suitability. NOTE: This property will not be serialized. It can only be populated by the server.

recommendedSuitability?: string

Property Value

string

sizingCriterion

Assessment sizing criterion. NOTE: This property will not be serialized. It can only be populated by the server.

sizingCriterion?: string

Property Value

string

sqlDatabaseSdsArmId

SQL database SDS arm id. NOTE: This property will not be serialized. It can only be populated by the server.

sqlDatabaseSdsArmId?: string

Property Value

string

updatedTimestamp

When was assessed SQL database last updated. NOTE: This property will not be serialized. It can only be populated by the server.

updatedTimestamp?: Date

Property Value

Date

Inherited Property Details

id

Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} NOTE: This property will not be serialized. It can only be populated by the server.

id?: string

Property Value

string

Inherited From ProxyResource.id

name

The name of the resource NOTE: This property will not be serialized. It can only be populated by the server.

name?: string

Property Value

string

Inherited From ProxyResource.name

systemData

Azure Resource Manager metadata containing createdBy and modifiedBy information. NOTE: This property will not be serialized. It can only be populated by the server.

systemData?: SystemData

Property Value

Inherited From ProxyResource.systemData

type

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" NOTE: This property will not be serialized. It can only be populated by the server.

type?: string

Property Value

string

Inherited From ProxyResource.type