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.

Need recommendation on Hardware/RAID

2 posts in Windows NT Last posting was on 1998-02-25 15:49:53.0Z
Dennis Rosen Posted on 1998-02-23 17:17:43.0Z
From: "Dennis Rosen" <drosen@brandonassociates.com>
Subject: Need recommendation on Hardware/RAID
Date: Mon, 23 Feb 1998 12:17:43 -0500
Lines: 14
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <wVZUvVHQ9GA.205@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5155
Article PK: 1081235

Hello,

Can anyone recommend (or pont me to the proper documents regarding)
hardware requirements for SQL Server 11.0 on NT 4 (I'll be migrating a
Netware w/System 10) The new server will be a Compaq 4500. I'll
need about 36GB of hard drive storage. What are the memory
requirments? Should I use hardware RAID or disk mirroring? (Is it OK
performance-wise to use RAID 5?) Should I use a separate
controller/drive for the transaction log device? etc. etc.

TIA, Dennis


John McVicker Posted on 1998-02-25 15:49:53.0Z
From: "John McVicker" <mcvicker@sybase.com>
Organization: 192.175.209.26
References: <wVZUvVHQ9GA.205@forums.powersoft.com>
X-Newsreader: AspNNTP (Advent 2000, Inc.)
Subject: Re: Need recommendation on Hardware/RAID
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <8pIPDUgQ9GA.205@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Wed, 25 Feb 1998 10:49:53 -0500
Lines: 79
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5144
Article PK: 1081221

Dennis,
You'll probably hear this from others too, but here goes.
You have far too many questions regarding a critical system to
rely on newsgroup postings. You are pretty much asking a larger
question - that is, "How can I set up an RDBMS properly to run
my applications on". The only real information we have here
is a Compaq 4500 and NT, with SQL Server 11. We will need to
know lots more information - and this newsgroup probably
is not the right forum for this type of project planning on
your part. And, you said "etc. etc." - that means you probably
have even more questions than those you gave here.

To properly set things up "well" - not just ok, with future
changes expected - you would want to look at the transaction profile
of the system, document very well the transaction profile of the
existing system, determine the table sizes for the application, index
configurations, and so on. This is a multi-week project that
is better suited to an on-site engagement by a Sybase-heavy
consultant. You're pretty much describing what many consulting
firms do - including Sybase - under what may be called a
Technical Options Study. This would take your business requirements
and turn them into multi-level technical solutions. Those would
include how the SQL Server is configured (memory, disks, etc)
and how the network is configured - as well as even touching on how
you should do transactions within your application.

The reason to do a business-specific study is this:
- The answer to all your questions is "It Depends". It truly
depends on how you intend to use the system, and as such,
answers given to these questions on this forum are only "best guesses"
or specific to the general question, not the best possible
solution for your business. If you want to do it right, you'll
have to sit down with Sybase or a Sybase-heavy consultant who
has done systems like yours before and layout the best possible
technical solution to your business problem. That's the only
way to really make you successful. Otherwise, the answers given
may only make you "slightly" successful and once your system is
in production - you know how hard it will be to make a change to
make it better. Don't take the easy way out since that is
detrimental to you and your company. Re-designing a server after
the fact is far more painful than sitting down and thinking about
it for a few days and weeks before implement.

On Mon, 23 Feb 1998 12:17:43 -0500,
in sybase.public.sqlserver.nt

Dennis Rosen <drosen@brandonassociates.com> wrote:
>Hello,
>
>Can anyone recommend (or pont me to the proper documents regarding)
>hardware requirements for SQL Server 11.0 on NT 4 (I'll be migrating a
>Netware w/System 10) The new server will be a Compaq 4500. I'll
>need about 36GB of hard drive storage. What are the memory
>requirments? Should I use hardware RAID or disk mirroring? (Is it OK
>performance-wise to use RAID 5?) Should I use a separate
>controller/drive for the transaction log device? etc. etc.
>
>TIA, Dennis

John McVicker
Sybase Professional Services
Philadelphia, PA