Ansicht
Dokumentation

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

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

PERFORM Short Reference   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter: dbs/mss/no_cacheprofile |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short description: Disables cache profiling for MS SQL Server |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter description: |
| ---------------------- |
| By default when running R/3, a special option is enabled where the |
| syscacheobjects 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 profile |
| parameter allows you to disable the collection of these statistics. |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Application area: Database |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Unit: |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Default value: 0 |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Person(s) allowed to make changes: |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for the operating systems: Windows NT |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for database systems: Microsoft SQL Server |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Are other parameters affected or dependent: |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid entries, formats, areas: |
------------------------------------------------------------------------


------------------------------------------------------------------------
| Short Description : Disables cache profiling for MS SQL Server
------------------------------------------------------------------------

------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter Type : B
------------------------------------------------------------------------

------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid for Operating System : Windows NT
------------------------------------------------------------------------

------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------


CPI1466 during Backup   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 4627 Date: 20240329 Time: 062355     sap01-206 ( 5 ms )