Forum Discussion

Blueberry80's avatar
Blueberry80
Copper Contributor
Nov 03, 2023

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 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. 

1 Reply

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Nov 06, 2023

     

    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.

Resources