Matt, There is a current thread running over at SSWUG titled "Raid 10 VS Raid 5 and ISCII". Login there or create a free account and search on the subject line:
http://www.sswug.org/ Dan On Fri, 14 Jan 2005 15:55:34 -0400, Matt Wisdom <[EMAIL PROTECTED]> wrote: > I realize that the reader doesn't have all of the info for my situation, and > that there are ways to verify true bottlenecks in a databaes system with Perf > Mon and other tools that I will address when I can. That said, I'm hoping > that others can share their experiences if they've been down this path. Here > is my situation: > > I have one DB server that will host my main site DB and the CFSessions DB > that is created by the CF Servers to use database-based client variables. I > would like to maximize performance of the database but I am unsure as to the > best starting point for allocating hard drives to raid volumes. Client > variables get moderate usage, although the data contained within is not > mission critical. The MainDB gets relatively heavy usage, mostly reads. The > system looks like this: > > SQL Server 2000 > 10 drive raid > system memory maxed out > Fast CPUs > > The database files look like this: > > Main DB > Main DB Translog > CF Sessions DB > CF Sessions DB Tlog > > What RAID config would you use for the databases? > > Main DB = 4+1 parity RAID 5 > Main DB tlog = 1+1 mirrored RAID 1 > CF Sessions DB = 1 > CF Sessions DB tlog = 1 > Hot spare = 1 > > or splitting the drives based on sequential vs non-sequential reads: > > Main DB and CFSessions DB = 6+1 parity RAID 5 > Main DB tlog CF Sessions DB tlog = 1+1 mirrored RAID 1 > Hot spare = 1 > > or something else?? > > How important is (battery backed) write cache for the raid? The main database > doesn't write very much, but the CFSessions DB should be writing every > pageload. Would you use this? > > Thanks very much in advance, > Matt > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190713 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
