有关在 Azure 门户中使用这些查询的信息,请参阅 Log Analytics 教程。 有关 REST API,请参阅查询。
事务和多路处理运行状况
获取每个数据库的剩余事务和多事务的当前快照。
// If required to get the snapshot on a certain date and time just filter on TimeGenerated column, like:
// where TimeGenerated between (datetime('2023-03-01 16:00') .. datetime('2023-03-01 19:00'))
PGSQLDbTransactionsStats
| summarize arg_max(TimeGenerated,TransactionIdFrozen,TransactionIdFrozenAge,RemainingTransactionIds, RemainingTransactionIdsTillEmergencyAV,RemainingTransactionIdsTillWraparound,MinMultixactId, MinMultixactIdAge,RemainingMultixactIds, RemainingMultixactIdsTillEmergencyAV, RemainingMultixactIdsTillWraparound ) by DatabaseName