Forum Discussion
Encountered DeadLock after doing Performance Testing for SQL Server 2019
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 dead...
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.