Sample Header Ad - 728x90

Capturing in-memory OLTP transaction aborted errors in SQL Server

1 vote
0 answers
80 views
In one of my SQL Server 2016 Enterprise instances, sp_BlitzFirst is reporting hundreds of aborted transactions per second in one of my in-memory OLTP databases. I've set up error logging with try/catch for all procedures in the DB but they've caught nothing yet. Similarly, an extended event set up to capture errors isn't showing anything related to aborted transactions. The sys.dm_xtp_transaction_stats and sys.dm_os_performance_counters DMVs only seem to provide a total number of transactions aborted but don't provide details regarding the procedure(s) causing the errors. It's probably an error related to the ones listed in this MS doc, but I have no way of knowing which one at the moment: https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/transactions-with-memory-optimized-tables?view=sql-server-ver15#conflict-detection-and-retry-logic Is there any way to capture this type of error?
Asked by Marcus (89 rep)
Jul 29, 2024, 01:18 PM
Last activity: Oct 15, 2024, 08:08 PM