Hi all,

somewhere in Repserver P&T guide I was reading 2 things.

First:

sqt_max_cache_size setting > 16MB and dsi_max_sqt_cache_size
setting > 2-4MB (for high volumne replication system) might
be contraproductive performance wise.

True ?

Second:

The best bed for correct setting of dsi_sqt_max_cache size
would be SQTCacheLowBnd +20%.


Now which value for SQTCacheLowBnd was ment ?

With admin,stats sqt I can see Obs,Last,Max,Avg ttl/obs

It might not be max so Obs,Last, Avg ttl/obs leftover.

What does Obs,Last, Avg ttl/obs exactly stand for ?

My example:

1> admin stats, sqt
2> go
Report Time: 01/25/12 04:39:05 PM
Instance Instance ID ModType/InstVal
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ---------------
SQT, 112:1 DIST SS_CMISU1_SQL.cmis_trade 112 1
Observer Obs Rate x/sec
------------------------------- ----------- -----------
*CmdsRead 32577719 3
*TransRemoved 520 0
*TruncTransRm 33872 0

(3 rows affected)
Monitor Obs Last Max Avg ttl/obs
------------------------------- ----------- -----------
----------- -----------
*CacheMemUsed 6783 0 1050624 253521
*SQTCacheLowBnd 70265 2816 1048320 9493
*SQTOpenTrans 67744 0 6 0
*SQTClosedTrans 30948 0 11 0
*SQTReadTrans 30948 0 11 0
*SQTTruncTrans 67744 0 16 0


cheers
Jörg