Hi,
Today I tried to do some kind of stresstest on the DB that I use.
I started a few threads and start processes in the threads and do the tasks to finish each processes. It ran well, but when I started to increase the number of the threads and the concurrent running process instances I came across with problems. This lead to the app run out of the database connection from the pool and causing database deadlocks too.
Is there a way how I could limit the engine to run parallel maximum a number of "commands"?
Many Thanks,
Zoltan