Recently we completed our cycle of ‘Patching SQL Server’ and that created a perfect opportunity for me to write a short article. If your applications / sproc use Extended Events then you would have noticed your errorlogs swelling (using ‘dbghelp.dll’ version ‘4.0.5’)

You can perform a quick search of your errorlogs:

dbghelp.dll output

Error Message: using ‘dbghelp.dll’ version ‘4.0.5’

Cause: Every time sys.fn_xefile_target_readfile() is called. Refer to KB2878139

(In our case we use 3rd party monitoring tool Spotlight (ver10.5) and it absolutely swamped our error logs. Organizations using SharePoint 2013 have reported this issue as well.)

Fix :

  • SQL 2012 – Fixed in SP1 CU6
  • SQL 2008r2 – Fixed in SP2 CU12

~ Adios


Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook |
Follow me on Twitter