Topic: The analog critical section is necessary
Kind time of days, All!
There is a problem.
The server, is a lot of kernels, procedure without parameters, fulfills 3 seconds. Returns to all asking (well almost) same.
It cause 10 time at an o'clock.
She reads many pages from a cache (5 at an o'clock). We will consider that hit in a cache of 100 %.
Total, 30 seconds at an o'clock superfluous queue of requests.
To all returns same, but each time works on a data set in which the heap of records in a second flies.
...Here, there was a thought, this miracle.
That anew enumerated this all not each call, and time in 10 seconds. (For example)
But my attempts to create reference . A label which we read with (rowlock) in transaction - did not lead to success.
Sensation that competing flows in fly, and read cleaned, but yet the cache not filled anew.
Question, as though to organize the performance unit, that the first entered into it was fulfilled (With DIRTY READING), and remaining - ?
Here somehow so, thanks in advance.