[More parameter Info]
maxservertasks = 20
maxusertasks = 50
maxlocks = 2880
Log mode = DUAL
[More server info]
CPU = 950MHz (Duron or Athlon, can't remember)
RAM = 768MB
HDs = 2 IDE drives (30GB & 80GB)
a) I have 12 sessions of the user. (user isn't exclusive)
I am running a connection pool whereby these connections are
pre-established. (may need to change this)
b) Many table locks (7938005) w/ row locks (53498035)
Request timeout = 5000 (83 mins), this seems high.
The high table lock count could be due to a data import I ran.
c) Only have a single CPU machine but looking to get a dual.
I will tweek some of the stuff you mentioned. Thanks mucho, I appreciate the
advise.
Kevin
-----Original Message-----
From: Schroeder, Alexander [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 9:30 AM
To: Kevin Wilson; Sapdb General List (E-mail)
Subject: RE: 1 Process handles 99.9% of load ...
Hello Kevin,
Does that '99.9 %' mean the webapps are idle, and there is only 1 session
a one time visible in dbm (If yes, see (a))?
please check that
a) the users accessing the database are created with NOT EXCLUSIVE,
otherwise
only one session for that user can be established at a time.
b) whether there is something to see in LOCKSTATISTICS, especially
table locks. If there are table locks due to selecting large result sets,
you may try to increase the MAXLOCKS parameters.
c) On a multi-CPU machine, you should set MAXCPU to the number of CPUs to
be used for the database.
Regards
Alexander Schr�der
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: Kevin Wilson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 03, 2003 4:15 PM
> To: Sapdb General List (E-mail)
> Subject: 1 Process handles 99.9% of load ...
>
>
> but makes other requests wait even though there are 50
> processes allocated
> to handle connection requests.
>
> [System]
> SAPDB v7.3.0.34 (w/ corresponding JDBC driver)
> SuSE v8.1
> Java v1.4.1_01
> Tomcat v4.1.18
>
> [Background]
> I have two jsp webapps that access a single sapdb instance
> but each with a
> different user account that own their respective application database
> objects.
>
> ***One app uses SSL and the other does not.***
>
> [Issues]
> One process seems to be handling 99.9% of all the service
> requests. This
> holds true even when other requests are waiting to be
> serviced while this
> one process is busy.
>
> A second problem is that it seems that read queries are
> locking down tables.
> I may be mistaken but we have one table that is huge and whenever an
> intensive query is ran it locks out other users wanting to
> access the table
> with a read query.
>
>
> Any advice on parameters to tweak, etc. would be appreciated.
>
> Thanks,
>
> Kevin
>
> "Those who would give up essential liberty to purchase a
> little temporary
> safety deserve neither liberty nor safety."
> -Benjamin Franklin, 1759
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
