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

 

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

Π‘Π°ΠΉΡ‚ ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ Π² Π‘Ρ‚ΡƒΠ΄ΠΈΠΈ Π’Π°Π»Π΅Π½Ρ‚ΠΈΠ½Π° ΠŸΠ΅Ρ‚Ρ€ΡƒΡ‡Π΅ΠΊΠ°
ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ΠΈΠ΅ ΠΈ ΠΏΠΎΠ΄Π΄Π΅Ρ€ΠΆΠΊΠ° Π²Π΅Π±-сайтов, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚ΠΊΠ° ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎΠ³ΠΎ обСспСчСния, поисковая оптимизация