We transferred an old ASP application from Windows 2000 to Windows 2008 R2 to upgrade its performance. We only transfer the ASP application, the database is still the same. After successful transfer, the users of the web application encounters a deadlock from SQL.
Transaction [Process ID XX] was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
So what we did is to transfer it again to a newly installed Windows 2000 but still the error appears.
I am thinking that maybe there are things that I need to configure on IIS, since nothing has changed except for the web server but I can't figure out what I've missed.