Ansicht
Dokumentation

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

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

Fill RESBD Structure from EBP Component Structure   General Data in Customer Master  
Diese Dokumentation steht unter dem Copyright der SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter: dbs/mss/no_cacheprofile |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Kurzbeschreibung: Deaktiviert Cache-Profiling für MS SQL Server |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameterbeschreibung: |
| ---------------------- |
| Beim Betrieb von R/3 wird standardmäßig eine Sonderoption aktiviert, |
| die die Tabelle syscacheobjects mit Performance-Informationen |
| aktualisiert. Diese Spalten sind z.B. lasttime, maxexectime, |
| avgexectime, lastreads, lastwrites,... |
| Dies führt zu geringen Performance-Einbußen. Mit diesem Profil- |
| parameter können Sie die Ermittlung dieser Statistiken deaktivieren. |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Anwendungsbereich: Datenbank |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Einheit: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Vorschlagswert: 0 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Änderungsberechtigte Person(en): |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Einschränkungen für Betriebssysteme: Windows NT |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Einschränkungen für Datenbanksysteme: Microsoft SQL Server |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Sind andere Parameter betroffen oder abhängig: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Gültige Einträge, Formate, Bereiche: |
------------------------------------------------------------------------

------------------------------------------------------------------------
| 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   rdisp/max_wprun_time - Maximum work process run time  
Diese Dokumentation steht unter dem Copyright der SAP AG.

Length: 4561 Date: 20240423 Time: 190624     sap01-206 ( 5 ms )