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

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.

May 22nd, 2014 6:09pm

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.

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2014 4:34pm

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.

May 26th, 2014 11:31pm

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.

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2014 11:31pm

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.

May 26th, 2014 11:31pm

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.

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2014 11:31pm

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.

May 26th, 2014 11:31pm

Debugging symbols for that build of sqlservr.exe are now available and indexed in the public symbols server. Thanks for reporting it!
Free Windows Admin Tool Kit Click here and download it now
June 2nd, 2014 7:27pm

Thank you very much!
June 4th, 2014 3:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics