Small and medium business | Business Central, N...

Monitor Database deadlock

(0) Share

Report

Posted on by Cyrille56

Hello,

For an On-premise BC14 environment, we have set up dead-lock monitoring as described in the following procedure:

docs.microsoft.com/.../monitor-database-deadlocks

I have checked all the prerequisites but still no events are logged in the Windows Event Viewer
-SQL rights for the BC service account: OK
-Extended event session active: OK
Deadlocks are logged
-Deadlock_report_event_file_view contains data: OK
-Enable Deadlock Monitoring" setting on NSTs: OK

Does anyone have an idea of what is causing the problem?

Thank you in advance

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

Are you stating that sql monitor shows deadlocks but Windows event log file does not capture it?

Thanks.

Was this reply helpful? Yes No
Cyrille56 49 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Yes, I confirm that SQL Server records each dead-locks events in the deadlock_monitor xevents session.

Best regards,

Cyrille

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,322 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Sorry I don't remember too clearly, is there a feature below in BC14?

Viewing Database Locks:

https://docs.microsoft.com/en-us/dynamics365/business-central/admin-view-database-locks

Was this reply helpful? Yes No