none
Help me to get symbols for SQL Server - I really need them! RRS feed

  • Question

  • Hi,

    I am using Xperf and the latest Windows Performance Analyzer to troubleshoot high kernel CPU of sqlservr.exe process. It seems that symbols for that sql server version are not yet available. (I use default symbol path "srv*C:\symbols*http://msdl.microsoft.com/download/symbols"). Can somebody help me to get it? I really need it. Without it I feel like blindfolded troubleshooting.

    It is SQL Server 2008 SP3 Enterprise 64bit (10.0.5500).

    The error in WPA log when it tries to download the symbols for it is:

    SYMSRV:  File: sqlservr.pdb

     

    SYMSRV:  Get File Path: /download/symbols/sqlservr.pdb/678DC91AA5984341BCBCBF7A340D60872/sqlservr.pdb

     

    SYMSRV:  Notifies the client application that a proxy has been detected.

    SYMSRV:  Connecting to the Server: http://msdl.microsoft.com/download/symbols.

    SYMSRV:  Successfully connected to the Server.

    SYMSRV:  Sending the information request to the server.

    SYMSRV:  Successfully sent the information request to the server.

    SYMSRV:  Waiting for the server to respond to a request.

    SYMSRV:  Successfully received a response from the server.

    SYMSRV:  Closing the connection to the Server.

    SYMSRV:  Successfully closed the connection to the Server.

    SYMSRV:  Notifies the client application that a proxy has been detected.

    SYMSRV:  Connecting to the Server: http://msdl.microsoft.com/download/symbols.

    SYMSRV:  Successfully connected to the Server.

    SYMSRV:  Sending the information request to the server.

    SYMSRV:  Successfully sent the information request to the server.

    SYMSRV:  Waiting for the server to respond to a request.

    SYMSRV:  Successfully received a response from the server.

    SYMSRV:  Closing the connection to the Server.

    SYMSRV:  Successfully closed the connection to the Server.

    SYMSRV:  Get File Path: /download/symbols/sqlservr.pdb/678DC91AA5984341BCBCBF7A340D60872/file.ptr

     

    SYMSRV:  Notifies the client application that a proxy has been detected.

    SYMSRV:  Connecting to the Server: http://msdl.microsoft.com/download/symbols.

    SYMSRV:  Successfully connected to the Server.

    SYMSRV:  Sending the information request to the server.

    SYMSRV:  Successfully sent the information request to the server.

    SYMSRV:  Waiting for the server to respond to a request.

    SYMSRV:  Successfully received a response from the server.

    SYMSRV:  Closing the connection to the Server.

    SYMSRV:  Successfully closed the connection to the Server.

    SYMSRV:  C:\Symbols\sqlservr.pdb\678DC91AA5984341BCBCBF7A340D60872\sqlservr.pdb not found

    SYMSRV:  http://msdl.microsoft.com/download/symbols/sqlservr.pdb/678DC91AA5984341BCBCBF7A340D60872/sqlservr.pdb not found

    Symbols for other dlls, exes, and even other versions of sql server (e.g. SQL 2014 RTM) I could download without any problems, but not this one, the most important one.

    Please help, especially Microsoft people who have access to all pdbs. I would really appreciate it.

    Xperf is a really nice tool and it would be a pity not to be able to use it.

    Thursday, May 22, 2014 10:05 PM

Answers

  • Debugging symbols for that build of sqlservr.exe are now available and indexed in the public symbols server. Thanks for reporting it!

    SQL Server Escalation Engineer

    Monday, June 2, 2014 11:23 PM
  • Since nobody answers, I will have to ;)

    There is a connect item about this: https://connect.microsoft.com/SQLServer/feedback/details/752128/debug-symbols-for-sql-server-2008-sp3-sqlservr-exe-10-0-5500-are-not-available-on-public-symbol-server

    Workaround is to install CU7 or CU16. For that versions (and maybe other CUs), the symbols are available for download.

    Monday, May 26, 2014 8:31 PM

All replies

  • Since nobody answers, I will have to ;)

    There is a connect item about this: https://connect.microsoft.com/SQLServer/feedback/details/752128/debug-symbols-for-sql-server-2008-sp3-sqlservr-exe-10-0-5500-are-not-available-on-public-symbol-server

    Workaround is to install CU7 or CU16. For that versions (and maybe other CUs), the symbols are available for download.

    Monday, May 26, 2014 8:31 PM
  • Debugging symbols for that build of sqlservr.exe are now available and indexed in the public symbols server. Thanks for reporting it!

    SQL Server Escalation Engineer

    Monday, June 2, 2014 11:23 PM
  • Thank you very much!
    Wednesday, June 4, 2014 7:35 AM