On Wed, Mar 11, 2009 at 3:01 AM, Rick Root wrote: > The server has 4x146gb scsi drives set up in 2 RAID-1 mirrored sets. > > We ended up with a 20 gig C drive and a 120gb D: drive on one mirrored > set, and 70 gig E: and F: drives on the other mirrored set. Currently > we've got our SQL Server data files on the D: drive, the transaction > logs on the E: drive, and the backups on the F: drive. > > The database is relatively small (7gb) but used pretty heavily..
Used how? Updates, inserts and deletes or just selects? How many of each per second? And which software exactly do you mean by SQL Server? > I have the ability to add four more drives to the machine... Why would you? What is the current bottleneck and how would adding drives help? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4