I am encountering a deadlock issue in my web application and tracing where it came from. I installed a dbForge Event Profiler for SQL Server to help me find out what's causing it but i not sure why is always return "Unable to retrieve SQL text".
Does anyone know what does it mean or what do I need to do to trace what stored procedure or table causing the deadlock.
Thanks
Unable to retrieve SQL text in Event Profiler
Re: Unable to retrieve SQL text in Event Profiler
Our product dbForge Event Profiler for SQL Server is built basing on the method SQL Server Extended Events https://docs.microsoft.com/en-us/sql/re ... erver-2017
The problem you described was already discussed on the Microsoft's forum and there is still no resolution suggested https://social.msdn.microsoft.com/Forum ... baseengine .
There is also mentioned on that forum that such a problem is not present in case of using the method SQL Trace https://docs.microsoft.com/en-us/sql/re ... erver-2017 .
In case your database supports this method, you can try using the software based on SQL Trace.
The problem you described was already discussed on the Microsoft's forum and there is still no resolution suggested https://social.msdn.microsoft.com/Forum ... baseengine .
There is also mentioned on that forum that such a problem is not present in case of using the method SQL Trace https://docs.microsoft.com/en-us/sql/re ... erver-2017 .
In case your database supports this method, you can try using the software based on SQL Trace.