Hi,
I've always gone with option 1.. listed below..
> Main DB = 4+1 parity RAID 5
> Main DB tlog = 1+1 mirrored RAID 1
however I never store client variables in DB as it's a very high
overhead (atleast for me). but incase I had to.. I went with MySQL on
diffrent box.
--
Regards
Matt Wisdom 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
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190607
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
