Is there a way to turn off the SQL Server trace?
The "Deadlock Data" collection executes a SQL Trace as a part of our normal collections. The stored procedure sp_trace_getdata is used by SQL profiler to its trace and return the results to the application.
Beginning in the 5.9.4.20 and higher SQL Server cartridges, the deadlock collection has primarily changed to use Extended Events rather than SQL traces. The ability to use SQL Traces still remains in the cartridge as a fallback collection and to maintain compatibility for SQL Server 2008.
RESOLUTION 1
Disable the Deadlock Data collection through the following
RESOLUTION 2
Upgrade the SQL Server cartridge to 5.9.4.20 or higher to use the Extended Events as the primary means to collect Deadlock data.
If the user doesn’t go to the dashboard then the trace would sit in the background having very minimal impact.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center