RE: Server Configuration
- From: danabras@xxxxxxxxxxxxxxxxxxxx ("Dana Brash")
- Date: Mon, 25 Apr 2005 07:29:37 GMT
Hi John,
Determining the best configuration for your SQL Server has a few ground
rules, but also depends on how the data will be accessed. Assuming it will
be an OLTP system, some general rules of thumb are to separate out data
from logs and to put the OS on a different volume as well (3 volumes).
Ideally, you'd put the logs on a RAID1 (or RAID10) volume by themselves by
adding a third volume, reducing the seek and latency to update the
transaction logs. Because different areas of the data, presumably, will be
accessed during normal usage, it is not so relevant to be concerned about
maintaining linear write operations. Note that with RAID5 you are
incurring some I/O performance penalties as RAID5 needs two reads and two
writes to the volume, but you get redundancy and scalability with the
minimum 'lost' space penalty.
If I were to configure your system, I'd most likely put the logs and the OS
on the RAID1 backplane as the OS will receive little other direct use.
Also, as the backplane is configured as RAID1 you'll have great redundancy
and performance.
That said, to really tune your system will involve both good planning and
monitoring typical usage patterns. If possible, you should monitor your
system under load in a dev/test environment prior to final rollout. You
can use both SQL Profiler and the SQL Server counters for System Monitor to
analyze the performance of your system. Check processor, disk and memory
activity and load.
There are some good articles in Books Online that point to the right areas
to monitor. Please see the articles titled:
Identifying Bottlenecks
Monitoring CPU Usage
Monitoring Disk Activity
Monitoring Memory Usage
For more information about performance tuning and configuration, the book
"SQL Server 2000 Performance Tuning" from MS Press (ISBN 0-7356-1270-6) is
a great resource and is readily available from most popular book resellers.
HTH!
Sincerely,
Dana Brash
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>Thread-Topic: Server Configuration
>thread-index: AcVJTKkwvUmZrFDpRqi0sic8f+ehYg==
>X-WBNR-Posting-Host: 24.218.199.128
>From: "=?Utf-8?B?SlQ=?=" <Jthayer@xxxxxxxxxxxxx>
>Subject: Server Configuration
>Date: Sun, 24 Apr 2005 21:10:05 -0700
>Lines: 9
>Message-ID: <7882615F-4F7B-4AA2-B4FA-A803AF2E0DBF@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.setup
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.setup:6729
>X-Tomcat-NG: microsoft.public.sqlserver.setup
>
>I am soon to setup a new server that has RAID 5 (3 discs 146GB/10K) up
front,
>and RAID 1 (2 discs 146GB/10K) on the backplane. The OS will be Win 2003
>ENT. This will be a dedicated SQL Server that will eventually be
clustered -
>using SQL 2000 ENT. Any suggestions on how to configure? For example,
>install OS on backplane? Install MDF's up front and LOG's on backplane?
Any
>wisdom would be greatly appreciated.
>
>--
>John
>
.
- Follow-Ups:
- RE: Server Configuration
- From: Mike Epprecht (SQL MVP)
- RE: Server Configuration
- References:
- Server Configuration
- From: JT
- Server Configuration
- Prev by Date: RE: SQL Server Service Account
- Next by Date: Re: Database Backup
- Previous by thread: Server Configuration
- Next by thread: RE: Server Configuration
- Index(es):
Relevant Pages
|
