mardi 13 mars 2012 17:19
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)
insert into member...
identifier is the primary key
- Modifié octapi mardi 13 mars 2012 17:20
Toutes les réponses
mercredi 14 mars 2012 12:24
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?
- Modifié Alexander BelotserkovskiyMVP mercredi 14 mars 2012 12:24
dimanche 18 mars 2012 21:38
So, this is a brand new error.
What forum should I post this on?