Debug-Symbols for SQL Server 2012 CU1 missing on public symbol server

Question

I've installed the CU1 for SQLServer 2012 and I can't get the matching debug symbols from the debug server (http://support.microsoft.com/kb/311503/en)

SYMSRV:  http://msdl.microsoft.com/download/symbols/sqlservr.pdb/21553ADC31784A4D933974A386EE2E052/sqlservr.pdb not found

SYMSRV:  http://msdl.microsoft.com/download/symbols/sqldk.pdb/A97051F93F754B0CB0BBD3936F6B50062/sqldk.pdb not found

SYMSRV:  http://msdl.microsoft.com/download/symbols/sqllang.pdb/BC1D23DE57F64B79BDBE92B1270C9D842/sqllang.pdb not found

SYMSRV:  http://msdl.microsoft.com/download/symbols/sqlmin.pdb/1EC10D4C403F4795B8272A808E85A22C2/sqlmin.pdb not found
    Image path: C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Binn\sqlservr.exe
    Image name: sqlservr.exe
    Timestamp:        Fri Apr 06 17:19:38 2012 (4F7F098A)
    File version:     2011.110.2316.0
    Product version:  11.0.2316.0
    ProductName:      Microsoft SQL Server
    InternalName:     SQLSERVR
    OriginalFilename: SQLSERVR.EXE
    ProductVersion:   11.0.2316.0
    FileVersion:      2011.0110.2316.00 ((SQL11_RTM_QFE-CU).120406-0302 )

When can we get the correct debug symbols?

---

"A programmer is just a tool which converts caffeine into code"

Answer 1

Hi Andre,

It seems that the pdb files need to be downloaded as the following blog described:

http://sqlskills.com/BLOGS/PAUL/post/How-to-download-a-sqlservrpdb-symbol-file.aspx

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi,

this doesn't work if the PDBs are not on the symbol server.

My post was the WinDbg output when using !sym noisy (http://msdn.microsoft.com/en-us/library/windows/hardware/ff565396(v=vs.85).aspx) and this shows that the symbols are missing on the public symbol server.

André

---

"A programmer is just a tool which converts caffeine into code"

Answer 3

Andre,

In SQL Server 2008, the symbols file is not included by default in the product.  To get the symbols file, you can use windbg and a memory dump.  For steps on how to do this, see http://blogs.msdn.com/b/askjay/archive/2009/12/29/basic-debugging-concepts-and-setup.aspx.  Once you open the memory dump file for the first time, the symbols are downloaded from the public symbols server and placed in the .sympath specified, in the case of the blog post mentioned it will be C:\symbols\public\sq\sqlservr.pdb\1E7168D2F78B4FBA911F507689D7DE902. 

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

I KNOW THAT THE SYMBOLS ARE NOT INCLUDED, THAT'S WHY I WANT TO DOWNLOAD THEM FROM THE SYMBOL SERVER, BUT THE FILE ARE NOT THERE. Is this SOOOOOOOOOOOOOOOOO hard to understand?

Stop your nonsense relies if you have NO idea what you talk about. Ask the SQL Server team if they know this issue and tell me the result!

---

"A programmer is just a tool which converts caffeine into code"

Answer 5

Andre,

Sorry for not understanding well for this problem. I'll contact the SQL Server Team.

I would like also suggest you to submit a feedback to Microsoft for such issues.

For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 6

For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with.

ok, I've submitted a report.

---

"A programmer is just a tool which converts caffeine into code"

Answer 7

Hello Andre,

My name is Rob and I'm with Microsoft SQL Server Support.  I've put in a request to have the public symbols for SQL Server 2012 made available.  I do not currently have an ETA on when they will become available.

In the mean time, was there a particular reason you needed the symbols?  Are you experiencing an access violation or exception?

Sincerely,

Rob Beene - MSFT

Answer 8

Hi Rob,

I no real issue only some small CPU usage spike, but the files should be uploaded because symbols for SQL Server 2012 RTM are uploaded correctly:

while the CU1 symbols are missing:

best regards
André

---

"A programmer is just a tool which converts caffeine into code"

Answer 9

Hey Andre,

I'm still waiting for an update from the team handling the public symbols for CU1 for 2012.  We have uploaded public symbols for other SQL versions CUs so it could just be an oversite, but I will know more soon.

You probably already know this, but you can also use profiler to capture a CPU spike in SQL to identify the tranaction(s) that are contributing to the CPU. 

Hope to have an update for you soon.

Sincerely,

Rob Beene - MSFT

Answer 10

Hey Andre,

I'm still waiting for an update from the team handling the public symbols for CU1 for 2012.  We have uploaded public symbols for other SQL versions CUs so it could just be an oversite, but I will know more soon.

You probably already know this, but you can also use profiler to capture a CPU spike in SQL to identify the tranaction(s) that are contributing to the CPU. 

Hope to have an update for you soon.

Sincerely,

Rob Beene - MSFT

Ok, other user also noticed the issue, replied and voted for it:

https://connect.microsoft.com/SQLServer/feedback/details/740148/debug-symbols-for-sql-server-2012-cu1-missing-on-public-symbol-server

Yes, I know that I use profiler. I use xperf for that. 

yes I remember that I got symbols for other SQLsever versions, this is why I was conused.

---

"A programmer is just a tool which converts caffeine into code"

Answer 11

Hi Andre,

Since the symbols for SQL Server 2012 may not available at present, I will mark your post as answer and let more people who face the same problem to vote that feedback to Microsoft.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 12

connect is useless (as usual). 1 week later and still no reply there.

Any news Robert?

---

"A programmer is just a tool which converts caffeine into code"

Answer 13

Hey Andre,

They are now up there.  Tested yesterday and confirmed.  Sorry for it taking so long.

Thanks for reporting it!

Sincerely,

Rob Beene, MSFT

Answer 14

I can confirm this:

Thanks for the help.

---

"A programmer is just a tool which converts caffeine into code"