Deadlock (Extended Events) not working

• 
  Can you send support the log files and the XE information from SQL Server please?

  Russell D March 05, 2019 11:07

  - 0 +
• 
  Hi, sure. Guess i should raise a support ticket.

  pingham1973 March 05, 2019 11:09

  - 0 +
• 
  Out of interest, what version of SQL is it that Monitor is not reporting XE deadlocks for?

  Russell D March 05, 2019 14:11

  - 0 +
• 
  2008 R2 SP3.

  pingham1973 March 05, 2019 14:48

  - 0 +
• 
  Do you have any 
  "Using 'dbghelp.dll' version 'x.x.x'" errors in your SQL Log?

  Russell D March 05, 2019 15:19

  - 0 +
• 
  there was one  a couple days ago version 4.0.5.

  pingham1973 March 05, 2019 15:47

  - 0 +
• 
  I think you've hit a bug in SQL Server: https://support.microsoft.com/en-us/help/2878139/fix-using-dbghelp-dll-version-4-0-5-error-is-logged-in-sql-server-2012. Unfortunately, this doesn't appear to have been fixed for SQL 2008, just 2012.
  

  
  

  Unfortunately we have no workaround/fix for this and can only really advise contacting Microsoft.
  

  
  

  Russell D March 06, 2019 09:33

  - 0 +

Add comment

Please sign in to leave a comment.