locked
DLL RRS feed

  • Question

  • Hi,

    SQL server crashes, during investigating we found out one dll created this problem. Right now multiple applications have dbs on that instance. How to find out for which application that dll is related to?

    Thanks

    Wednesday, December 19, 2012 9:29 PM

Answers

  • Hello,

    This really isn't a sql server question unless it's a clr dll. However you could use different sysinternals tools, most notably process explorer to find what is loading the dll. The other thing you could do is run an xperf and if you download the symbol files, could possibly walk the stack.

    -Sean


    Sean Gallardy | Blog | Twitter

    Thursday, December 20, 2012 2:09 AM
    Answerer

All replies

  • Hello,

    This really isn't a sql server question unless it's a clr dll. However you could use different sysinternals tools, most notably process explorer to find what is loading the dll. The other thing you could do is run an xperf and if you download the symbol files, could possibly walk the stack.

    -Sean


    Sean Gallardy | Blog | Twitter

    Thursday, December 20, 2012 2:09 AM
    Answerer
  • Possibly the DLL is loaded through an linked server or extended stored procedure. So check if there are any linked servers, if yes then check with the application team who is using the linked server
    Thursday, December 20, 2012 2:24 AM
  • Hi DBA_LEARNER,

    The crash should be logged with more information in SQL Server Event Logs which you can access easily from Management Studio. Have you checked that?

    Thursday, December 20, 2012 6:12 AM
  • DBA_Learner, Can you please share error in SQL Server Error logs & event logs?


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

    Thursday, December 20, 2012 6:57 AM