Semphore timeout error

Question

I started getting this error on Sunday:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

Prior to Sunday, I've never seen it before.


I added error number 121 to my retry logic.  That works, but the error is so frequent that the system has really slowed down.


The only thing I'm doing is calling a SP that does this:


if exists (select * from member where identifier = @identifier)


  update member...


else


  insert into member...

identifier is the primary key

Any ideas?

Answer 1

Hello.

This error has its roots in Network Layer, not in SQL Server (Winsock is the one that report about this error). Try to find an error in your network connectivity. I would try to monitor Azure SQL with help of supported DMVs.

UPD. Sorry, do you speak about SQL Azure or what?

Answer 2

So, this is a brand new error.

What forum should I post this on?