Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired Expand / Collapse
Author
Message
Posted Friday, February 01, 2013 12:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:45 PM
Points: 582, Visits: 1,975
we have SQL Server 2000 hosting .net application databases. We are facing application time out issues with the below issue

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

When I query select * from sysprocesses there are many processes lastwaittype as MISCELLANEOUS and command type as AWAITING COMMAND and also sometimes NETWORKIO

Please advise what could be the reason to get the error A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired

Please see the attachment


  Post Attachments 
Sessions.txt (5 views, 432.41 KB)
Post #1414463
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse