>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?
If it's not broken, fix it until it is.
My Blog