ASYNC Network IO error in calls from one server to linked server

Posted on 2011-05-10
Last Modified: 2012-05-11
I am not a DBA, I am expericanced coding TSQL and dealing with the more software oriented tasks.
We have 2 servers.  Server A is 2008, Server B is 2005.  Up until this morning when all heck broke loose on our network everything was working fine.  After our network engineers "fixed" the problem everything is working except this one thing (so far).  A stored procedure that returns data to a webapplication was working fine on Server A, is not longer working.  The stored procedure selects data from Server B using synonyms, along with tables existing on ServerA  When the stored procedure runs now Server B locks up with ASYNC network IO waits.

I moved the procedure completely over to Server B, including copies of the tables on Sever A  and it works fine now.
I think that possibly the problem has to do with Server A's network settings or maybe even the hardware.  From what I understand with the Network IO error it has to do with the ability of the client to accept the data.  

So, basically I'm looking for opinions or ideas for what to look into.

Thank you

I beleive something has gone wrong with
Question by:vossjck
    LVL 2

    Expert Comment

    LVL 75

    Expert Comment

    by:Anthony Perkins

    I suspect you posted that in error, as the author is asking about SQL Server and not Linux.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    There is some issue regarding memory allocation. Please see the Task manager -> resource manager.

    Please terminate any of process which is blocking you process. image
    LVL 75

    Accepted Solution


    I apologize for all the misdirected advice you are getting here.  If you do not get any constructive responses in the next few days I would suggest you request the question be deleted and repost.  Just make sure to include more SQL Server zones such as:

    Hopefully will will have better luck next time.
    LVL 2

    Author Closing Comment

    The situation seemed to be caused by hardware as far as I can tell.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now