sql server notification services: Re: Event collection goes from weekly collecting of event to every minute! -- sql server notification services

Re: Event collection goes from weekly collecting of event to every minute!

jsmorris
6/24/2004 7:26:47 AM

sql server notification services: Thanks Joe. That is exactly the work around that I was thinking about
and I am sure that would work

I am still curious as to why this happens. In this instance the query
is not that expensive, but if it was, that would cause a tremendous
load on the source of the events' database.

If upgrading to sp1 doesn't help and I see this again, then the
schedule subscription will be the way to go.

Re: Event collection goes from weekly collecting of event to every minute!

Joe Webb
6/24/2004 11:14:28 AM

I actually kind of prefer the scheduled subscription to the event driven
subscription for scenarios such as yours; since with a scheduled
subscription, sqlns is in control whereas in an event driven
subscription sqlns is at the mercy of the event provider.

I haven't had the problem you've described, but if you find the culprit
or a solution, please post.

Joe Webb

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.