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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190603 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
