Kueri untuk tabel ApiManagementGatewayLogs

Jumlah permintaan

Hitung jumlah total panggilan di semua API dalam 24 jam terakhir.

//Total number of call per resource
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize count(CorrelationId) by _ResourceId 

Log dari 100 panggilan terakhir

Dapatkan log dari 100 panggilan terbaru dalam 24 jam terakhir.

ApiManagementGatewayLogs
| top 100 by TimeGenerated desc 

Jumlah panggilan menurut API

Lihat jumlah panggilan per API dalam 24 jam terakhir.

//Calls by API ID
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize count(CorrelationId) by ApiId

Bandwidth yang digunakan

Total bandwidth yang digunakan dalam 24 jam terakhir.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| extend bandwidth = RequestSize + ResponseSize 
| summarize sum(bandwidth) by bin(TimeGenerated, 15m), _ResourceId 
| render timechart 

Ukuran permintaan

Statistik ukuran permintaan dalam 24 jam terakhir.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize Average=avg(RequestSize), Median=percentile(RequestSize, 50), 90th_Percentile=percentile(RequestSize, 90) by bin(TimeGenerated, 5m) 
| render timechart 

Ukuran respons

Statistik ukuran respons dalam 24 jam terakhir.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize Average=avg(ResponseSize), Median=percentile(ResponseSize, 50), 90th_Percentile=percentile(ResponseSize, 90) by bin(TimeGenerated, 5m) 
| render timechart 

Versi TLS klien

Perincian versi TLS klien dalam 24 jam terakhir.

ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize count(CorrelationId) by ClientTlsVersion, _ResourceId 

Perincian alasan kesalahan

Perincian semua alasan kesalahan dalam 24 jam terakhir.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| where IsRequestSuccess == false
| summarize count(CorrelationId) by LastErrorReason, _ResourceId

100 permintaan terakhir yang gagal

Dapatkan log dari 100 permintaan terakhir yang gagal.

ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| where IsRequestSuccess == false
| top 100 by TimeGenerated desc| where ResponseCode >= 400

Mendapatkan permintaan yang gagal karena masalah yang terkait dengan backend

Dapatkan log permintaan yang gagal karena masalah backend.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| where IsRequestSuccess == false
| where BackendResponseCode >= 400

Mendapatkan permintaan yang gagal karena masalah yang tidak terkait dengan backend

Dapatkan log permintaan yang gagal karena masalah yang tidak terkait dengan backend (misalnya, konfigurasi kebijakan API Mangement, batas tarif terlampaui, pemutusan sambungan klien).

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| where IsRequestSuccess == false
| where isnull(BackendResponseCode) or BackendResponseCode < 400
| where ResponseCode >= 400

Latensi keseluruhan

Statistik latensi keseluruhan (dalam milidetik) antara waktu API Mangement mulai menerima permintaan dan waktu API Management selesai mengirim respons kembali ke klien.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize Average=avg(TotalTime), Median=percentile(TotalTime, 50), 90th_Percentile=percentile(TotalTime, 90) by bin(TimeGenerated, 15m) 
| render timechart 

Latensi backend

Statistik waktu (dalam milidetik) dihabiskan di IO backend.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize Average=avg(BackendTime), Median=percentile(BackendTime, 50), 90th_Percentile=percentile(BackendTime, 90) by bin(TimeGenerated, 15m) 
| render timechart 

Latensi klien

Statistik waktu (dalam milidetik) yang dihabiskan di IO klien.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize Average=avg(ClientTime), Median=percentile(ClientTime, 50), 90th_Percentile=percentile(ClientTime, 90) by bin(TimeGenerated, 15m) 
| render timechart 

Rasio hit cache

Statistik rasio hit/miss Cache.

// To create an alert for this query, click '+ New alert rule'
ApiManagementGatewayLogs
| where TimeGenerated > ago(1d)
| summarize Cache_Miss=countif(Cache  == "miss"), Cache_Hit=countif(Cache == "hit") by bin(TimeGenerated, 15m)
| extend Ratio=Cache_Hit / (Cache_Hit + Cache_Miss)
| project-away Cache_Hit , Cache_Miss 
| render timechart