TIP: Click on subject to list as thread! ANSI
echo: nthelp
to: All
from: Ellen K
date: 2004-06-23 16:12:14
subject: Replace 1 pair of mirrored drives without trashing rest of box?

I am allowed 6 drives for my SQL Server boxes and usually configure them as follows:
2 drives as a mirrored pair - boot partition goes here and another drive
letter for the transaction log
3 drives in a RAID5 array - data goes here 1 singleton drive - nonclustered
indexes go here (and I create a script for use in case this one fails that
drops all the nonclustered indexes and re-creates them on another drive, so
the database can stay up until the bad solo drive can be replaced)

So, the first one I did like this, the singleton and mirrored drives are
only 18 GB each.   (The three RAID5 ones are 72, which is fine.)  This is
plenty for
the singleton for that database, but is really too small for the mirrored pair
-- currently the boot partition is only 4 GB and the NT admin says it HAS to
have a swap file of at least 1.2 GB (I wanted to move the swap file to the
singleton drive) and my transaction log is about 11 GB by the end of the
day.  I would like more headroom for the transaction log because I'm
getting at least 100 net new users by the end of the year so there will be
considerably more activity, and he says we should have 8 GB for the boot
partition because there isn't enough room for applying patches.  Also the
box is constantly showing memory usage at 85% or more -- we are going to
add RAM (somehow it only got 1 GB) but squishing the swap file isn't
helping. 

I asked whether we could replace the two 18's in the mirrored pair with
36's and he freaked.  Finally after thinking about it he said he wants to
know whether if we do this we will screw up anything with the other 4
disks.

And I want to know what else we should be worrying about.

TIA   :)

--- BBBS/NT v4.01 Flag-5
* Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)
SEEN-BY: 633/267 270
@PATH: 379/45 1 633/267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.