我正在为一个在线游戏开发一个在线小时系统。问题是,有时SQL会引发死锁错误:
40001 Transaction (Process ID 411) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
该游戏有5个房间,每个房间是一个应用程序与自己的SQL连接。播放机不能在多个房间登录。每个应用程序每10分钟在在线播放器上循环一次,将命令发送到SQL过程以更新其联