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!
------------------------------------------------------------
