Siebel Analytics Server Administration Guide > Administering the Query Environment > Administering Usage Tracking >

Performance Considerations

When usage tracking is enabled, the Siebel Analytics Server collects usage tracking data for every query. This data, however, is only written to disk at user-specified intervals, known as checkpoints. The default setting is to checkpoint every 5 minutes.

While this value can be modified in theNQSConfig.INI file (see Siebel Analytics Installation and Configuration Guide), reducing the interval adds overhead and, if set low enough, could potentially impact server performance. Setting the value higher increases the amount of usage tracking data that could be lost in the unlikely event of an abnormal shutdown of the Siebel Analytics Server.

The Siebel Analytics Server periodically initiates usage tracking log file rollovers. A rollover consists of closing the current usage tracking log file and opening a newly created one for writing subsequent data. The frequency at which rollovers occur is called a rollover interval. The default rollover interval is 240 minutes (every 4 hours).

Usage tracking log files that are closed are available for analysis. Setting a lower rollover interval will make usage tracking log files available for analysis sooner, but at the cost of additional overhead.

If the checkpoint interval equals or exceeds the rollover interval, only the rollover occurs explicitly; the checkpoint only occurs implicitly when the old usage tracking log file is closed.


 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003