Hi All,
Have anyone have some pointers om some performance tuning on out-of-the-box ITSM v7 (SM to be specific). A client is complaining that his vanilla ITSM is extremely slow. I have not yet been at the site, nor did we implement it. I know ITSM 7 is about 30% more resource intensive than ITSM 6, (Which they were on previously) do you think they met the resource threshold or is there some performance tweaks that you are aware of that could speed up Vanilla ITSM 7? For example, Fast & List Threads, API Threads, etc etc... I must admit, I have not been on site yet but the client wants to downgrade due to bad performance and this is a small market here currently and bad rumors spread fast.

Hi,

I need more information if you want a good response...

How many concurent users?
How many records created/modified per seconds?
How many searches per seconds?
How many records in your forms?
How many CI in your CMDB?
What's your thread configuration?
Do you use private threads for ITSM 7 plugins?
Do you use private threads for reconciliation engine?
Do you use a specific box for reconciliation jobs?
What's your architecture?
What's your hardware sizing for each part (box) of your architecture?
etc...

And what are your performance goals?

Ok, I actually knew you guys are going to ask for more :-D, so let me get back to you. I thought their might be a quick Tweak trick to help them first time.

I know there is no FIXED rule for setting Fast/List Servers, but is there at least a rule of thumb? And also for API Threads (Like when using Web Services)

Thanks for the prompt response :-)

The general quick rule for threads usage is :
* Fast & List min : # of CPUs
* Fast max (no more than) : 3 * # of CPUs
* List max (no more than) : 5 * # of CPUs

No more than 2 of difference between min and max.

Private queues threads configuration depends upon their utilization.

A general rule can be the following : Create private queues for :
* DSO
* Reconciliation Engine
* CAI Plugin
* Webservices
* Specific API programs
* Large imports

Look at ITSM 7 whitepapers. There is a performance whitepaper.

Ok Thanks,

Quick update

Client has ITSM 7 (SM, AM & CM) (Clean Install, phase 2 is to migrate old data to new version)
Hardware:
Solaris 9, Oracle 10g r2
1 x E25K Board
Everything is on one server
Only using SM (Incident Mainly) currently
Max of 13 concurrent users (for now)
Everything is fast except if you submit or modify. Menu's is fast, Window's open up quickly etc etc. Even the Admin tool is instant (except listing 22'000 active links)
As soon as you submit records (all of the record have attachments, which seems to be the culprit) it takes more than a minute to submit.
If I modify (and delete) attachment, it is instant aswell, but if I modify and add, same issue

How does the LOB and CLOB work and as what should it be set etc etc?

Regards

Is it big attachments?

Try to log API and SQL in same log and see if it's a network problem (API and SQL response time are quite fast) or if it's a database problem (SQL response time is quite long)...

Did you create attachment fields on main forms? Why not using the workinfo for attachments? This has been design to prevent attachments on main forms and performance problems...

between 100KB and 400KB (I used to attach 2MB files MUCH faster than this)
Could this be that the Large Object (LOB) is not set up properly, I think it is a definite DB issue, Selects are fast but update and insert is slow (when Large Objects are involved)
They even got a ARS timeout when adding a 800KB attachment
Like I said everything else is fast, Even making changes in the admin is fast. I've created a test form (with attachment) to create a record is less than 1 second, to create an attachment with < 100KB, it takes more than 1 minute.
Where can I read up on the LOB and CLOB (in-row CLOB tickbox in ARAdmin is not ticked).
I'm currently on the go so I don't have all my resources (PDF's and tools) with me which makes it even worse :-) I'm not an Oracle expert so if anyone can help me with this, I would appreciate it dearly.

Thanking you in advance

See with you DBA to improve that. The attachments are stored in BxxxCyyy tables.

See the configuring guide, there are some specific configuration parameters for Attachment tuning on Oracle database. Check these parameters with your DBA...

Check in the arstruct.h file to see if there are no specific undocumented configuration parameters on this point and ask support for the usage of these parameters...

I don't see it?
Only get FTS and B,BC,(T & H) table SQL queries related to attachment fields?