>Hello
>I am having a performance problem in an application:
>Performance is good up to a certain number of records processed. Say 2000 records. After that, performance suddenly drops substantially, and remains low until all record are processed (say 7000).
>Looking at the performance counters on the sql server side, we see that when performance is normal, the number of lock request, and processor load go up and down in a "sawtooth" pattern. When the problem arises, the lock requests go to 100 %, remains flat there, and processor load goes to about 85% and remains fairly stable until the application ends
>We were able to simplify our app so that processing only READS from sql server. That is, no updates or inserts. But the problem persists.
>App is written in vb.net (framework 1.1), uses several threads to read from the database, do some processing and write back (but as I said, problem is the same even without writing to the database, and even with a single "reader" thread)
>Any help will be appreciated.

Can you elaborate of what you're using to access the data? Are you returning big result sets to the client?