SLOW Sybase on Win2k?

[Josie Robinson]

Check your network settings, dns, stuff like that.  You don't say if you
gave it an good old fashioned reboot after the tweaks, if not, do so.  Win2K
still needs a reboot to let go of the memory sometimes.  I don't know much
about Sybase, but databases in general are computer hogs and do a lot of
disk writing.  It always helps to put the database on a separate drive from
the OS if that is an option.  Check the cpu utilization on, on the
performance tab of task manager and see if the memory or cpu is getting
maxed out, if so look at task manager processes tab and see which processes
take up the most time.  Also, check your error logs, are you getting any
error messages (administrative tools, event viewer).  Look them up! good
luck.  josie

Josie Robinson

-----Original Message-----
From: ncsa-discussion-admin@ncsysadmin.org
[mailto:ncsa-discussion-admin@ncsysadmin.org]On Behalf Of James Brigman
Sent: Thursday, February 06, 2003 12:23 AM
To: ncsa-discussion@ncsysadmin.org
Subject: SLOW Sybase on Win2k?


Hey guys;

Had a contractor (Pitney Bowes) deliver and install a little Compaq Evo 510
this week. It uses an application that grabs data out of an onboard Sybase
database.

The accesses to the Sybase database seem to be too slow. On the order of
10-15 seconds, worst case. It's so bad that it's slowing down the entire
process that it's a part of. The guys from PB left today without resolving
the problem.

I removed a bunch of useless stuff from the O/S, but there wasn't much
performance improvement at all.

I know nothing about Sybase on Win2k. Can anyone out there shed any light?
Are there "kernel params" I need to twiddle? Some kind of optimum
performance settings? Defragging? Putting the database file on it's own
disk?

Thanks;
James Brigman


_______________________________________________
ncsa-discussion mailing list
ncsa-discussion@ncsysadmin.org
http://www.ncsysadmin.org/mailman/listinfo/ncsa-discussion