I have an older Dell boxen with 2000 SVR SP4 with SQL 2000 SP4 Our app is getting slower as it ages and the mainboard cannot take more than 1GIG of ram. Without getting new hardware, Id like to use this time to tune the DB before we spend $$ on an upgrade. When I let memory go dynamic, it eats into all...

We are using SQL Server 2000. In production we are facing deadlock problems. If we try to run a trace then users starts complaining that there are not able to get into the application. What do you think are the options that we have to trace down deadlock issues? We have hundreds of stored procedures...