Re: Performance issues with Sybase-Unix-SQR

[Tim Green <Tim_Green@MERCER.COM>]

We use SQR with Sybase on an HP 9000 series box without any problems, and it's
certainly faster than running on the client.  The first thing I'd look at is how
much memory is available on the server when Sybase is running.  Has the DBA
allocated so much memory to the SQL Server that little is available the SQR
processes running on the box?  If Unix doing any page swapping of Sybase or SQR?

Good luck,

Tim Green                                           Tim_Green@mercer.com
Administrative Solutions Group
An ADP/Mercer Alliance



>-----Original Message-----
>From: SQR-USERS@USA.NET
>Sent: Wednesday, September 02, 1998 1:26 PM
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Performance issues with Sybase-Unix-SQR
>
>
> I am working on a team implementing  PeopleSoft HRMS,Payroll,
> & BenAdmin (v7.1 Tools 7.02) project. I have questions on what
>others are doing to tune the running of processes on the server. I have
>SQRs running on the client faster than the server!  I know there is
>something wrong somewhere!  We have SQR 3.0.18.1Sybase 11.9.1
>and HP Unix 10.2,HP- 9000. The Unix and Sybase area are not that
>experienced,
> so I am trying to find out any "tips/hints/how-to's"  that
>will help out.
> Thanks in advance!
>
>Theresa
>