ASE optimizer behavior differences and Performance differences between ASEs: 11.50/ 11.9.2
I wish I could report that the 126.96.36.199 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 188.8.131.52/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...Reorg cause performance ASE 184.108.40.206
After we run reorg for all of our DOL tables using reorg rebuild.
Performance on ASE 11.9.2 is really bad but regain about 40GB of disk
spaces. Please, advice
Do any one know if there is problems with the reorg rebuild with ASe
reorg rebuild table_name
update statistics table_name
> After we run reorg for all of our DOL tables using reorg rebuild.
> Performance on ASE 11.9.2 is really bad but regain about 40GB of disk
> spaces. Please, advice
> Do any one know if t...ASE 11.9.2 performance on Solaris 2.6 vs Solaris 8
We have been running ASE 11.9.2 on Solaris 2.6 for last three years and it
seems fine. Lately we tested our applications (still built on Solaris 2.6)
on a faster machine running on Solaris 8. Every app runs 40% faster except
two key apps, which run even slower.
Old system: Sun Ultra 5, CPU 360 MHZ, RAM 128 MB, two EIDE 5400RPM hard
Test system: Sun Blade 100, CPU 500 MHZ, RAM 128 MB, two EIDE 7200RPM hard
11.9.2 configurations on both systems are the same. Three devices are used
on each system for master, sysprocsdev and userdata, and all are raw
par...Download Database from ASE 11.9.2 to ASE 11.0.2 ?
We have a Sybase ASE11.9.2 on Window NT, and we already run some
application on it about 6 months. Since the third party software we use
cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the
database of ASE11.9.2 then restore the backup database to ASE11.0.2 ?
Has it any problem ? Or, We must do following procedure.
1) bcp out the data from ASE11.9.2
2) create the database on ASE11.0.2
3) bcp in the 1) data to ASE11.0.2
Can anyone tell me??
The problem with dump and load is that the log format in 11.9.2 is much
diff...convert float to char (ASE 11.9.2 , ASE 11.9.3)
declare @n float
select @n = 12.001
select convert(varchar(20), @n)
Why? MS SQL 6.5 returns
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
First, when converting from an imprecise numeric (FLOAT, REAL) you
should be using
the str() function, rather than convert.
The floating point datatype cannot store 12.001 exactly.
The convert is displaying the value that is ...Best Performance ASE 11.9.2
Please can anyone help.
I am about to install ASE 11.9.2 on IBM Cluster using 2kadv server,
2gb memory 2 proc 10 18.2GB disks with 2 fibre channels
Can anyone tell me the best config to get the most performace out of this
As anyone here will tell you, the 'best' configuration is a function of the
work you intend to do on it.
A few examples:
- Is your application a DSS, OLTP or mixed workload
- Do you expect to be limited by physical io
- Do you expect a large load on tempdb
- How much use is made of stored procedures
- Are your tables DOL or Allp...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 11.9.2
my question is what would be the cause of dropping down
server performance in just 15-20 min. I had 20 users updating
the database for 5-6 hours. Then I got a call that speed
dramatically dropped down and for last 10 min only 2 users
on the system and it's very slow. I checked errorlog and
NT logs - no error messages.
Where should I look and what could it be?
Thing like that happens 3rd time for a couple of month.
Usually I restart server when it happens, but also
I restart NT server 1-2 per month as a part of maintenance
I use ASE 11.9.2 on NT 4 (sp 4)
...ASE 11.9.2 table scans and kills performance, any hints?
Our problem is that ASE 11.9.2 (select version returns: /1031/P/RS6000/AIX
4.2.1/FBO/FRI AUG 14 01:11:06 1998) does not seem to be taking advantage
of indexes and table scans largest tables in a range of queries. Update
has been done and had no effect on query plan. All indexes and foreign keys
seem to be in place. We are new to ASE and connecting from Powerbulider
example query (all '_hist' tables are scanned):
SELECT personel.per_serial, 0.01 styczen
FROM personel, wymiar_hist, etata_hist, etatb_hist...replicate ASE 11.0.3 via R.S. 11.5 to ASE 11.9.2
Has any one successfully replicated from 11.0.3 using Rep Server 11.5 to
ASE 11.9.2 using ltm's? We are running on solaris 2.6 using veritas
filesystem and keep getting stack traces (this shuts down the
I would like to know if anyone else has replicated using these versions
or something similar. Thanks.
Yes, I have done this. No specific problems.
Certified Sybase ASE 11.5 Administrator (Professional)
Certified DBA/Performance...ASE 220.127.116.11 and ASE 11.9.2 on same box
I would like to install 2 ASE servers with different versions on same linux
box. Is this possible?
Here is what I tried to do:
I have a working ASE 11.9.2 on linux box
tried to install ASE 18.104.22.168 on same box in different directory and it
gave me an error.
Wondering if this ispossible at all.
Appreciate any help.
The 22.214.171.124 rpm tries to uninstall the 11.9.2 package.
I shutdown the 11.9.2 server before install 126.96.36.199
and I do not keep the both versions running.
The variables SYBASE, LD_LIBRARY_PATH ,PATH must be correctly set to point
the...Transferring database ASE 11.9.2 -> ASE 11.5
I need to transfer a database from a ASE 11.9.2 server to a ASE 11.5
server. (Servers have the same specs and run Windows NT 4.0). The
database doesn't have many objects such as tables, users, Views, SP's
etc. etc. It has a 400 MB device for data and 100 MB Device for the log,
with standard segmentation. It's relatively small.
I understand from this newsgroup that dumping on a newer release and
loading on an older release is not an option. Now I figure I have to do
- Create a data and a log device with similar names and sizes on the ASE
11.5 se...ASE 12 running with ASE 11.9.2 and RS 11.5
I have a customer that asks the following question:
"Are there any issues running Sybase 32 and 64 bit applications on the
same box? What about replication? Is it possible for us to upgrade
to 12 repserver and dataserver on our central complex and continue to
run 11.5 repserver/11.9.2 dataserver at remotes?"
I would think that this configuration would be ok, but I thought
I'd better verify it.
Pat Proft wrote:
> I have a customer that asks the following question:...ODBC recordset performance ASE 11.9.2 versus 12.0 (select method cursor)
We are having a performance problem retrieving results back from Sybase 12
via ODBC. The simplest way to reproduce the problem is to use MS Access and
attach a Sybase 12.0 and a Sybase 11.9 table via access. There is about
16000 records in each of the tables, the Sybase 11.9 table takes 10 seconds
to open, the Sybase 12.0 table takes 75 seconds to open. The tables do not
have PK's on them. The server configs and hardware is similar.
The ODBC driver version we are using is Merant 3.50, although I can
reproduce the problem in version 3.11 as well.
The performance s...