Encountered DeadLock after doing Performance Testing for SQL Server 2019

[Blueberry80]

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]

---

@Blueberry80 wrote:

Can I check is there any setting in SQL Server that is limit to 50 transactions? Thank you. 

---

@Blueberry80 , of cause there are no such setting; wouldn't make any sense to limit SQL Server this way from beginning by "apply the handbrake".

Deadlock occurs on concurry resource access and that is always by the application = bad design.