If you use this configuration i need to speak with you can you contact me please

patrick.st-pierre@dsf.ca

thanks

Hi,

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

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.

With a french and english installation ...

Hi,

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

Are your Oracle stats up to date?

Yes .. exactly the same thing ...
and yes the stats are up to date ...

Hi,

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

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 ?

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,

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 your right ..

the cpu of the the windows Server is : 4 pross intel xeon 2.7 ghz
with 8 gig of ram
OS wwindows 2003

For the unix box : 1 proc 1000 hz 2 core
cpu type : pa 8900 cpu module 3.2
processor type Pa-RISc
Memory 24 gig
OS HP-UX 11.11

thanks

Pat,

I would turn on API, SQL, and Filter logging specifically when you are testing the above-mentioned functionality. Then run the logs through the ARLogAnalyzer tool (there's a link to its location on the developer network in another thread/response today) to see if you are running into a thread availability issue or possibly an indexing issue with your filters.

Let us know!

Here's the link: http://developer.bmc.com:8080/jiveProd/entry.jspa?externalID=2973&categoryID=507

thanks, but we have an issue open with bmc since 2 mounth .. and i just need to know if other company improve performance problem with an oracle database ans SLM 7.01 .....

if i understand vincent correctly, he says this work correctly in other company ... exactly same thing ITSM7 with slm7 and oracle database ...

you matt you already try this combination ?

I know we have customers set up similarly and I have not heard of major performance issues, but I'm a bit removed from the actual configurations of those servers, so I couldn't say for sure if the installations match yours or not.

Matt, I know that's the default, but I used to configure it myself...

Pat,

Could you post here your ar.cfg file?

To log the API and SQL is definitively a good idea...

Plugin: "D:\Program Files\AR System Applications\LNAP36PP\BMC Service Level Management\bin\omfobjiefilapi.dll"
Plugin: "D:\Program Files\AR System Applications\LNAP36PP\BMC Service Level Management\bin\arfslasetup.dll"
Plugin: "D:\Program Files\AR System Applications\lnap36pp\BMC Remedy Incident Management\bin\caieventcmd.dll"
Plugin: "D:\Program Files\AR System Applications\lnap36pp\BMC Remedy Incident Management\bin\ardbcQuery.dll"
Plugin-Path: D:\PROGRA~1\ARSYST~2\lnap36pp\BMCREM~1\bin;D:\PROGRA~1\ARSYST~2\LNAP36PP\BMCSER~1\bin;
Plugin: "D:\Program Files\AR System Applications\lnap36pp\BMC Remedy Incident Management\bin\arfcbdata.dll"
CMDB-Install-Directory: D:\Program Files\AR System Applications\lnap36pp\BMC Atrium CMDB
RE-Log-File-Location: D:\Program Files\AR System Applications\lnap36pp\BMC Atrium CMDB\Logs
AE-Trace: ON
AE-Trace-File: D:\Program Files\AR System\lnap36pp\Arserver\Db\AeTrace.log
AE-Log-File: D:\Program Files\AR System\lnap36pp\Arserver\Db\ae.log
AE-Log: ON
Alternate-Approval-Reg: T
Application-Enable: T
Plugin: arapprove.dll
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\arapi70.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\axis.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\log4j-1.2.8.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\websvc70.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\wsdl4j-1.5.1.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\xercesImpl.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\xmlParserAPIs.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\commons-logging-1.0.4.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\commons-discovery-0.2.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\jaxrpc.jar;
ARF-Java-Class-Path: D:\Program Files\AR System\lnap36pp\saaj.jar;
Plugin: WebService.dll
Plugin: areahub.dll
Plugin: ardbcldap.dll
Plugin: ardbcconf.dll
Plugin: FlashboardObject.dll
Plugin: ServerAdmin.dll
Plugin: reportplugin.dll
Register-With-Portmapper: T
Server-Name: lnap36pp
Oracle-Two-Task: RMDP
Currency-Ratio-Client-Refresh-Interval: 60
Multiple-ARSystem-Servers: F
Server-directory: D:\Program Files\AR System\lnap36pp\Arserver\Db
DSO-User-Password: MGFN/y2DEWmpB+EyupN8F1O4lEMAcmlFEYDck+TDka3bOwb+4XjRsN7ozAhiih4TFTbicx8iWVsO15ndfd/0xydY86vhm5t0skW7VXaKKlEXpn8TzIH7Ig==
Remedy-App-Service-Password: JCgLNMbU+Lh8U1nyIxVxvCzLVZ92gDnDuwDU+OOT77o5Tfrp4MskJtQ2GlsZIoZjGmnTOESRPyYTrq9ONcWwmAqUfvRltQqLswvxf5AjD+cAvHHtJkUfeA==
Mid-Tier-Service-Password: NC/scfUHIfWMLRGSuRsBRxr4QP3ePX/ItHXhmBJ6AatUwjI+q/GNh0iNkd8ZF0JWJXQYA6SHw5GnyfZlGXZTYYR3gaplwWYXg2YqGgCOD/NAbheiYqjFbg==
Filter-Max-Total: 200000
Filter-Max-Stack: 10000
Oracle-Cursor-Sharing: FORCE
Localized-Server: T
Load-Shared-Library: cmdbsvr20.dll
Load-Shared-Library-Path: D:\Program Files\AR System Applications\lnap36pp\BMC Atrium CMDB\server\bin
Plugin: "D:\Program Files\AR System Applications\lnap36pp\BMC Atrium CMDB\server\bin\libcmdbconsolefilterapi20.dll"
Plugin-Loopback-RPC-Socket: 390626
Delay-Recache-Time: 2
Record-Server-Events: 1;
Email-Import-Form-By-Default: T
Allow-Guest-Users: F
Default-Web-Path: http://lnap36pp/arsys
Crossref-Blank-Password: T
ARBDC-LDAP-Base-Dn: OU=DSF,DC=avdl,DC=com
ARDBC-LDAP-Use-Cache: F
ARDBC-LDAP-Cache-MaxSize:
ARDBC-LDAP-Cache-TTL:
ARDBC-LDAP-Cert-DB:
ARDBC-LDAP-User-DN: csitsm7
ARDBC-LDAP-Connect-Timeout:
ARDBC-LDAP-Hostname: avdl.com
ARDBC-LDAP-Page-Size:
ARDBC-LDAP-Password: rmhymSjG3l1jLjOEztiCXpjg+95VYSf8VR+pfSk2nZfFynNApnnP5TICYH7LtNWV4BiZA7I5EAogxXKx9pjBqlfq425TgoQPDRMcAHM9h2aBsHglLJRBXQ==
ARDBC-LDAP-Port: 389
ARDBC-LDAP-UsingSSL: F
ARDBC-LDAP-Time-Format: 1
Submitter-Mode: 1
Private-RPC-Socket: 390620 4 12
Private-RPC-Socket: 390626 4 6
Private-RPC-Socket: 390627 2 2
Private-RPC-Socket: 390635 4 12
Next-ID-Block-Size: 10
Disable-Alerts: F
Max-Entries-Per-Query: 0
Oracle-Clob-Storage-In-Row: T
Plugin-Port: 64001
Server-Plugin-Alias: ARSYS.ARDBC.LDAP-DGI ARSYS.ARDBC.LDAP localhost:64002
AREA-LDAP-Bind-Password: eZXrxTNseG9x41qQxxOZXGSA+jFyxZXCcF+tjz7Tfl39a/GcqA5IUAfmgp/YT2M1xWYwjFKiyX9uNps1cQcRoK3IAqG3WXcS9qQAlKmohRu9eaxaRm9N9w==
AREA-LDAP-Bind-User: csitsm7
AREA-LDAP-Port: 389
AREA-LDAP-Hostname: avdl.com
AREA-LDAP-Use-Groups: 0
AREA-LDAP-User-Base: OU=DSF,DC=avdl,DC=com
AREA-LDAP-User-Filter: cn=$\USER$
AREA-LDAP-Chase-Referral: F
AREA-LDAP-UseSSL: F
AREA-Hub-Plugin:
AREA-LDAP-Bind-Password_1: 98zVytvWqUz61wE6U1SCwfxUIx1vlUvBnBAqw+QDJ85ngE3/StSaLFD8hPmLaWj+pbUu7RZb+DviFWsWcZVcQwv5imoa+7nb8h8OmulgqcoUt4tv/dIO6A==
AREA-LDAP-Bind-User_1: cstitsm7
AREA-LDAP-Port_1: 389
AREA-LDAP-Hostname_1: dgi.intra
AREA-LDAP-Use-Groups_1: 0
AREA-LDAP-User-Base_1: OU=DSF,DC=DGI,DC=intra
AREA-LDAP-User-Filter_1: cn=$\USER$
AREA-LDAP-Chase-Referral_1: F
AREA-LDAP-UseSSL_1: F
Disable-Escalations: F
Plugin-Log-Level: 2000274632
Escalation-Log-File: D:\Program Files\AR System\lnap36pp\Arserver\Db\automate3.log
SQL-Log-File: D:\Program Files\AR System\lnap36pp\Arserver\Db\BMC24asvril.log
Cache-Mode: 1
Filter-Log-File: D:\Program Files\AR System\lnap36pp\Arserver\Db\2avril.log
API-Log-File: D:\Program Files\AR System\lnap36pp\Arserver\Db\2avril.log
Debug-mode: 0
Admin-Only-Mode: F
Homepage-Form: Home Page

Just to be sure vincent you mention to me, you already have installed
Oracle database with itsm 7.01 and SLM 7.01 without any performance problem ?

thanks

Yes and in a french environment too

I used to configure the following for up to 200 concurent users:
* A private queue with 8 min and 10 max dedicaced to the CAI.
* CAI configured to use that queue
* A private queue with 8 min and 10 max dedicaced to the RE.
* RE configured to use that queue
* Configure the Plugin-Filter-API-Threads to 4 min and 6 max
* Configure the Plugin-ARDBC-Threads to 4 min and 6 max
* Remove all the usused workflow with the Advanced Admin Tool (which is available here)
* Configure correctly the QBE match option for inefficient indexes based on system fields with the Advanced Admin Tool
* Separate live Indexes and data in different tablespaces with the Advanced admin tool
* Separate Audit, workinfo indexes and data in different tablespaces with the Advanced Admin Tool

I hope that helps

what is you server specs ? for the database and ar server ?
And whats is the cpu iddle in the database server
thanks

Where i can seperate the audit, workinfo indexe and data in different tablespaces, from the admin tools ?

thanks alot

Pat,

Vincent is referring to his Advanced Admin Tool. http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_view/gid,25/Itemid,28/

thanks it is possible the .zip is broken 6 i can't unzip it ....

Pat, please try again. There was a permission issue on the file, which has been fixed.

Thank you,

Vincent, do you think it is possible to have a phone conversation with you and my project manager ?

we are suppose to be in production since february 2 ... long time ago .. i can find a way to give you a free phone number if you don't want to give me yours ...
I think you speak french too ?

you cna email me directly if you want
patrick.st-pierre@dsf.ca

Server specs :
2 * Mid-Tier : 2 CPU 4Go Linux
AR : 4 CPU 8Go Linux
DB : 4 CPU 8Go Linux + SAN storage

The CPU idle of the DB server depends of the usage :
* Normal User usage : 70% idle
* Reconciliation : 0% idle

Yes, I speak french as it's my native language

And that's possible...

I'll send you an email so, we can follow by mail and phone.

nice im waiting your email ...