You are here: Re: SQL Server 2005 and file systems, any recommendations « MsSQL Server « IT news, forums, messages
Re: SQL Server 2005 and file systems, any recommendations

Posted by boa on 08/07/06 19:46

* David Portas wrote, On 07.08.2006 20:33:
> Bjørn Augestad wrote:
>>
>> I'm no NTFS expert either, so I read the tech spec for NTFS at
>> http://technet2.microsoft.com/WindowsServer/en/library/59a9462a-cbdd-45e7-828b-12c6cd9ae4781033.mspx?mfr=true
>>
>> Here's a quote:
>> NTFS Change Journal
>>
>> As files, folders, and other NTFS objects are added, deleted, and
>> modified, NTFS enters change journal records in streams, one for each
>> volume on the computer.
>>
>> My interpretation, hopefully wrong, is that NTFS journal entries will be
>> written to disk whenever a file is modified. This will lead to disk head
>> movement and decreased performance on a busy disk, won't it?
>>
>
[snip]

>
> "NTFS does not do data journaling"
> www.cs.wisc.edu/adsl/Publications/sba-usenix05.pdf
>

Excellent, that's exactly what I needed to know. Thanks. So standard
NTFS is what I'll use.

While we're at it, any thoughts on the registry setting
NTFSDisableLastAccessUpdate?


Bjørn

[snip]

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация