(Optional) When the trace flag 4816 is enabled for the RAPCache, there are certain operations that should not be performed on the tables involved in the bulk transfers.
Disable the trace flag if you wish to perform these operations.
Prerequisites
The installation is complete.
The trace flag 4816 is enabled for the RAPCache, by default.
Do not perform the following operations on the tables involved in the bulk transfers:
- drop table
- alter table
- create/drop index
- create/drop trigger
- reorg rebuild table
- update statistics
- delete statistics
- create default
- create constraint
- create computed column
- change system encryption password
- sp_recompile
- sp_bindefault/sp_unbindefault
- sp_bindmsg/sp_unbindmsg
- sp_bindrule/sp_unbindrule
- sp_cachestrategy
- sp_rename
To disable the trace flag:
-
Go to the /RAPCache/ASE-15_5/install/RUN_RAPCache file.
-
Delete the line "-T4816".
As a consequence, you may see additional triggers of cache-based rules.