Performance issues after upgrate ASE 11.5 to ASE 12.5 #2

Hi

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=
=20
with Adaptive Server Enterprise v. 11.5 (32 bits).=20
In a Sun 10000 with Adaptive Server Enterprise v. 12.5 (64 bits) and=20
Solaris v. 8 it takes near to 5 hours to complete.

We've noted that it starts really fast (as if it would take about 15=20
minutes) but slows down gradually. The priority changes from meduim to low.

We=B4ve tried many ways to improve the performance:

-Increase the max memory.
-Increase the number of engines at startup and online.
-Increase the procedure cache size.
-Increase the default data cache.
-Segment and create a named cache for tempdb.
-Add more network memory.
-Increase the size of the default network packet size.
-Create a segment for the biggest user table on the database, which we're=20
using for tests, and separate data and indexes on different devices.
-Create a set of 16K pools for various named caches.
-Create a new execution class for a special very time consuming query (an=20
47000 row insert)=20
-Create again index, stored procedure, triggers and tables.
-We install the patches that are available in Sybase.com for the version=20
12.5 to 64 bit

There is no contention because we're in tests and this query is the only=20
process running on the machine.

Now we have the same problem!.

->Is there any problems with this combination of versions (maybe we're=20
lacking additional software) of Adaptive Server and Solaris?

->Is there any combination of performance changes that works best?

Thanks
0
Richard_M
4/12/2002 3:10:49 PM
sybase.ase.upgrades+migration 687 articles. 0 followers. Follow

1 Replies
1553 Views

Similar Articles

[PageSpeed] 17
Get it on Google Play
Get it on Apple App Store

This is a duplicate post of cross-posted message.  It is already being discussed in another 
newsgroup.  Please do not add to this thread.  Instead, answer in the other newsgroup.
-- 
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services
0
Jim
4/13/2002 4:59:46 AM
Reply:

Similar Artilces:

Performance issues after upgrate ASE 11.5 to ASE 12.5
Hi 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
Hi All, 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 11.5.0.1 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 data cache. Then we want to switc...

Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, 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? Potential options: 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...

Upgrading ASE 11.9.2 to ASE 12.5 on Solaris 5.6
Does anyone have problems upgrading ASE 11.9.2 to ASE 12.0 on Solaris 5.6. I know that are issues with upgrading on Solaris 2.5, but what about Solaris 5.6? Thanks, Hang ...

Migration from ASE 11.5 to ASE 12.5
Hello I am planning the migration from Sybase 11.5 to 12.5. Can someone point me to some documentation on the subject? I am particularly interested in documents that explain the best way to migrate database objects (tables, indexes, etc...) and data. Thanks in advance. Jorge Vergara Sispro S.A. Canoas - RS - Brasil jlvergara@sispro.com.br wrote... > Hello > > I am planning the migration from Sybase 11.5 to 12.5. Can someone point > me to some documentation on the subject? > I am particularly interested in documents that explain the b...

Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 bits) Thank you kamel wrote: > Here there someone to indicate me the road tasks in order to > migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 > bits) > > Thank you Apply 12.5.2 IR then 12.5.3 esd 5. -- Jason L. Froebe http://jfroebe.livejournal.com http://www.propsmart.com Team Sybase On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote: > Here there someone to indicate me the road tasks in order to migrate an > ASE 12.5.0.2 ...

ASE 11.9.2 to ASE 12.5.0.3, inplace upgrade issues
Hi We have migrated one of the Sun boxes running ASE 11.9.2 on Solaris 2.8 to ASE 12.5.0.3 ESD#3 . We did a inplace upgrade. The "sqlupgrade" utility did all pre-checks and came out clean and did the migration and it came out with a "Done" message.But it gave a message saying that the server couldnt be brought up, and seeing the error log we have seen the shared memory was a problem and we chaged the value and the server came up fine when we brought it up manually using the 12.5.0.3 binaries. Few issues which are stopping us to proceed further.. Issue 1) T...

Upgrade from ASE 11.9.2 to ASE 12.5
we are on solaris 8 and would like to upgrade from 11.9 to 12.5. our dba is left and i need to do this. i very novice in dba skill. can someone give me exact stepps how to do this? i read other post but dont under stand where to start. also what is meaning of inplace upgrade?thanks SybaseDeveloper wrote... > we are on solaris 8 and would like to upgrade from 11.9 to 12.5. > our dba is left and i need to do this. i very novice in dba skill. > can someone give me exact stepps how to do this? i read other post but dont > under stand where to start. also what is meaning of i...

Migrate ASE 11.5 to ASE 12.5 causes pc-client problem!!
Hi all, I migrated ASE 11.5/P/Sun_svr4/OS 5.5.1 to ASE 12.5/SWR 9609 GA/P/Sun_svr4/OS 5.8 on Sun box. I face problem on win 98 client application, written by VB 4, when it use recordset (DAO 3.0) to update table in ASE 12.5. The problem occure when use ODBC sybase system 10. Error in application is [INTERSOLV][ODBC SQL Server driver][SQL Server]Variable is not allowed in trigger. If I use passthru mode to run the same SQL on ASE 12.5, it is not such an error. Then I try to install 12.5 pc client on that machine but I can not do that because when during the installation proc...

