Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vhusain
Starting Member
7 Posts |
 Posted - 2008-10-02 : 00:38:05
|
| Hi,I am facing several ASYNC_NETWORK_IO wait type issues. The queries show as 'SELECT' and are in suspended mode. This is causing a lots of performance issues. Did anyone face similar kind of issues? and have they been able to successfully resolve it? Please let me knowRegards |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-02 : 09:34:54
|
| Are you using Linked Server and bringing large result sets from remote table? Or You are facing Locking ,Blocking issues. |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-02 : 21:34:48
|
| Is this the first time you are facing this issue on existing system? or did u set up replication/linked server and your query is not working. |
|
|
|
vhusain
Starting Member
7 Posts |
Posted - 2008-10-05 : 00:51:46
|
| Hi,I am not using Linked Servers or Replication. This is a plain and simple database accessed by delphi application.Regards |
|
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-10 : 12:57:13
|
| ASYNC_NETWORK_IO indicates either network latency, or application not fetcing data fast enough.Ensure application is requesting only needed data and fetching it efficiently. Also check network for any latency issue (netmon can help). |
|
|
|
|
|
|
ASYNC_NETWORK_IO issues