[Top] [All Lists]

RE: Lots of blocking from SQLNS

Subject: RE: Lots of blocking from SQLNS
From: Ram<>
Date: Fri, 23 Jan 2009 01:54:59 GMT
Newsgroups: microsoft.public.sqlserver.notificationsvcs
below two sps are participating in the deadlock
?       NSAssignNextWorkItemToDistributor  (Exclusive lock)
?       NSMarkWorkItemDistributionStart  (Update lock)
on the below indexes 
indid  name                         
------ -----------------------------
1      NSDistributorWorkItemsPK     
10     status_distributor_workitems
 on NSDistributorWorkItems table. this occurestwice or thrice in an hour. can 
anyone suggest the soln.


Posted via Groups

<Prev in Thread] Current Thread [Next in Thread>
  • RE: Lots of blocking from SQLNS, Ram <=