Friday, May 16, 2008

Improved System Performance of your PeopleSoft system Makes a Happy User



Search questions related to Improved System Performance of your PeopleSoft system Makes a Happy User on  MyAnswerBank

If you run PeopleTools 8.4 or above and want to increase performance by eliminating extra trips to the database and unnecessary caching, then here is a PeopleSoft Performance tip that you need!


As delivered, the application server cache works by an Application server domain
using separate cache files for each process. This means, that even if one of your
users opened the GL Inquiry Page, the next user may have to cache it all over
again and this will result in additional trips to the database. However, you can
set the various psappsrv processes in a particular application server domain so
that it uses a single set of cache files rather than separate cache files for
each process. All managed objects are included in the shared cache files so that
objects are not loaded from the database multiple times. What does this mean to
you? Increased system performance and happy users!

Search questions related to Improved System Performance of your PeopleSoft system Makes a Happy User on  MyAnswerBank



Now, here is the next piece of information that will save you time and save your
users time when loading those pages. Why not load your cache ahead of time, so
that your users don't have to? In the past, many PeopleSoft customers created
scripts that would access the most commonly used pages. Some of these scripts
were created using software tools like SQA Robot and had to be created by
recording every page access. Not only did these scripts take a lot of time to
create, but they could sometimes be a nightmare to maintain considering all of
the changes, updates, and new releases that occur in your application.


Well, if you check your PeopleSoft installation CD, you will find a nifty little
Application Engine program called LOADCACHE. This is a program that will allow
you to generate and pre-load the shared cache we mentioned above.


Enabling shared cache and running the LOADCACHE program can save you disk space
and greatly speed up the performance of your system. And we all know a zippy
system means a happy user!


Here's how to run the LOADCACHE program:


1. Make sure that the database that the application server runs against

produces clean SYSAUDIT runs. If SYSAUDIT is not clean, the LOADCACHE program may fail.


2. Make sure the user who is executing the program has the "Load Application Server
Cache" component defined to its Permission List in User Profile. Find or add the
Utilities page for the users permission list and add the component Load Application Server Cache.


3. Check your psprcs.cfg file (Process Scheduler configuration file). psprcs.cfg is
where you specify the type of objects to cache using the EnableServerCaching
parameter. For PeopleTools 8.4 set it to 2. The LOADCACHE reads this setting and
caches metadata according to the value specified in the Process Scheduler configuration.


Performing these steps is easy and provides a tremendous benefit to your end users.
Follow these simple steps and you can increase your system performance by
reducing/eliminating extra trips from the application server to the database.
And most of all, make your users happy - happy - happy!

Search questions related to Improved System Performance of your PeopleSoft system Makes a Happy User on  MyAnswerBank

1 comment:

Amit Taneja said...

Hi Anand ,
Are these standards defined by the peoplesoft

Regards,
Amit