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:
EXEC master.sys.sp_readerrorlog 0,1,'dbghelp'
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 :
~ Adios
Khan
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook |
Follow me on Twitter
We are on sql server 2008 R2 sp2 . Please let me know why we still see the above messages in our logs ? Does it have to to with any wrong install or upgrade ?
This is our version
Microsoft SQL Server 2008 R2 (SP2) – 10.50.4033.0 (X64) Jul 9 2014 16:04:25 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
Thank you,
Shruthi
Shruthi:
Looking into this again. Most of my clients had a clean sweep and did not see any errors once the patches kicked in. A few of them have still complained about SQL08. Let me follow up and update for 08 only.
As for your issue, per the version you have stated it seems that you have applied SP2 + kb2977320.
Per my post and as per MSFT release notes they had this issue addressed for 08R2 in Sp2 CU12
I would recommend moving to 08R2 — SP3 (10.53.6000) once tested in lower life cycles.
As it is always recommended with CU — test it before releasing it.
Hi, i tried update CU but didn’t work, you have another solution?
what version are you running Alexandre? and also do you have SharePoint running in the environment?
if you are still noticing the issue, i would suggest working with https://connect.microsoft.com/SQLServer and proceed to post your issue/concern.
Hi Khan, thanks for you answer
this error happens when I execute a select in a view in the MSSQL itself, and is not executed from an application.
We don’t use sharepoint here in our environment.
Below is the version of MSSQL:
Microsoft SQL Server 2008 R2 (SP2) – 10.50.4319.0 (X64) Jun 17 2014 18:50:01 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
Below is result for EXEC master.sys.sp_readerrorlog 0,1,’dbghelp’
2016-01-06 11:07:54.850 Server Using ‘dbghelp.dll’ version ‘4.0.5’
2016-01-06 11:07:54.860 Server * dbghelp 0000000064CD0000 0000000064E2DFFF 0015e000
2016-01-06 11:07:54.860 Server * dbghelp 0000000061ED0000 000000006202DFFF 0015e000