SAP Parameter dbs/mss/par_stmt_cache_size - Size of cache for parameterized statements. Only for statistics.

Parameter
dbs/mss/par_stmt_cache_size

Short text
Size of cache for parameterized statements.
In transaction st04 -<(>><)> Detailed Analysis -<(>><)> SAP Stats on
SPs thereis a way to monitor dynamically executed statements. This parameterspecifies how many of those statements are monitored. The worstperforming statements are placed in this cache.

Work area
Database

Default value
1000

Limitation for os
Windows NT

Limitation for db
Microsoft SQL Server