Chad Scott

For Domino 8.5, there is no background thread that automatically resynchs DAOS reference counts. My recommendation is to add a manual resync to your regularly scheduled maintenance routines, preferrably during non-peak hours. You can set up a program document as follows:

Program name: (n)server
Command line: -c "tell DaosMgr resync"

Mine runs at 3:00 AM on Sundays.

Several years ago I got a call about a problem with some relatively unburdened servers that had low Server Availability Indexes (SAI). At the time, there really was no simple documentation on how to set this appropriately to yield the desired SAI, so a common approach was to keep setting the Server_Transinfo_Range notes.ini parameter to successively high values until the problem of low SAI went away. This is not a good approach, however, because setting Server_Transinfo_Range too high will result in a server that never thinks it is busy, even when it should.

Here are the instructions we've had for years for tuning SAI:

1. During a period of heavy usage, monitor the expansion factor on your server. You can use the console command "show stat server.expansionfactor" to do this. You can also monitor performance statistics during these periods. Record enough values for the expansion factor during heavy usage so that you can determine the expansion factor value for a fully loaded server.

2. Determine a value for SERVER_TRANSINFO_RANGE so that 2 raised to the power of that value results in the expansion factor value you chose in step 1.

While accurate, many people find these instructions a bit confusing, so I created a table that you can use to make this very easy. Just track the Server.ExpansionFactor statistic for periods of heavy usage and determine what you want the SAI to read for those periods. Find the closest ExpansionFactor in the table and trace left to your desired SAI. If it is not there, find the two numbers closest to your target. Then trace up to the corresponding value you need to set for Server_Transinfo_Range. Hopefully this will make tuning an appropriate SAI much easier for you.

Changing the system clock is one of the most damaging things you can do in a Notes/Domino environment. In particular, setting the clock forward in time and then back to the current time is a scenario that seems to play out much more than it should. Doing this on a Notes or Domino machine can have many serious ramifications that can have lengthy clean-up procedures.

I understand there may be times where you want to test the correct function of some task or agent at some point in the future, perhaps as part of planning for a specific project or business cycle. If this type of testing must be done, make sure it's in a completely disposable environment. I don't even recommend your normal test environment unless you plan on rebuilding it afterward. This is a perfect scenario for a client/server running in a virtual machine. Make a snapshot, do your testing, and then delete it.

Based on my experience, there seems to be very little consensus in the community about scheduled database maintenance. Here's a good starting point.

I commonly see environments where Compact -B runs nightly, but it's actually a good thing to have a bit of (contiguous) whitespace in the database so the on-disk file doesn't have to grow as soon as a new document is added. You don't want to go crazy with it and have a 50-percent utilized database, but somewhere around 10 percent seems reasonable.

Fixup is another area where you may have received some conflicting information in the past. We reviewed the applicability of Fixup as a general maintenance task with members of the Development team, and the consensus is that this is safe to do. I don't think it's necessary to run it regularly, but once a week can help clear up any inconsistencies that might crop up in the database.

What are you running for scheduled maintenance?