> I`m not sure if running a 24/7 trace is a good idea (database is under
> relatively heavy load). Anything else I could do to help?

It might be ok with a proper include filter at service level from a
Trace API POV.

The following trace configuration should be fully dedicated to sweeping
only:

<database yourdatabasealias>
enabled true
print_perf true
log_sweep true
exclude_filter %RDB$%
time_threshold 0
</database>
<services>
enabled true
log_services true
include_filter "Repair Database"
</services>


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

> btw I am noticing that the unexpected sweep is about 27000-30000
> transactions after the scheduled one. I could send a log if that helps
> in any way. I set the interval to 100000 and in a day or two I`ll know
> if it still runs by its own.
>
> 2014-10-27 21:46 GMT+02:00 Thomas Steinmaurer ts@...
> <mailto:ts@...> [firebird-support]
> <firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>>:
>
> __
>
> > I did some reconfiguration on a database yesterday, so I`m monitoring
> > the logs for any issues and I noticed something strange :
> >
> > Mon Oct 27 16:54:25 2014
> > Sweep is started by SYSDBA
> > Database "orbis-aton"
> > OIT 21080, OAT 21081, OST 20456, Next 44177
> >
> > (yes, I know it`s a bad idea but all database connections are by
> SYSDBA)
> >
> > I don`t remember running a sweep (logs say I wasn`t even logged in at
> > the time) and nobody else has access (or knowledge, for that
> matter) to
> > run a sweep on that machine so I got curious.
> > Logs say an unexpected sweep has been running basically every day
> > (sometime between 5 and 10 pm, which is apparently when it hits the
> > number of transactions). I have a manual sweep at 5:40am in cron
> and I
> > checked - configuration is correct and runs as expected. I also
> > double-checked gstat :
> >
> >
> > Database header page information:
> > Flags 0
> > Checksum 12345
> > Generation 51454
> > Page size 16384
> > ODS version 11.2
> > Oldest transaction 21357
> > Oldest active 50561
> > Oldest snapshot 49520
> > Next transaction 51318
> > Bumped transaction 1
> > Sequence number 0
> > Next attachment ID 130
> > Implementation ID 24
> > Shadow count 0
> > Page buffers 0
> > Next header page 0
> > Database dialect 3
> > Creation date Oct 26, 2014 12:28:26
> > Attributes force write
> >
> > Variable header data:
> > Sweep interval: 0
> > *END*
> >
> >
> > Shouldn`t automatic sweep be disabled or have I misread the
> > documentation? FB version is 2.5.3.
>
> Yes, by setting the sweep interval to 0, automatic sweeping should be
> disabled. There is also:
> http://tracker.firebirdsql.org/browse/CORE-4100
> (marked as fixed in 2.5.3) but you are mentioning that you are using
> 2.5.3, although I'm not entirely sure if CORE-4100 applies to sweep
> interval = 0 anyway.
>
> You could use the Trace API to trace services API requests to get a
> clearer picture on what client application is causing the sweep in case
> it has been triggered manually.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird
> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>
>
>
>
>