1) We have sweep set to 0. We do monitor the transaction gab and if needed, we interact. Any kind of automatic sweep under high load will kill the server :)

2) We do run gbak daily. We do not use nbackup - we would like to and tried it but it's corrupting the db.

3) We do use read-only readcommited transactions with record versioning as much as we can.

Otherwise, same Settings but not read-only.