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.