ASE Migration From ASE 11.5.1 (NT) to ASE 12.9 on Win2003.
Need help to find Sybase's upgrade and migration docs on above subject? Thank you. ASE 12.9? Currently, no released versions of ASE are certified on Win 2003. ASE 12.5.1 will be certified when it is released later this year. Mark Kusma <Lily Maria> wrote in message news:3f497cad.367e.846930886@sybase.com... > Need help to find Sybase's upgrade and migration docs on > above subject? > Thank you. Thanks for the info. I would like to know if there's any online documentation on migration and upgrade plan of the ASE 11.5.1 to ASE 12.5.1? Do applica...

ASE 12.5.2 to ASE 12.5.0.3
Hello, I have to return to ASE 12.5.0.3 from ASE 12.5.2. I created a new server and did a dump/load of a user database and that seems to be fine. Is this a safe way to downgrade ? Is it necessary to create a new server (master database) or should it also be possible to shutdown the 12.5.2 server and start it again with the 12.5.0.3 binary ? Thanks, Luc. ...

Migration from ASE 11.5 NCR to ASE 11.5 SUN
Hi everybody. I have a question about the migration from ASE 11.5 on NCR to ASE 11.5 on SUN Solaris 2.6. My question is, how can I do the data migration without the use of bcps and DBArtisan? Exists another tool that leave me migrate the data more easy? Thanks, mpacheco@banrural.com.gt wrote... > Hi everybody. > > I have a question about the migration from ASE 11.5 on NCR to ASE 11.5 on > SUN Solaris 2.6. > > My question is, how can I do the data migration without the use of bcps and > DBArtisan? Exists another tool that leave me migrate the data ...

Upgrade ASE 12.0/64 bit on AIX 4.3.3 to ASE 12.5.x/64 bit on AIX 5.2
Trying to find what is the supported upgrade path for the above. Going from 12.0/64bit on AIX 4.3.3 to 12.5 (or 12.5.x) 64bit on AIX 5.2. If I put AIX 5.2 , the dataserver binary of 12.0 will not work which is used during the upgrade. If I put 12.5.x on 4.3.3, the dataserver binary will not work beacuse it is new binary for 5.2. Other than backup the databases and load them to the new server, is there a supported how to upgrade? Thanks! ...

Upgrading from ASE 12.0 to ASE 12.5.2
Hi everyone, I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2. How would the migration process be. Is it straight dump and load or otherwise ?? regards Paresh. Paresh wrote: > Hi everyone, > > I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2. > > How would the migration process be. Is it straight dump and load or > otherwise ?? > > regards > > Paresh. > > see the upgrade/installation guide joop -- Senior Consultant Sybase Professional Services New address per 21 November 2005: Zo...

Web resources about - Performance issues after upgrate ASE 11.5 to ASE 12.5 #2 - sybase.ase.upgrades+migration

Performance - Wikipedia, the free encyclopedia
A performance , in performing arts , generally comprises an event in which a performer or group of performers behave in a particular way for ...

Electric vehicle puts in solid performance in the world’s toughest rally
... but remote and arduous terrain. And this year an electric vehicle called the Acciona 100% EcoPowered put in an extremely credible performance. ...

BMW i8: Jaw-dropping style and green performance, but why?
... drives the BMW i8 for a week and starts to wonder why the Germans built this EV. Continue reading BMW i8: Jaw-dropping style and green performance, ...

"I agree that Sylvester Stallone gave a hearty, worldly-wise performance as the aged Rocky Balboa..." ...
"... and thought that he’d be one of the few intersections between my own year-end picks and the nominations. But the Academy’s choice of no ...

WaPo: Trump/Cruz Commanding Performances in Debate Make It a Two-Horse Race
WaPo: Trump/Cruz Commanding Performances in Debate Make It a Two-Horse Race

Here's the story behind the incredible performance by three young children at a Donald Trump rally
USA Freedom Kids opened for Donald Trump at his Florida rally on January 13, 2016. The children performed an original song by director and Trump ...

Performance of David Bowie musical becomes a memorial
Tuesday night's performance was the first time since Bowie's death on Monday that the show went on

Alan Rickman: Best Movie Performances - Collider
We run down our list of Alan Rickman's best performances, which includes his phenomenal work in the Harry Potter series and more.

Second- and third-tier notebook ODMs to see weak shipment performance in 2016
Taiwan- and China-based second and third-tier notebook ODMs including Shuttle, Clevo, Elitegroup Computer Systems (ECS), Uniwill, Malata and ...

Unilever Q4 Earnings Preview: Repeat of Q3's Blockbuster Performance Unlikely
The company is unlikely to have repeated the blockbuster performance of the third quarter, when one-off factors boosted results. However, adverse ...

Resources last updated: 1/20/2016 4:43:38 AM