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

Re: Error while running notification services

Subject: Re: Error while running notification services
From: "Diane Larsen [MSFT]"
Date: Wed, 30 Aug 2006 10:29:19 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
The Application Definition File (ADF) can contain an EventThrottle setting. 
According to the error message, the event throttle is set to 1000 (which is 
the default value that NS uses if you do not set an event throttle). 
Apparently your application wants to submit more than 1000 events in a 
single event batch. You'll either need to scale back the number of events 
submitted in a single batch, or you'll need to increase the event throttle 
size.

The event batch setting is specified in the ApplicationExecutionSettings 
section of the ADF. If you have defined your application using XML, a 
complete ApplicationExecutionSettings section might look something like this 
(notice that EventThrottle is set to a maximum of 5000 events per event 
batch):

<ApplicationExecutionSettings>
    <QuantumDuration>P0DT00H05M00S</QuantumDuration>
    <ChronicleQuantumLimit>25</ChronicleQuantumLimit>
    <SubscriptionQuantumLimit>12</SubscriptionQuantumLimit>
    <ProcessEventsInOrder>true</ProcessEventsInOrder>
    <PerformanceQueryInterval>P0DT01H00M00S</PerformanceQueryInterval>
    <EventThrottle>5000</EventThrottle>
    <SubscriptionThrottle>3000</SubscriptionThrottle>
    <NotificationThrottle>5000</NotificationThrottle>
    <DistributorLogging>
        <LogBeforeDeliveryAttempts>true</LogBeforeDeliveryAttempts>
        <LogStatusInfo>true</LogStatusInfo>
        <LogNotificationText>false</LogNotificationText>
    </DistributorLogging>
    <Vacuum>
        <RetentionAge>P3DT00H00M00S</RetentionAge>
        <VacuumSchedule>
            <Schedule>
                <StartTime>23:00:00</StartTime>
                <Duration>P0DT02H00M00S</Duration>
            </Schedule>
            <Schedule>
                <StartTime>03:00:00</StartTime>
                <Duration>P0DT02H00M00S</Duration>
            </Schedule>
        </VacuumSchedule>
    </Vacuum>
</ApplicationExecutionSettings>
-- 
Diane Larsen [MSFT]
Technical Writer
SQL Server User Education

This posting is provided "AS IS" with
no warranties, and confers no rights.
Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.


"Lakshmi Narayana Pabbati" <Lakshmi Narayana 
[email protected]> wrote in message 
news:[email protected]
>I have two databases with same strucutres.
> I am able run the notification services for one istance and it is not
> working for
> second instance of database. First database have 50,000 Records and the
> second database have 75,000 records. Please help to solve this error. 
> Thanks
> in advance.
>
> Error from event log as below:
> ---------------------------------------------
> <NotificationServicesEvent>
> <Description>
> The number of events in this quantum is greater than the throttle
> specified for events.
> </Description>
> <Context>
> <EventParameters>
> <InstanceName>IMSSLAInstance</InstanceName>
> <ApplicationName>IMSSLA</ApplicationName>
> <StoredProcedureName>NSMaterializeIMSSLAEventsEventViews</StoredProcedureName>
> <EventClassName>IMSSLAEvents</EventClassName>
> <QuantumId>182</QuantumId>
> <EventThrottle>1000</EventThrottle>
> </EventParameters>
>
> 



<Prev in Thread] Current Thread [Next in Thread>
  • Re: Error while running notification services, Diane Larsen [MSFT] <=