July 5, 2016
When you enable deadlock data collection and DPA begins monitoring a SQL Server database instance, it creates an Extended Events Session with a Ring Buffer target. The session is named
dpa_deadlock_capture. When DPA creates the session, the value of the
DEADLOCK_POLL_SQL_SERVER_DEFAULT_SESSION_MAX_MEMORY_KB option in DPA is set as the
max memory attribute of the created session and of its target.
If you adjust the
DEADLOCK_POLL_SQL_SERVER_DEFAULT_SESSION_MAX_MEMORY_KB option after the Extended Events Session
dpa_deadlock_capture was created, you must perform the steps below in order for the updated
max memory option to take effect.
DROP EVENT SESSION [dpa_deadlock_capture] ON SERVER
You must enable deadlock data collection on the monitored database instance in order for DPA to create the
dpa_deadlock_capture session. DPA will create the session only if the
DEADLOCK_POLL_SQL_SERVER_SESSION_NAME option is set to its default value of