We are getting CXPACKET lock (WAITTYPE) and EXCHANGE lock (waittype ). Still I don't what queries causing the this lock . If you know how to find the queries when i get this problem please let me know.
Also I came to know from Microsoft website they have fix for SQL SERVER 2000 but this happening on SQL SERVER 7.0 .if you know if there is fix , Please let me know .
Now I know I have to see sysprocesses and syslock tables . If could tell exactly what I shoudld look for that will be great.
Any help and detail suggestion will be appreciated .
OS NT 4.0
SQL SERVER 7.0 SP4