Serial/Parallel compilation of plan in Sappcom in Sagent

This can be governed by two keys created inside "HKEY_LOCAL_MACHINE\SOFTWARE\Sagent\Datamart\PP". These are Sagent client side (32 bit) keys therefore if Sagent is installed on 64 bit machine, these should be set in "HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Sagent\Datamart\PP"
  • Key Name: SappcomSerialize
  • Key Name: MaxPlans
Both keys are of type 'DWORD':
  • With SappcomSerialize = 0 or not defined, Sappcomm does concurrent plan compilation up to a maximum of 'MaxPlans' plans compiling concurrently.
  • With SappcomSerialize = 1 or not defined, Sappcomm does fully serialized or Single plan compilation.
UPDATED:  September 3, 2019