Fix SQL using ‘dbghelp.dll’ version ‘4.0.5’

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'

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

Khan

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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Avatar

About Arsalan Khan

People know me as 'Khan' ... nope not Shah Rukh's movie but Star Trek II - Wrath of Khan and since than 'Khan' it has been. Born and raised in Dubai before moving to US for my masters. Been blessed with solid 8+ yrs with SQL (and counting) and currently working for the biggest publishing house as Sr. Database Administrator. I have had an opportunity to speak about tips & tricks to write efficient tsql for Quest International Users Group (PeopleSoft). Love playing TT, badminton and thoroughly enjoy watching cricket when not occupied with my loving daughter. Expertise in DR, Performance Tuning, Troubleshooting and Problem Solving. With that being said I have finally decided to roll my sleeves up and give back to the community bit by bit. Finally.. as my wonderful wife puts it ... "if you don't have a smile, I will give you one of mine ~ Rabia Khan" ~Cheers

View all posts by Arsalan Khan →

5 Comments on “Fix SQL using ‘dbghelp.dll’ version ‘4.0.5’”

  1. 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

    1. 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.

  2. 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

Leave a Reply

Your email address will not be published. Required fields are marked *