Re: Notification Delay - sqlserver-programming
This is a discussion on Re: Notification Delay - sqlserver-programming ; What is your quantum set at currently? Can you quantify how long this delay is?...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| delay is? |
|
#2
| |||
| |||
|
Check the quantum duration for the Generator and for the Distributor. If the Generator has a QuantumDuration of 5 minutes and the Distributor has a QuantumDuration of 10 minutes....of course it could be a while before your start seeing notifications. Some questions.... - I'm guessing you are talking about event driven subscriptions rather than scheduled? - Are the events sitting in the event table when you restart or are you talking about new events? - How long has the sqlns been off before restarting? - Have you checked PerfMon or the views? Joe Webb jsmorris wrote: > What is your quantum set at currently? Can you quantify how long this > delay is? > |
|
#3
| |||
| |||
|
I have the Quantum duratin set for 10 secs for both the generator and distributor. The notification are event driven, they sit there go through the process of firing the notification notify procedure but then just sit there with no status change, maybe for like 30 minutes? Joe Webb > Check the quantum duration for the Generator and for the Distributor. If > the Generator has a QuantumDuration of 5 minutes and the Distributor has > a QuantumDuration of 10 minutes....of course it could be a while before > your start seeing notifications. > > Some questions.... > - I'm guessing you are talking about event driven subscriptions rather > than scheduled? > - Are the events sitting in the event table when you restart or are you > talking about new events? > - How long has the sqlns been off before restarting? > - Have you checked PerfMon or the views? > > Joe Webb > > > > > jsmorris wrote: > > > What is your quantum set at currently? Can you quantify how long this > > delay is? > > |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
All times are GMT -4. The time now is 12:14 PM.




Linear Mode