On 06/01/2005-07:19PM, Mark Stosberg wrote: > > - I saw the hardware tip to "Separate the Transaction Log from the > Database". We have about 60% SELECT statements and 14% UPDATE > statements. Focusing more on SELECT performance seems more important > for us. >
I would think that would help SELECT If the spindle isn't busy writing Transaction log it can be reading for your SELECTs. You did say you were CPU bound though. -- ------------------------------------------------------------ Christopher Weimann http://www.k12usa.com K12USA.com Cool Tools for Schools! ------------------------------------------------------------ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])