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)

Suggested answer

Marco Mels on at

Like (0)

Report

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

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 95,716 Super User 2025 Season 2 on at

Like (0)

Report

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