provider: TCP Provider, error: 0 - 由于系统缓冲区空间不足或队列已满,不能执行

All Replies

• Tuesday, November 06, 2012 5:25 PM

  Answerer

   

   
  

  0

  Translation to English:

  When connecting to the remote SQL 2012, frequently appears, provider:TCP Provider, error:0-because the system lacked sufficient buffer space or because a queue was full, you cannot perform an exception error, how to fix it

  ---

  Tatyana Yakushev [PredixionSoftware.com]

  • Proposed As Answer by Kalman TothMicrosoft Community Contributor Wednesday, November 21, 2012 2:28 PM
  •  
  • Reply
  • Quote

   
• Wednesday, November 07, 2012 10:31 AM

   

   
  

  0

  it seems your system is facing resource bottleneck.

  can you check & share total available RAM & min & maximum memory set for sql server. 

  ---

  Regards,
  Rohit Garg
  (My Blog)
  This posting is provided with no warranties and confers no rights.
  Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

  • Reply
  • Quote

   
• Tuesday, November 13, 2012 3:34 AM

  Moderator

   

   
  

  0

  Hi xiaobifei,
  
  The issue might be due to Operation System runs out of memory for TCP buffers or Operation System runs out of available TCP “ephemeral” ports, please refer to the following links about how to fix it:
  http://blogs.msdn.com/b/sql_protocols/archive/2009/03/09/understanding-the-error-an-operation-on-a-socket-could-not-be-performed-because-the-system-lacked-sufficient-buffer-space-or-because-a-queue-was-full.aspx 
  
  Thanks,
  Eileen

  ---

  Eileen Zhao

  TechNet Community Support

  

  

  • Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, November 20, 2012 5:19 AM
  •  
  • Reply
  • Quote