Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Advantages of 64 bit

4 posts in Product Futures Discussion Last posting was on 2002-03-29 19:14:31.0Z
Murali Posted on 2002-03-28 18:01:36.0Z
From: Murali
Date: Thu, 28 Mar 2002 13:01:36 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Advantages of 64 bit
Message-ID: <9818A490AA2882F00063062D85256B8A.0063064485256B8A@webforums>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:591
Article PK: 94122

Hi All,
Can you Pl. explain me the advantages of 64-bit ASE 12.5 over 32-bit.

Thanks,
Murali


Bret Halford Posted on 2002-03-28 18:02:55.0Z
Message-ID: <3CA35ACF.8C7EE2D9@sybase.com>
Date: Thu, 28 Mar 2002 11:02:55 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Advantages of 64 bit
References: <9818A490AA2882F00063062D85256B8A.0063064485256B8A@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 14
NNTP-Posting-Host: 157.133.80.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:590
Article PK: 94118

It allows you to access much more memory. 32 bit ASE's can generally
only access 2-4gb of
memory at most (exact limit depends on the OS). 64 bit ASE's can, in
theory, access a couple
of terabytes of memory, allowing much larger data and procedure caches.
The only reason to
use 64-bit ASE is if you are hiting the 32-bit limits on memory and your
"cache hit" percentage
is not looking good.

Murali wrote:

> Hi All,
> Can you Pl. explain me the advantages of 64-bit ASE 12.5 over 32-bit.
>
> Thanks,
> Murali


Pablo Sanchez Posted on 2002-03-28 18:09:25.0Z
From: "Pablo Sanchez" <pablo@dev.null>
References: <9818A490AA2882F00063062D85256B8A.0063064485256B8A@webforums> <3CA35ACF.8C7EE2D9@sybase.com>
Subject: Re: Advantages of 64 bit
Date: Thu, 28 Mar 2002 11:09:25 -0700
Lines: 19
Organization: High-Performance Database Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <s0q5FTo1BHA.325@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 207.225.105.222
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:589
Article PK: 94115


"Bret Halford" <bret@sybase.com> wrote in message
news:3CA35ACF.8C7EE2D9@sybase.com...
>
> The only reason to
> use 64-bit ASE is if you are hiting the 32-bit limits on memory and
your
> "cache hit" percentage
> is not looking good.

Succinctly said! I'd add just a wee bit that going to 64 bit if the
above isn't true is a performance hit. Not just Sybase but with
Oracle and all other DBMS's.
--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Available for short-term and long-term contracts


Jeff Tallman Posted on 2002-03-29 19:14:31.0Z
From: "Jeff Tallman" <tallman@sybase.com>
References: <9818A490AA2882F00063062D85256B8A.0063064485256B8A@webforums> <3CA35ACF.8C7EE2D9@sybase.com> <s0q5FTo1BHA.325@forums.sybase.com>
Subject: Re: Advantages of 64 bit
Date: Fri, 29 Mar 2002 14:14:31 -0500
Lines: 40
Organization: Sybase, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <zEHEKc11BHA.216@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: slip-32-102-153-183.pa.us.prserv.net 32.102.153.183
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:583
Article PK: 94113

Unfortunately, comments such as this can be misconstrued. Even though cache
hit percentage is "fairly good", adding the extra memory can provide
additional memory for sort buffers and other structures that will improve
the overall performance of the the system. While a 64-bit addressing scheme
does indeed take longer and may affect a single operation, generally
speaking it does not directly correlate to a "slower" system overall. The
impact on that one nasty query may be enough to reduce contention (i.e.
shared locks removed faster under isolation level 3) and improve performance
quite dramatically. My experience with some of my customers who have moved
to 64-bit is that overall throughput did increase - sometimes in the 20-30%
range. Hence, my answer:

If you think the additional memory will help, then test it! If it works,
great! If not, then no need to migrate to 64-bit.

"Pablo Sanchez" <pablo@dev.null> wrote in message
news:s0q5FTo1BHA.325@forums.sybase.com...
>
> "Bret Halford" <bret@sybase.com> wrote in message
> news:3CA35ACF.8C7EE2D9@sybase.com...
> >
> > The only reason to
> > use 64-bit ASE is if you are hiting the 32-bit limits on memory and
> your
> > "cache hit" percentage
> > is not looking good.
>
> Succinctly said! I'd add just a wee bit that going to 64 bit if the
> above isn't true is a performance hit. Not just Sybase but with
> Oracle and all other DBMS's.
> --
> Pablo Sanchez, High-Performance Database Engineering
> www.hpdbe.com
> Available for short-term and long-term contracts
>
>