SAP Parameter dbs/mss/no_cacheprofile - Disables cache profiling for MS SQL Server


Short text
Disables cache profiling for MS SQL ServerBy default when running R/3, a special option is enabled where thesyscacheobjects table is updated with performance information.These columns are for example lasttime, maxexectime,avgexectime,lastreads, lastwrites,...There is a very slight performance cost for this. This profileparameter allows you to disable the collection of these statistics.

Work area

Limitation for os
Windows NT

Limitation for db
Microsoft SQL Server