Page 1 of 3 1 2 3 >
Topic Options
Rate This Topic
#139902 - 05/02/08 12:25 PM ITSM 7 + SLM + Oracle database
PAT30 Offline
Stealth Member

Registered: 03/09/07
Posts: 157
If you use this configuration i need to speak with you can you contact me please

patrick.st-pierre@dsf.ca

thanks

Top
#139909 - 05/05/08 02:17 AM Re: ITSM 7 + SLM + Oracle database [Re: PAT30]
Vincent_RIEDWEG Offline

Old Hand
****

Registered: 05/24/05
Posts: 1454
Loc: France
Hi,

I have already implemented similar configurations. What's your problem?
_________________________
Vincent.

Top
#139914 - 05/05/08 10:20 AM Re: ITSM 7 + SLM + Oracle database [Re: Vincent_RIEDWEG]
PAT30 Offline
Stealth Member

Registered: 03/09/07
Posts: 157
Really bad performance, when we submit a ticket with 2 or more service targets attached ...

If we do a performance test with 5 user creating ticket where they have 2 service targets attached, we can see the unix server like 5 or 6 connecting taking more than 20 % of the CPU, and the user response time after each submit is like 5 to 12 seconds.

Top
#139915 - 05/05/08 10:28 AM Re: ITSM 7 + SLM + Oracle database [Re: PAT30]
PAT30 Offline
Stealth Member

Registered: 03/09/07
Posts: 157
With a french and english installation ...

Top
#139916 - 05/05/08 11:38 AM Re: ITSM 7 + SLM + Oracle database [Re: PAT30]
Vincent_RIEDWEG Offline

Old Hand
****

Registered: 05/24/05
Posts: 1454
Loc: France
Hi,

Have you configured Oracle as BMC said in a BSM performance whitepaper?

Are your Oracle stats up to date?
_________________________
Vincent.

Top
#139917 - 05/05/08 11:42 AM Re: ITSM 7 + SLM + Oracle database [Re: Vincent_RIEDWEG]
PAT30 Offline
Stealth Member

Registered: 03/09/07
Posts: 157
Yes .. exactly the same thing ...
and yes the stats are up to date ...

Top
#139918 - 05/05/08 11:43 AM Re: ITSM 7 + SLM + Oracle database [Re: PAT30]
Vincent_RIEDWEG Offline

Old Hand
****

Registered: 05/24/05
Posts: 1454
Loc: France
Hi,

What's your AR Server threads configuration and both servers sizing?
_________________________
Vincent.

Top
#139919 - 05/05/08 11:53 AM Re: ITSM 7 + SLM + Oracle database [Re: Vincent_RIEDWEG]
PAT30 Offline
Stealth Member

Registered: 03/09/07
Posts: 157
name / Min / Max / program number

Admin 1 / 1
Fast 4 / 12
List 4 / 12
Private 4 / 6 390626
private 2 / 2 360627

what you mean by both servers sizing ?

Top
#139920 - 05/05/08 12:24 PM Re: ITSM 7 + SLM + Oracle database [Re: PAT30]
Vincent_RIEDWEG Offline

Old Hand
****

Registered: 05/24/05
Posts: 1454
Loc: France
What's the usage of 390626 & 390627?

Did you define Plugin-Filter-API-Threads and Plugin-ADBC-Threads?

Which RPC queue is used by the RE and the CAI?

I mean CPU and RAM...
_________________________
Vincent.

Top
#139921 - 05/05/08 12:58 PM Re: ITSM 7 + SLM + Oracle database [Re: Vincent_RIEDWEG]
Matt Reinfeldt Offline
Old Hand
***

Registered: 06/12/01
Posts: 1419
Loc: Madison, WI
Vincent,

390626 is typically used for the Plugin/Loopback RPC Number (Server configuration). You can add/remove threads for this by defining it as a Private Queue, as it appears Pat has done.

Not sure if you meant the 'standard' usage of that port or how Pat is using it, specifically. \:\)
_________________________
Matt Reinfeldt
I belong to the following Professional Networks:
http://www.naymz.com/search/matt/reinfeldt/1524717
http://www.linkedin.com/in/mreinfeldt

Top
Page 1 of 3 1 2 3 >