Can you post a typical command which is causing the performance issue?

Is the SQL Server on a desktop or server?

Have you the appropriate indexes setup?

Is it one specific query which is causing the problem? Maybe review the query plan and IO stat's of that query to see if it is table scanning.

Cheers

Jon




>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.