Devart Forums

Hi

We are using the SDAC ver 4 with 80 connections to a database. With high loads that are 50 - 80 % cpu the database request just stop.

We cannot give you the code as it is built into a multithread server.

Any thoughts?

Probably you have encountered the problem with SQL Server locking. You should not use FetchAll=False mode in your datasets, as underfetched datasets may lead to the locking issues.
Another possible reason is incorrect working with SDAC in multiple threads. You should use one TMSConnection object in each thread, and enable pooling for each TMSConnection. Pooling will help you to increase performance of your application.