Topic: Timeout: level 300
There are complexities with from.NET applications in runtime .
More in detail:
Once a day.NET application copies the fresh given data in archive basis which grew already to 4.
The archive basis lies on rather slow disk (one physical disk).
It (on the slow carrier) 24 hours last.
For copying in archive basis in application opens SqlDataReader for a source, and it is transferred in object SqlBulkCopy for record in the archive destination table.
For SqlBulkCopy properties NotifyAfter and BatchSize are adjusted.
it is possible to include transaction for all in the data sheet (i.e. on ).
If it is ungeared, UseInternalTransaction = true on SqlBulkCopy.
for SqlBulkCopy it is installed in 0. for a source it is installed in 120 seconds
Till now all was normal.
From some time application started to take off on , if it is fulfilled simultaneously with .
And it is strange:
Some tables are copied bases of problems.
For others - in the core with considerable quantity BLOB of the data some is copied lines, then seconds through 20 after the last record takes off .
Included asynchronous update of statistics for target basis - did not help.
Then still reduced BatchSize - did not help.
Then still included transaction - helped .
But there is absolutely not clear a reason .
. Who faced or has an explanation, I will be grateful.
: please, do not offer iron - my question on the reasons.