[Top] [All Lists]

Re: NS<product>Events not be cleaned down

Subject: Re: NS<product>Events not be cleaned down
From: Joe Webb
Date: Thu, 15 Sep 2005 05:57:20 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi John -

What happens when you disable the scheduled vacuumer and run it

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. 


Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Thu, 15 Sep 2005 08:48:38 +0100, "J" <[email protected]> wrote:

>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,

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