Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

cxpacket Lock Expand / Collapse
Author
Message
Posted Monday, November 4, 2002 9:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 15, 2003 12:00 AM
Points: 42, Visits: 1
Hi !
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 .
server information

OS NT 4.0
SQL SERVER 7.0 SP4

thanks
vittal




Post #7917
Posted Tuesday, November 5, 2002 7:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 2, 2005 11:49 AM
Points: 2,611, Visits: 1
It looks like your qurey is running in parallel.




Post #45528
Posted Tuesday, November 5, 2002 8:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, January 17, 2014 11:52 AM
Points: 212, Visits: 246
As said I am not able find the queties which causing the probelm . I know this errror occur when queries run parallel on SMP syustem . We have two processor on this system. Anyway thanks for reply and let me know if any one of you know more about this issue




Post #45529
Posted Tuesday, November 5, 2002 9:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 2, 2005 11:49 AM
Points: 2,611, Visits: 1
Try dbcc inputbuffer if you know the spid.




Post #45530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse