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 Greg D. Moore \(Strider\) on 08/09/06 02:18

"Bjψrn Augestad" <bjorn.augestad@gmail.com> wrote in message
news:eba4n9$fba$1@bat-news01.banetele.basefarm.net...
> 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 ;-)

I can definitely understand curiousity. :-)


My point is simply that any performance gains here are probably miniscule
compared to what you can make elsewhere.


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

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