Monitor Azure Data Factory Integration Runtime using PowerShell

We have already discussed Azure Data Factory Integration Runtimes in a previous post. In this post, we are going to discuss ways to monitor the performance of the Integration runtimes.

The PowerShell command below can be used to get performance stats for Integration runtimes:

Get-AzDataFactoryV2IntegrationRuntime -DataFactoryName ADEDataFactory -ResourceGroupName ADEResourceGroup -Name ADEAzureIR -Status

The Get-AzDataFactoryV2IntegrationRuntime cmdlet returns the current status of the Integration runtime along with some other properties. Sample output for Azure Integration Runtime is shown below:

PropertyDescription
NameName of the Azure integration runtime.
StateStatus of the Azure integration runtime.
LocationLocation of the Azure integration runtime.  
DataFactoryNameName of the data factory that the Azure integration runtime belongs to.
ResourceGroupNameName of the resource group that the data factory belongs to.
DescriptionDescription of the integration runtime

The Status property can have the following values:

Online: This indicates that the Integration Runtime is online and ready to be used

Offline: The integration runtime is offline due to internal error.

For detailed properties returned by Get-AzDataFactoryV2IntegrationRuntime cmdlet for Self-hosted integration runtime and Azure-SSIS integration runtime, please refer to the reference link below this post.

Azure-SSIS integration runtime can also be monitored using Azure Portal.

Reference: https://docs.microsoft.com/en-us/azure/data-factory/monitor-integration-runtime

2 thoughts on “Monitor Azure Data Factory Integration Runtime using PowerShell

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: