Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

New to Peoplesoft CRM

New to Peoplesoft CRM

New to Peoplesoft CRM

OK i'm a SQL DBA by trade and I'm trying to do some optimization on a Peoplesoft CRM application.  Alot of the long running queries look something similar to this

declare @P1 int
set @P1=180154885
declare @P2 int
set @P2=8
declare @P3 int
set @P3=1
declare @P4 int
set @P4=98
exec sp_cursorexecute 4974, @P1 output, @P2 output, @P3 output, @P4 output, 'Reloans', 'May  3 2004  7:54:31:000AM'
select @P1, @P2, @P3, @P4

Which doesn't give me anything I can use.  What I'm hoping is that you bunch of experts (required suck up :) hehee ) would be able to help me figure out how to pick this apart so I can find out what this process is actually running.

Thanks in advance!!!

Colin in da 'Peg :)

RE: New to Peoplesoft CRM


PeopleSoft CRM is the latest and greatest in programs.  With it come a lot of childhood issues: the data scheme is so weird and complicated (to enable data object flexibility, of course) that optimization is very dependent on the amount of data and which modules you use.

One of my clients had terrible performance problems.  They called PeopleSoft's customer satisfaction group, and got assigned a PeopleSoft CRM 'Development Swat Team' to evaluate performance bottlenecks.  One month later, they are still optimizing.  Contact Mark_Dirriim@Peoplesoft.com for info on how to use his services.

Contact PeopleSoft because this optimization stuff is soooo iterative and the knowledge at PeopleSoft is limited to such a few people.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close