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