Tuesday, November 06, 2012 11:51 AM
连接远程SQL 2012时，经常会出现、provider: TCP Provider, error: 0 - 由于系统缓冲区空间不足或队列已满,不能执行 异常错误，请问怎么解决
Tuesday, November 06, 2012 5:25 PMAnswerer
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
Wednesday, November 07, 2012 10:31 AM
it seems your system is facing resource bottleneck.
can you check & share total available RAM & min & maximum memory set for sql server.
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.
Tuesday, November 13, 2012 3:34 AMModerator
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:
TechNet Community Support
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, November 20, 2012 5:19 AM