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.
Subject: Need recommendation on Hardware/RAID
Date: Mon, 23 Feb 1998 12:17:43 -0500
Content-Type: text/plain; charset="iso-8859-1"
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Xref: forums-1-dub sybase.public.sqlserver.nt:5155
Article PK: 1081235
X-Newsreader: AspNNTP (Advent 2000, Inc.)
Subject: Re: Need recommendation on Hardware/RAID
Content-Type: text/plain; charset="us-ascii"
Date: Wed, 25 Feb 1998 10:49:53 -0500
Xref: forums-1-dub sybase.public.sqlserver.nt:5144
Article PK: 1081221
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,
Sybase Professional Services