Bilješka
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati da se prijavite ili promijenite direktorije.
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati promijeniti direktorije.
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Transactions and multixacts health
Get current snapshot of the remaining transactions and multixacts for each database.
// 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
Transactions and multixacts health
Get current snapshot of the remaining transactions and multixacts for each database.
// 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