![]() To enable deadlock logging by using the Business Central Server Administration tool, open the server instance for editing, and then select the Enable Deadlock Monitoring check box in the Database section.įor more information about how to use the Business Central Server Administration tool, see Business Central Server Administration Tool. You can enable deadlock logging by using the Business Central Server Administration tool or the Set-NAVServerConfiguration cmdlet in the Business Central Administration Shell. To log deadlocks, you must enable deadlock logging on the Business Central Server instance. Configure the Business Central Server instance You can delete the ring_buffer target if you like. Replace C:\logging\ with the path to the event file. In the Business Central database, create a view that has the name deadlock_report_event_file_view and uses the new event_file target.ĬREATE VIEW deadlock_report_event_file_view ASįROM sys.fn_xe_file_target_read_file ('C:\logging\*.xel', null, null, null) Replace C:\logging\mydeadlocks.xel with the path and file name that you want to store the data.įor more information see Alter an Extended Events Session and Targets for Extended Events in SQL Server. SET filename=N'C:\logging\mydeadlocks.xel',max_file_size=(10240)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |