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 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
using for tests, and separate data and indexes on different devices.
-Create a set of 16K pools for various named caches.
-Create again index, stored procedure, triggers and tables.
-We install the patches that are available in Sybase.com for the version
12.5 to 32 bit

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

Now we have the same problem!.

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

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

Thanks


0
Fabricio
6/11/2002 2:16:00 PM
sybase.ase.upgrades+migration 687 articles. 0 followers. Follow

2 Replies
1075 Views

Similar Articles

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

What was the new hardware that you moved to?  Is it by chance a NUMA system?


-Carl

On Tue, 11 Jun 2002 11:16:00 -0300,
 in sybase.public.ase.upgrades+migration
Fabricio Streppel <fabricio@develop.com.br> wrote: 
>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 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
>using for tests, and separate data and indexes on different devices.
>-Create a set of 16K pools for various named caches.
>-Create again index, stored procedure, triggers and tables.
>-We install the patches that are available in Sybase.com for the version
>12.5 to 32 bit
>
>There is no contention because we're in tests and this query is the only
>process running on the machine.
>
>Now we have the same problem!.
>
>->Is there any problems with this combination of versions (maybe we're
>lacking additional software) of Adaptive Server and Solaris?
>
>->Is there any combination of performance changes that works best?
>
>Thanks
>
>

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Carl
6/11/2002 7:25:01 PM
This is a multi-part message in MIME format.
--------------0F5CC6D2EADAC80A4BA605BE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Again, this appears to be a duplicate posting.  Look at this thread in
performance+tuning newsgroup at:

news://forums.sybase.com/B9C11262017322440052CFE985256B99.0052D01585256B99%40webforums

Are you and Richard_M the same person?  Both of your posts look
incredibly alike.

A fair amount of advice and observations were given in the thread above.
 Please refer to those and let us all hear back on how you are progressing.
--------------0F5CC6D2EADAC80A4BA605BE
Content-Type: text/x-vcard; charset=us-ascii;
 name="ksherlo.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Sherlock, Kevin
Content-Disposition: attachment;
 filename="ksherlo.vcf"

begin:vcard 
n:Sherlock;Kevin
x-mozilla-html:FALSE
url:http://qwestdex.com
org:Qwest DEX;Information Managment
adr:;;;Omaha;NE;68114;USA
version:2.1
email;internet:ksherlo_AT_qwest.com
title:Staff Information Systems Engineer
x-mozilla-cpt:;3
fn:Kevin Sherlock
end:vcard

--------------0F5CC6D2EADAC80A4BA605BE--

0
Sherlock
6/12/2002 3:39:33 PM
Reply:

Similar Artilces:

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 ...

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...

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...

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 ...

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...

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 ...

ASE 11.5 on same server as ASE 12.5?
Anyone have 11.5 running on same server as 12.5 on NT? Would not be concerned to do this in Solaris as I am on an NT 4.0 Box sp6. Any known gotchas or issues? Going to take toni's advise in earlier posting on doing the 11.5 install as a seperate user on the server already running 12.5 just fine. Hope this wilkl take care of env vars??? We have one app that the company who developed it will no longer support us on newer versions of Sybase as a result this one crucial app must stay up and running on 11.5 while we allow the rest of our company to progress forward to 12.5 an...

Upgrade from ASE 12.5.0.3 to ASE 12.5.1
This is a multi-part message in MIME format. ---=_forums-2-dub3ff97039 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I've just upgraded from ASE 12.5.0.3 to ASE 12.5.1. I tried to start the server, but it won't startup. Here is the message: sybase(ASE1250)328 /app/sybase/ASE-12_5/install --> startserver -f RUN_AMXDB sybase(ASE1250)329 /app/sybase/ASE-12_5/install --> 00:00000:00000:2004/01/05 21:37:44.10 kernel Use license file /app/sybase/SYSAM-1_0/licenses/license.dat. 00:00000:00000:2004/01/05 21:37:44.10 ker...

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 ...

Migration to ASE 12 from ASE 11.5
Hi all, Has anyone out there perormed a migration from ASE 11.5.1.1 to ASE 12 on NT. If so I would be greatful if you could provide information on the following 1. Ease of migration and any issues encountered. 2. Sizes of databases migrated 3. Adopted migration plans - I could not find anything on the Sybase web site. 4. Experiences on ASE 12. Thanking you in advance Puvendran Hi, Yes, I have performed a migration from both v11.5.1 to v12 and from v11.9.2.1 to 12. I have put my responses below each of your questions. -- Andy Price, Sybase Certified Adapt...

Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...

Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)
Hi, I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 (IBM AIX 5.3) here are the characteristics: HP UX ------ The default Unix charset on the platform is Roman8. The ASE/db Charset is UTF8 AIX (5.3) --- The default Unix charset on the platform is Iso The ASE/db Charset will be UTF8 Someone told me Cross-platform DUMP/RELOAD is not possible. note that I didn't try it yet, but i will. Does anyone know about that ? If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i dont know exactly what syntax i should use w...

Web resources about - Performance issues after upgrate ASE 11.5 to ASE 12.5 - 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 ...

Apple updates Logic Pro X & MainStage 3 Mac apps with performance improvements, new features
... is now at version 3.2.3 thanks to its most recent update. Both apps have received a handful of new features, under-the-hood changes, and performance ...

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. ...

Even the 'Suicide Squad' director was 'freaked out' by Jared Leto's twisted Joker performance on set
... gifts to cast members — including a dead rat to Margot Robbie (Harley Quinn) and bullets to Will Smith (Deadshot). His transformative performance ...

Suicide Squad: Jared Leto's Ambitious Joker Performance Teased - Collider
Directors David Ayer and Zack Snyder tease the dramatic lengths Jared Leto took for his ambitious performance as The Joker in DC's Suicide Squad. ...

Google to boost compression performance in Chrome 49
Google yesterday announced that a new in-house compression algorithm, dubbed "Brotli," will soon be added to Chrome to speed up page loading ...

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 ...

Zac Efron Goes Beet Red Reliving His Performance as Snoopy in a 'Charlie Brown' School Musical
The 'Dirty Grandpa' star sat down with Jimmy Kimmel Thursday, where he moonwalked around stage and took a trip down memory lane.

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 ...

Super Bowl 50 venue ranks No. 1 in latest NFL stadium mobile performance study
... problem sharing selfies and posting video from their smartphones. RootMetrics, a Seattle-area company that provides information about the performance ...

Resources last updated: 1/23/2016 12:44:23 PM