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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-05-06 : 22:24:14
|
| In my SSIS package I have a Lookup process that determines, if a particular ID is in an existing table. If an ID is present an update statement will be executed. If an ID is not present an Insert statement will be executed. Both of the operation are using the same table name. When I execute my SSIS package I get the following wait type under Activity Monitor:- LCKM_IU- ASYNC_NETWORK_IODoes anyone know how to resolve this problem?PS. My SSIS package is not using any linked server. Thanks. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-07 : 01:49:25
|
Where are your databases stored? On same drives as local machine or on a SAN?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2009-05-07 : 07:50:07
|
| Thanks for the response, Peso. It is stored on a SAN. Please advice. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-09 : 23:31:06
|
| See this from Joe.http://blogs.msdn.com/joesack/archive/2009/01/09/troubleshooting-async-network-io-networkio.aspx |
|
|
|
|
|
|
ASYNC_NETWORK_IO issues