I have a requirement to kill the active sessions currently running on Azure Analysis Services which are consuming high QPU and are running for more than 5 minutes.
I came across below article : which does similar thing and it's a manual process but I need help in understanding how can I setup an automated process which can proactively identify and kill such connections.
Appreciate any leads.
How to Kill sessions running for last 5 minutes automatically in azure analysis services?
To make it work automatically, you can use either PowerShell or log analytics Kql query which is detailed below.
Disconnect sessions MS Doc.
PowerShell:
$subscription = "xxx"
$resourceGroup = "xxxx"
$serverName = "asazure://eastus.asazure.windows.net/newsj"
$uri = "https://management.azure.com/subscriptions/$subscription/resourceGroups/$resourceGroup/providers/Microsoft.AnalysisServices/servers/$serverName/sessions/$sessionId/disconnect?api-version=2017-07-14"
Invoke-RestMethod -Uri $uri -Method Post -Headers @{Authorization = "Bearer $token"}
KQL: (Log analytics workspace)
Sample query for your requirement looks like below:
AzureMetrics
| where Resource == "newsj"
| where MetricName == "xxx"
| summarize startat = min(TimeGenerated), timespan = max(xxx) by resourceID
