ASE 220.127.116.11 / SWR 8775 UPGRADE TO ASE 18.104.22.168/EBF 10628 PERFORMANCE PROBLEM
We recently upgraded ASE 22.214.171.124/SWR 8775 to ASE 126.96.36.199/EBF 10628.
Some queries stopped returning resultsets. Recompiled the stored procs which
fixed the issue.
But the queries are running slower now. The overall performance of the app
has become sluggish.
The CPU is generally running higher as well!
Have also set LD_LIBRARY_PATH_64 to include the new Solaris 8 threads
Anybody any insights into this? How can we get back to the pre-upgrade
performance levels short of rolling back the EBF.
I guess 188.8.131.52 requires some Solaris ...Problems using BCP from within a stored procedure in ASE 12
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
We are testing our application on Sybase 12, and we ran into a
Our application uses a stored procedure to import and export data
out of the database. Within the stored procedure we call XP_CMDSHELL
to execute the BCP command line:
EXEC PROC_CALL_XP_CMDSHELL @CMD, @OK output
CMD contains the command line and is of the format:
'...\BIN\BCP.EXE DB..STAGING_TABLE in filename -U user -P pswd -S ...Performance Degradation after ASE 12.0 upgrade to ASE 12.5
There was a issue posted on 08/06/2002 by 'Bob' related to performance
degradation after upgrade of ASE 11.9.2 to ASE 12.5. I would like to know
whether anyone has found any solution/workaround
to resolve those issues without making any changes in the application code.
We are also facing the same problems here after upgrade of ASE 12.0 to ASE
12.5. The program which takes 10 mins. on ASE 12.0 is taking more than 3
hrs to finish on ASE 12.5 despite of using the same indexes and the program
which takes 3 hrs on ASE 12.0 is taking more than 24 hours on ASE 12.5. ...Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...ASA and ASE stored procedures -- problems with..
This is a multi-part message in MIME format.
Has anyone encountered differences with ASA and ASE stored procedures =
using temporary tables (select colA into #temp_table from app_table
where...). I created several stored procedures while using ASA which =
have been migrated to ASE.
I am running into some peculiarities with what worked in ODBC and now =
not work in the Enterprise. This is for both sto...ASE 12: Performence problem login
The time for a login (via JConnect) to our ASE 12 server varies from 150 ms
to 6000 ms.
Do we need more CPU or what?
...Performance Problem in ASE 12.5
We upgraded from ASE 184.108.40.206 to ASE 12.5 EBF#1. This is in QA environment.
The Server performed well for about 2 weeks and then the CPU % shot up to
about 100%. More specifically weblogic was causing table scans in the
database. Unfortunately I did not take a snaphot of the sysmon before I
recycle the server. Recycling the server seem to have fixed the problem. But
I am looking for a more concrete root cause. Is there a known memory leak
issue in ASE12.5.
Having any rep agents on the server?? maybe you should upgrade to latest EBF
getting all known bugs fixed.
Ke...Differences between ASE 12 and ASE 12.5
I am in the process to migrate mi ASE from version 11.5.1 to an upper one.
I am thinking that the logic step is to go to ASE 12, but I was wondering
about the version 12.5. would there be any strong reason why I should
choose to upgrade to version 12.5 other than just jumping to a newer
version than 12. ?
What are the main differences between ASE versions 12 and 12.5?
greetings !! =:D
We are going from 11.9 to 12.5, skipping 12.0. We have two reasons. First,
because we are tired of making regular upgrades and figure we can stay on
12.5 for years whereas...ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
ASA supports a fairly large sub-set of Transact-SQL, so if you write your
stored procedures and triggers in ASA using T-SQL, you should be able to
create scripts that will run against both ASE and ASA. If you're planning
to do this though, I would suggest developing your database schema against
ASA, since everything you write in T-SQL in ASA will be supported on ASE,
but the reverse is not true.
Check out the section in the ASA documentation entitled "Tra...ASE to ASE
Is anyone out there doing ASE to ASE replication using SQL remote? If
you are have created your own version of the SSEXTRACT utility to set up
a replicant database in ASE rather than ASA? Or does anyone know if
SYBASE has created a version SSEXTRACT for use with ASE to ASE
Thanks in advance
I thought the SQL Remote Replication support in ASE11.5 was meant for a
consolidate-database only (by design)! At least that was what Sybase
said when they announced support for SQL Remote technology support in
I will be happy to...Problems with restoring from ASE 11.9.2 to ASE 12.0
We have a production machine which we did a full backup to a tape.
It is running ASE 11.9.2 on Solaris 2.6.
We are trying to restore the master and production db to a new machine
running ASE 12.0 on Solaris 8.
The mapping between the logins and the users were mismatched.
Has anyone seen this problem before?
If so, what is the solution?
Thanks in advance
Tony Keith wrote:
> We have a production machine which we did a full backup to a tape.
> It is running ASE 11.9.2 on Solaris 2.6.
> We are trying to restore the master and productio...Performance issues after upgrate ASE 11.5 to ASE 12.5
How can we improve performance?
We're moving a database that was operating fairly well on a HP-UX 10.20 with
Adaptive Server Enterprise v. 11.5 (32 bits) to a HP-UX 11.0 with Adaptive
Server Enterprise v. 12.5 (32 bits)
Our problem is the slower performance of the database on the new, more
powerful and faster machine with newer software (in both operative system
and sybase version)
We've noted that it starts really fast but slows down gradually.
We�ve tried many ways to improve the performance:
-Increase the max memory.
-Increase the number of engines at startup...ASE 12.5 vs ASE 11.5 performance issues
Again my question is about performance of ASE 12.5 against 11.5.01
We have a huge production client-server application running on W2K server
with ASE 220.127.116.11 database (more than 400 tables, 2000 stored procedures).
The database was placed on raw disk partitions (no RAID) and split between
different physical drives as follows: data, log, tempdb and master database
are located on different drives.
We have two PIII, 1GHz, 1 GB of memory and give 800MB for ASE. We create
separate tempdb cache and bind tempdb to it. Database was bind to default
Then we want to switc...Cursors in Stored Procedures ASE 12.0
I have a Stored Procedure that will have 2 cursors. The
first cursor is the main and then there will be another
cursor within. But I keep getting a message stating that I
was trying to use the second cursor but it was not open.
If you have another suggestion, please let me know.
Here is the Stored Procedure:
declare @audit_dt smalldatetime,