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.

Performance on NT vs UNIX

3 posts in Windows NT Last posting was on 2000-10-31 12:28:05.0Z
allen208 Posted on 2000-10-30 16:04:05.0Z
From: allen208@hotmail.com
Date: Mon, 30 Oct 2000 11:04:05 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Performance on NT vs UNIX
Message-ID: <A1DB9FC2D4DF8B810058440785256988.0058441685256988@webforums>
Lines: 31
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.sqlserver.nt:1541
Article PK: 1089021

For various reasons, my company's DEC Alpha Sybase servers (on UNIX) are
going to be shut down.

As background information, we run 14 Sybase servers. The average server
holds about 30 GB of data, has 4 processors, and lists about 120 logins at
any given time. The client applications mostly use Visual Basic components
over ODBC. These servers are "mission critical" and run 24x7.

We have some options:

A) Migrate the database and applications to SQL 2000 on COMPAQ servers.
B) Migrate Sybase to NT 4.0 on COMPAQ servers.
C) Migrate Sybase to Win 2000 on COMPAQ servers.

Can anybody point me to benchmark information comparing Sybase performance
on Windows NT vs DEC Unix?

Does anyone have an opinion about running Sybase on Win 2K?

Finally, are there any gotchas to be expected when Sybase is ported from
UNIX to NT?

Anyone's advice, opinions are appreciated.

Thanks in advance,
Jacob Allen


George Saylor Posted on 2000-10-31 12:28:05.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <A1DB9FC2D4DF8B810058440785256988.0058441685256988@webforums>
Subject: Re: Performance on NT vs UNIX
Date: Tue, 31 Oct 2000 07:28:05 -0500
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <MV9EffzQAHA.162@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 1Cust17.tnt2.baltimore.md.da.uu.net 63.24.127.17
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1536
Article PK: 1089011

big gotcha is that you cannot restore from dump to your new database, You
will end up using bcp to move the data. DBArtisan has a migrate feature as
well as some other tools. 30 GB will take a while to do

for benchmarks check out tpc.org

<allen208@hotmail.com> wrote in message
news:A1DB9FC2D4DF8B810058440785256988.0058441685256988@webforums...
> For various reasons, my company's DEC Alpha Sybase servers (on UNIX) are
> going to be shut down.
>
> As background information, we run 14 Sybase servers. The average server
> holds about 30 GB of data, has 4 processors, and lists about 120 logins at
> any given time. The client applications mostly use Visual Basic
components
> over ODBC. These servers are "mission critical" and run 24x7.
>
> We have some options:
>
> A) Migrate the database and applications to SQL 2000 on COMPAQ servers.
> B) Migrate Sybase to NT 4.0 on COMPAQ servers.
> C) Migrate Sybase to Win 2000 on COMPAQ servers.
>
> Can anybody point me to benchmark information comparing Sybase performance
> on Windows NT vs DEC Unix?
>
> Does anyone have an opinion about running Sybase on Win 2K?
>
> Finally, are there any gotchas to be expected when Sybase is ported from
> UNIX to NT?
>
> Anyone's advice, opinions are appreciated.
>
> Thanks in advance,
> Jacob Allen
>
>
>
>
>


fs Posted on 2000-10-30 16:07:31.0Z
From: fs@sybase.com
Date: Mon, 30 Oct 2000 11:07:31 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: Performance on NT vs UNIX
Message-ID: <9C0A79573A654C560058941A85256988.0058442385256988@webforums>
References: <A1DB9FC2D4DF8B810058440785256988.0058441685256988@webforums>
Lines: 3
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.sqlserver.nt:1540
Article PK: 1089018

Migrate to SQLServer 2000 on Windows 2000.

It is a superior product to anything Sybase has on Windows.