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

Re: NS<product>Events not be cleaned down

Subject: Re: NS<product>Events not be cleaned down
From: "J"
Date: Thu, 15 Sep 2005 04:39:03 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Joe,

I've just tried the manual clean up using NSVacuum, and that works fine, it 
did 32 in 30 seconds.  It's running at the moment, but has approx 900,000 
quantums to clean out.

Thanks,
John

"Joe Webb" wrote:

> Hi John -
> 
> What happens when you disable the scheduled vacuumer and run it
> manually?  
> 
> I'm not suggesting this is a production-level resolution. But I'd like
> to see whether the issue is in the vacuumer determining what to get
> rid of, or whether the vacuumer is not running at all. 
> 
> HTH...
> 
> -- 
> Joe Webb
> SQL Server MVP
> 
> 
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 
> 
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
> 
> 
> 
> 
> On Thu, 15 Sep 2005 08:48:38 +0100, "J" <[email protected]> wrote:
> 
> >Hi,
> >
> >I'm having trouble with the NS<product>Events table not being cleaned down.
> >Initially I thought it was because the vacuum event was clashing with the
> >backup procedure on the server, so I moved the vacuum event to a time 5
> >hours before hand.  Unfortunatley it made no difference, and the number of
> >events in the table actually increased!
> >
> >Has anyone got any ideas as to what maybe happening?
> >
> >The retention age is set to 1 day, and the event will go off at 9pm for 3
> >hrs every day.
> >
> >Many Thanks,
> >John
> >
> 

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