Skip to main content
deleted 19 characters in body; edited tags
Source Link
Tom V
  • 15.7k
  • 7
  • 64
  • 87

Last week something strange happened on our database. All of a sudden, the application blocked for our users who were not able to save new entities etc. After looking at the Activity Monitor of the SQL Server (2008 with compatibility mode 2005) I saw the following three entries:

![async_network_io wait types][1]async_network_io wait types

After some time, the users got a connection timeout. When I killed the process 64, they could save normally again.

The problem is that the entities they tried to save during the block were inserted into the DB more than once (up to 3 times) even though there is code which should prevent this from happening (number column which has to be unique but without a constraint... the check happens in the code).

We use Entity Framework 6.0.

  • Does anyone of you know why and when these ASYNC_NETWORK_IO wait types occur and how to avoid them?
  • And what exactly do they mean?

Thanks in advance [1]: https://i.sstatic.net/Vkte3.png

Last week something strange happened on our database. All of a sudden, the application blocked for our users who were not able to save new entities etc. After looking at the Activity Monitor of the SQL Server (2008 with compatibility mode 2005) I saw the following three entries:

![async_network_io wait types][1]

After some time, the users got a connection timeout. When I killed the process 64, they could save normally again.

The problem is that the entities they tried to save during the block were inserted into the DB more than once (up to 3 times) even though there is code which should prevent this from happening (number column which has to be unique but without a constraint... the check happens in the code).

We use Entity Framework 6.0.

  • Does anyone of you know why and when these ASYNC_NETWORK_IO wait types occur and how to avoid them?
  • And what exactly do they mean?

Thanks in advance [1]: https://i.sstatic.net/Vkte3.png

Last week something strange happened on our database. All of a sudden, the application blocked for our users who were not able to save new entities etc. After looking at the Activity Monitor of the SQL Server (2008 with compatibility mode 2005) I saw the following three entries:

async_network_io wait types

After some time, the users got a connection timeout. When I killed the process 64, they could save normally again.

The problem is that the entities they tried to save during the block were inserted into the DB more than once (up to 3 times) even though there is code which should prevent this from happening (number column which has to be unique but without a constraint... the check happens in the code).

We use Entity Framework 6.0.

  • Does anyone of you know why and when these ASYNC_NETWORK_IO wait types occur and how to avoid them?
  • And what exactly do they mean?
spelling.
Source Link
Michael Green
  • 25.1k
  • 13
  • 53
  • 98

Last week something strange happened on our database. All All of a suddonsudden, the application blocked for our users whichwho were not able to save new entities etc. After After looking at the Activity Monitor of the SQL Server (2008 with compatibility mode 2005) I saw the following three entries:

![async_network_io wait types][1]

After some time, the users got a connection timeout. When When I killed the process 64, they could save normally again.

The problem is that the entities they tried to save during the block were inserted into the DB more than once (up to 3 times) even toughthough there is code which should prevent this from happening (number column which has to be unique but without a constraint... the check happens in the code).

We use Entity Framework 6.0.

  • Does anyone of you know why and when these ASYNC_NETWORK_IO wait types occur and how to avoid them?
  • And what exactly do they mean?

Thanks in advance [1]: https://i.sstatic.net/Vkte3.png

Last week something strange happened on our database. All of a suddon, the application blocked for our users which were not able to save new entities etc. After looking at the Activity Monitor of the SQL Server (2008 with compatibility mode 2005) I saw the following three entries:

![async_network_io wait types][1]

After some time, the users got a connection timeout. When I killed the process 64, they could save normally again.

The problem is that the entities they tried to save during the block were inserted into the DB more than once (up to 3 times) even tough there is code which should prevent this from happening (number column which has to be unique but without a constraint... the check happens in the code).

We use Entity Framework 6.0.

  • Does anyone of you know why and when these ASYNC_NETWORK_IO wait types occur and how to avoid them?
  • And what exactly do they mean?

Thanks in advance [1]: https://i.sstatic.net/Vkte3.png

Last week something strange happened on our database. All of a sudden, the application blocked for our users who were not able to save new entities etc. After looking at the Activity Monitor of the SQL Server (2008 with compatibility mode 2005) I saw the following three entries:

![async_network_io wait types][1]

After some time, the users got a connection timeout. When I killed the process 64, they could save normally again.

The problem is that the entities they tried to save during the block were inserted into the DB more than once (up to 3 times) even though there is code which should prevent this from happening (number column which has to be unique but without a constraint... the check happens in the code).

We use Entity Framework 6.0.

  • Does anyone of you know why and when these ASYNC_NETWORK_IO wait types occur and how to avoid them?
  • And what exactly do they mean?

Thanks in advance [1]: https://i.sstatic.net/Vkte3.png

Post Migrated Here from stackoverflow.com (revisions)
Source Link
xeraphim
  • 597
  • 2
  • 5
  • 11

Why do async_network_io wait types occur?

Last week something strange happened on our database. All of a suddon, the application blocked for our users which were not able to save new entities etc. After looking at the Activity Monitor of the SQL Server (2008 with compatibility mode 2005) I saw the following three entries:

![async_network_io wait types][1]

After some time, the users got a connection timeout. When I killed the process 64, they could save normally again.

The problem is that the entities they tried to save during the block were inserted into the DB more than once (up to 3 times) even tough there is code which should prevent this from happening (number column which has to be unique but without a constraint... the check happens in the code).

We use Entity Framework 6.0.

  • Does anyone of you know why and when these ASYNC_NETWORK_IO wait types occur and how to avoid them?
  • And what exactly do they mean?

Thanks in advance [1]: https://i.sstatic.net/Vkte3.png