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

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply