Setting the SQL Server Trace Flag 2453 is recommended for Identity Manager 7.x (as reported in the Database journal, "Trace flag 2453 should be enabled.")
Does this flag result in performance advantages for Identity Manager 6.x as well?
SQL Server stores statistics on all queries in order to optimize execution plans for all future queries. Part of this deterministic is to estimate the amount of data which are extracted out of different tables. This is done for table variables as well as by default. But table variables are not real tables and have potentially very different contents on every use. This can result in very bad execution plans.
The Trace Flag 2453 switches off the use of statistics for table variables and forces SQL Server to recalculate the execution plan based on the real number of records. Because table variables are used by Identity Manager 6.x extensively as well, there will be a potential performance gain. The Trace Flag 2453 is available since SQL Server 2012. If this version or a later one is used, it is recommended to use with Identity Manager 6.x as well.