11/11/2022 0 Comments Deadlock sqlAn important difference between the ring_buffer target and event_file target is that the ring_buffer target has a storage size limitation of 5MB, while the event_file target provides a much greater storage capacity. You have the option to also store the events to a file on the SQL Server, called an event_file target, and configure the Business Central Server to read from this file instead of the ring_buffer target. When the Business Central Server is notified about the deadlock, it reads data from the target ring_buffer target. Configure where to store deadlock eventsīy default, SQL Server uses an in-memory data structure called a ring_buffer target to store deadlock events. The next time a client session is established with the database, a session for monitoring the Business Central database appears under Management, Extended Events. #Deadlock sql how to#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |