InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Is There Any Limited Number Of Simultaneous Sessions Of A Sap Maxdb Database? |
|
Answer» No, there is no limit for the number of simultaneous sessions of an SAP MaxDB database. The database parameter MaxUserTasks is used to configure the number of database sessions that can be logged on SIMULTANEOUSLY to the database. OLTP: The number of database USERS in OLTP systems should be configured to at least 2 x <number_SAP processes > + 4. BW: The number of database users in OLTP systems should be configured to at least 3 x <number_SAP processes > + 4. Java applications: The maximum number of connections to the database in the connection pool is determined for each J2EE instance (NW 7.1 is the default 70). The sum of connections (connection pool) of all J2EE instances + 4 is used to calculate the number of PARALLEL user sessions (MaxDB parameter: MaxUserTasks). liveCache: The formula which is used to calculate the value for the database parameter MaxUserTasks for liveCaches in SCM system 4.1 and LOWER is: 2 x <number_SAP processes > + 4 The formula which is applied for liveCaches in SCM system 5.0 and above is: 3 x <number_SAP processes > + 4 One can also refer to 757914. No, there is no limit for the number of simultaneous sessions of an SAP MaxDB database. The database parameter MaxUserTasks is used to configure the number of database sessions that can be logged on simultaneously to the database. OLTP: The number of database users in OLTP systems should be configured to at least 2 x <number_SAP processes > + 4. BW: The number of database users in OLTP systems should be configured to at least 3 x <number_SAP processes > + 4. Java applications: The maximum number of connections to the database in the connection pool is determined for each J2EE instance (NW 7.1 is the default 70). The sum of connections (connection pool) of all J2EE instances + 4 is used to calculate the number of parallel user sessions (MaxDB parameter: MaxUserTasks). liveCache: The formula which is used to calculate the value for the database parameter MaxUserTasks for liveCaches in SCM system 4.1 and lower is: 2 x <number_SAP processes > + 4 The formula which is applied for liveCaches in SCM system 5.0 and above is: 3 x <number_SAP processes > + 4 One can also refer to 757914. |
|