![]() ![]() 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. On the SQL server instance level, grant the login both Alter any event session and View server state permissions.įor detailed steps on how to do this, see Giving the account necessary database privileges in SQL Server.On the database level, grant the login the View database state permission.In SQL Server Management Studio, connect to the SQL server instance for Business Central, and then grant the following permissions: You can do this using SQL Server Management Studio. To configure the SQL Server instance to log deadlocks, you must assign specific permissions to the database login for the service account that is used on the Business Central Server instance. Note: If you installed the Business Central Server and database components by using the Install Demo option in the Business Central Setup, then deadlock logging is set up by default. Setting up deadlock logging requires you to configure the SQL Server instance and the Business Central Server instance. ![]() SQL Server handles deadlocks by terminating and rolling back transactions that were started after the first transaction.įor general information about deadlocks, see Detecting and Ending Deadlocks. A deadlock occurs when two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs. About Deadlocksĭeadlocks can prevent users from completing tasks in the Business Central client. This information can help you identify and resolve problem areas in the application design. The log entries provide information about the AL code that was run when the deadlock occurred, along with the deadlock report from SQL Server. The deadlocks are recorded in the Windows Event Log of computer running Business Central Server. You can set up the system to log deadlocks that occur in the SQL database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |