microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Duplicate Notifications

Subject: Re: Duplicate Notifications
From: "David"
Date: 9 May 2005 15:04:03 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Shyam:

Based on what we see in the profiler:

Within one quantum:

NSMaterializeMyEventEventViews is started and completed in the
following pattern.
Start
Start
Complete
Start
Start
Complete
Complete
Complete

The MyEventEvents table contains unique events.
No single subscriber has more than one subscription with the same
Criteria matching  the e.Criteria = s.Criteria constraint in the rule
join.


NSFire2 is only getting called once.
insert into MyEventNotificationNotifications via sp_execute is
definitely getting called multiple times with the same data.
likewise NSMyEventNotificationNotify appears to be getting called too
many times.

Is there some scenerio underwhich the NSCurrentMyEventEvents table
could get populated twice ?

I can privately provide the relevant portions of the trace if that
would be helpful.

Thanks,
David


<Prev in Thread] Current Thread [Next in Thread>