|
|
Posted by Hugo Kornelis on 09/26/06 19:52
On 26 Sep 2006 05:14:45 -0700, tlyczko wrote:
>
>Hugo Kornelis wrote:
>> I'd like to know where you've read this nonsense. For starters, views
>> and constraints are only stored as metadata. And even for tables, this
>> is an incorrect general rule.
>
>Thanks a lot for responding. :)
>
>I'll try to find the reference, it was in a book about SS2005. The DB
>isn't going to be large enough for a long long time to merit separate
>locations for the data and log files, though.
>
>Thank you, Tom
Hi Tom,
Seperate locations for data and log files are always good.
The data file requires lots of random access, i.e. lots of head
movement. Luckily, SQL Server buffers data read from the data file, so
recently used data doesn't have to be read from disk again. Writes are
buffered as well.
The log file is mainly written to. These writes have to be completed
before SQL Server will signal the client that an operation is finished.
So write performance on your log file is critical to performance. Since
all log writes are sequential, you can gain a lot of performance if you
have the log file on a dedicated disk - the heads hardly have to move
and you write performance is it the highest possible rate - increasing
the time to completion for yur transactions.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|