Posted by Bj�rn Augestad on 08/08/06 13:48

Greg D. Moore (Strider) wrote:
> "boa" <boasema@gmail.com> wrote in message
> news:mq-dnQaIHbQLBUrZ4p2dnA@telenor.com...
>
>>While we're at it, any thoughts on the registry setting
>>NTFSDisableLastAccessUpdate?
>>
>
>
> None other than you're probably over thinking the problem.
>
> Seriously, any performance gains, etc. you're almost certainly better off
> looknig elsewhere.
>

Sorry if I've given you the impression that we're not looking elsewhere.
Right now we are 5 guys rewriting queries and client applications, as
well as adding memory, servers, more spindles and everything else that
may improve performance, and the profiler and dta runs 24/7(Almost...).

Maybe it's just me, but I enjoy knowing these things, and if MSFT added
NTFSDisableLastAccessUpdate(aka unix noatime) I presume they did it for
a reason. It would be nice to know that reason ;-)

Bjørn



>
>
>>Bjørn
>>
>>[snip]
>
>
>

• Next in forum: Re: How to get last date only once all have been filled in
• Prev in forum: Re: SQL Server 2005 and file systems, any recommendations
• Thread view: Re: SQL Server 2005 and file systems, any recommendations

[Reply to this message]