HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

TdsInputBufferError not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
ring_buffer_connectivitylogintimerstdsinputbuffererrorsyserrorsnotdm_os_ring_buffers

Problem

I've got an issue with SQL Server.

The value of TdsInputBufferError is not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers.

This happens randomly, once or twice a week, at different times.

Is it an issue with networking drivers ? Virtualization infrastructure? What to monitor to find out? There is no other error/warning log anywhere (windows logs, syslogs, ...).

Full ringbuffer report:


  
    LoginTimers
    0
    A4478B00-18A1-4147-A65E-2EB505DCA470
    17830
    7
    11
    xxxx:xxx:xxxx:xx:xxxx:xxx:xxxx:xxxx
    56201
    xxxx:xxxx:x:xxxx::xxxx
    1433
    1/20/2012 10:12:52.32
    
      10054
      0
      0
    
    
      0
      0
      0
      0
      0
      0
      0
    
  
  
    0X00000000019EAC4B
    0X00000000019E7A36
    0X00000000019EC6BE
    0X0000000000CA81BC
    0X000000000068B888
    0X000000000064EF40
    0X000000000064ED12
    0X000000000064EA17
    0X0000000000AB598A
    0X0000000000AB5C25
    0X0000000000AB5A56
    0X0000000000AB61E2
    0X0000000074A737D7
    0X0000000074A73894
    0X0000000076D2652D
    0X00000000772CC521
  

Solution

I can't give you answer but I can direct you towards it.

  • You need to download the public symbols for your installed


version of SQL Server
http://www.sqlskills.com/BLOGS/PAUL/post/How-to-download-a-sqlservrpdb-symbol-file.aspx

  • You need to able the Trace Flag which shows the public function names for


that Stack Trace using DBCC TRACEON(3656) with reference to this blog

  • Report the public symbol names for those frames back to us or


Microsoft CSS (Customer Support Services)

Context

StackExchange Database Administrators Q#11073, answer score: 3

Revisions (0)

No revisions yet.