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...ASE performance
I'm new to Sybase, so excuse me if this is a stupid
question, and I guess I might not supply enough information
to make an informed judgement ...
We've got ASE 12.0 running on a Sun Sparc server with 2 x
450Mhz processsors and 2 gig RAM + RAID. We run a script
which updates a join table - i.e. a table with two integer
columns with keys in them. The sql script inserts a total of
1.8 million rows into the table and the entire operation
takes around 18 minutes to complete.
Does this sound like reasonable performance - it feels slow
to me, but I don't have any comp...ASE 15 Performance and Tuning Guides
Does anyone know when the updated ASE 15 versions of
"Performance and Tuning Guides" will be released?
The guides on sybooks are for ASE12.5.1
Thanks in advance.
> Does anyone know when the updated ASE 15 versions of
> "Performance and Tuning Guides" will be released?
I *think* that they were supposed to be released sometime
later this year, but I don't have any clear information.
I'm not aware of when these will be released. I'm guessing some time after the
Hi there, ask a rather beginner question here.
we have this ASE12.0 on Solaris 7. it's a enterprise 3000
machine, with 1G RAM, 2 CPUs both 168MHz. via /etc/system
assigned 800M to ASE. All other settings in the configure
file are mostly DEFAULT.
we donot have many concurrent users on system most of the
time, and the workload/ transaction is not very high. (most
time, just 50 to 60 users online).
however, lately users complains performance problem. esp
just only one user was running a little big large report.
and when I check sp_lock, actually very few locks, and just
some shared...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 126.96.36.199 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...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. ...Performance advantage of ASE 64 Bit over ASE 32 Bit version
Is any there any performance gains when using ASE 64 bit
versus ASE 32 bit version like larger memory gains hence
The more memory , the more data you can cache, the better performance.
<Jayesh> wrote in message news:firstname.lastname@example.org...
> Hi Folks,
> Is any there any performance gains when using ASE 64 bit
> versus ASE 32 bit version like larger memory gains hence
> good performance?
> The more memory , the more data you can cache, the better...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...Performance issues after upgrate ASE 11.5 to ASE 12.5 #2
How can we improve performance?
We're moving a database that was operating fairly well on a Sun 3000 with=20
Adaptive Server Enterprise v. 11.5 (32 bits) to a Sun 10000 with Adaptive=20
Server Enterprise v. 12.5 (64 bits) and Solaris v. 8
Our problem is the slower performance of the database on the new, more=20
powerful and faster machine with newer software (in both operative system=20
and sybase version)
A particular query with insert used to work for about 2 hours in a Sun 3000=
with Adaptive Server Enterprise v. 11.5 (32 bits).=20
In a Sun 10000 with Adaptive ...ASE optimizer behavior differences and Performance differences between ASEs: 11.50/ 11.9.2
I wish I could report that the 188.8.131.52 ASE is performing better then our
11.50 AS instances, but then I would probably not be submitting this post.
I have two similar ASE instances which appear to have identical
table,indexes,segments,devices. The row counts of the two tables are only
off by 1000 and that is expected. Showplan reveals that the optimizer is
behaviing very differently between the two instances , not supprised. The
new 184.108.40.206/1175/P/SWR/9520 ASE is performing poorly and I can not proced
with upgrading my other servers to 11.9.2 untill I accertain the performanc...Diferrence of performance on queries betwenne a ASE 220.127.116.11 and ASE 12.0
I'm on the way to migrate from ASE 18.104.22.168 (on HP-UX 10.0) to ASE 12.0 (64=
bits on HP-UX 11).
My tests shows good and bad performance with queries.
I'm very interesting with yours.
Can you tell me about them.
There are major functional changes in ASE 11.9.2 and above. I'm glad to see
How did you get the data to 12.0?
Have you turned on any of the 12.0 options?
HAve you attempted any tuning?
What, if anything, have you done so far?
If you have a specific problem query that can b...Check List for ASE 11.9.2 Performance Tuning
We need to troubleshoot the performance issue in an ASE 11.9.2 server.
During the system in a slow response time state, about 20 Sh_page locks (Non
Cursor Lock) found on the syslogins when I execute the sp_lock.
Can anyone give me some advise on which areas I should check first (may be a
check list) ?
You might want to read through the Performance & Tuning guide for things
like query performance management with things like sp_showplan and
What you could consider is this. Any running task may be running with a
bad query plan. Her...ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to
ASE and ASE To ASE ?
You should start with the Help file and then ask specific questions:
Data Replication with SQL Remote
PART 5. Appendix
APPENDIX A. Enterprise and Anywhere: Differences
There are many differences, so begin there.
Please only post to the newsgroup
BH Ong <email@example.com> wrote in message
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...