Encountered DeadLock after doing Performance Testing for SQL Server 2019

1

Hi everyone,

Need to seek advice . My program is using SQL Server as the database and we are doing some performance testing. If the virtual user is around 40, my program does not encounter any deadlock error. But if we increase the virtual user to 50, there is deadlock error resulting. Can I check is there any setting in SQL Server that is limit to 50 transactions? Thank you.

2

No, there is no artificial limit in SQL Server to the number of simultaneous transactions.

3

You need to find out, what the processes involved in deadlock are actually doing.