Tagged Questions
2
votes
1answer
253 views
Remove an IP address from server config
What is the safe way to remove an old IP address from SQL Server configuration?
The scenario is, I have a server with 2 NIC's that should have been configured for teaming but weren't at the time SQL ...
1
vote
2answers
410 views
SQL Server: Should we use TCP or Named Pipes or use the default?
When connecting to a SQL Server 2008 R2 from a .NET 4 client application on a different server in the same LAN, one can set three different network protocols:
TCP
Named Pipes
Don't set anything in ...
2
votes
1answer
656 views
Connection to localhost dramatically slower than to network server
I have an Excel VBA application that connects to a SQL Server 2008 R2 database through ADODB.
When I'm on the network at work, the connection is almost instantaneous. When I am at home working with ...
2
votes
1answer
583 views
Where do I find the meaning of TdsInputBufferError numbers?
We are having some sporadic connection errors on some of our SQL servers. I did some searching and found out about the Ring Buffer in SQL 2008 R2 and found some information, but I am not entirely sure ...
3
votes
2answers
640 views
TdsInputBufferError not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers
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, ...
16
votes
2answers
4k views
I/O requests taking longer than 15 seconds
Usually our weekly full backups finish in about 35 minutes, with daily diff backups finishing in ~5 minutes. Since tuesday the dailies have taken almost 4 hours to complete, way more than should be ...
