Skip to main content

assessed_sql_database_v2_operations

Creates, updates, deletes, gets or lists an assessed_sql_database_v2_operations resource.

Overview​

Nameassessed_sql_database_v2_operations
TypeResource
Idazure.migration_assessment.assessed_sql_database_v2_operations

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long
namestringThe name of the resource.
assessedSqlInstanceArmIdstringAssessed SQL instance arm id.
azureSqlDBSuitabilityDetailsobjectGets or sets the azure SQL DB suitability details.
azureSqlMISuitabilityDetailsobjectGets or sets the azure SQL MI suitability details.
bufferCacheSizeInMBnumberGets or sets the aggregated cache size of this database. This is a performance data metric for this DB.
compatibilityLevelstringDatabase compatibility level. Known values are: "Unknown", "CompatLevel80", "CompatLevel90", "CompatLevel100", "CompatLevel110", "CompatLevel120", "CompatLevel130", "CompatLevel140", and "CompatLevel150".
confidenceRatingInPercentagenumberConfidence Rating in Percentage.
createdTimestampstring (date-time)When was assessed SQL database first created.
databaseNamestringSQL database name.
databaseSizeInMBnumberSQL database size in megabytes.
instanceNamestringSQL instance name.
isDatabaseHighlyAvailablebooleanGets a value indicating whether the assessed SQL database is highly available or not.
linkedAvailabilityGroupOverviewobjectGets the linked availability group overview if the database being assessed is highly available.
machineArmIdstringMachine arm id.
machineNamestringMachine display name.
megabytesPerSecondOfReadnumberThe read throughput of the SQL database.
megabytesPerSecondOfWritenumberThe write throughput of the SQL database.
numberOfReadOperationsPerSecondnumberThe read operations per second of the SQL database.
numberOfWriteOperationsPerSecondnumberThe write operations per second of the SQL database.
percentageCoresUtilizationnumberThe percentage of the total number of cores being utilized by the SQL database.
productSupportStatusobjectGets the product support status related details.
recommendedAzureSqlTargetTypestringGets or sets the recommended azure SQL target type. Known values are: "Unknown", "Recommended", "AzureSqlDatabase", "AzureSqlManagedInstance", "AzureSqlVirtualMachine", and "AzureVirtualMachine".
recommendedSuitabilitystringGets or sets the recommended azure SQL suitability. Known values are: "Unknown", "SuitableForSqlDB", "SuitableForSqlMI", "SuitableForVM", "PotentiallySuitableForVM", "ReadinessUnknown", "NotSuitable", "SuitableForSqlVM", "ConditionallySuitableForSqlDB", "ConditionallySuitableForSqlMI", "ConditionallySuitableForVM", and "ConditionallySuitableForSqlVM".
sizingCriterionstringAssessment sizing criterion. Known values are: "PerformanceBased" and "AsOnPremises".
sqlDatabaseSdsArmIdstringSQL database SDS arm id.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
updatedTimestampstring (date-time)When was assessed SQL database last updated.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, project_name, group_name, assessment_name, assessed_sql_database_name, subscription_idGet a AssessedSqlDatabaseV2.
list_by_sql_assessment_v2selectresource_group_name, project_name, group_name, assessment_name, subscription_id$filter, pageSize, continuationToken, totalRecordCountList AssessedSqlDatabaseV2 resources by SqlAssessmentV2.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
assessed_sql_database_namestringSql assessment Assessed Databases ARM name. Required.
assessment_namestringSQL Assessment arm name. Required.
group_namestringGroup ARM name. Required.
project_namestringAssessment Project Name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
$filterstringFilter query. Default value is None.
continuationTokenstringOptional parameter for continuation token. Default value is None.
pageSizeintegerOptional parameter for page size. Default value is None.
totalRecordCountintegerTotal record count. Default value is None.

SELECT examples​

Get a AssessedSqlDatabaseV2.

SELECT
id,
name,
assessedSqlInstanceArmId,
azureSqlDBSuitabilityDetails,
azureSqlMISuitabilityDetails,
bufferCacheSizeInMB,
compatibilityLevel,
confidenceRatingInPercentage,
createdTimestamp,
databaseName,
databaseSizeInMB,
instanceName,
isDatabaseHighlyAvailable,
linkedAvailabilityGroupOverview,
machineArmId,
machineName,
megabytesPerSecondOfRead,
megabytesPerSecondOfWrite,
numberOfReadOperationsPerSecond,
numberOfWriteOperationsPerSecond,
percentageCoresUtilization,
productSupportStatus,
recommendedAzureSqlTargetType,
recommendedSuitability,
sizingCriterion,
sqlDatabaseSdsArmId,
systemData,
type,
updatedTimestamp
FROM azure.migration_assessment.assessed_sql_database_v2_operations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND group_name = '{{ group_name }}' -- required
AND assessment_name = '{{ assessment_name }}' -- required
AND assessed_sql_database_name = '{{ assessed_sql_database_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;