Auto Update Statistics

SQL 2000 has option on database "Auto Update Statistics".
How often does SQL server auto perform this update
action? Can this action impact server performance?
Thanks.
-Jim FullerINF: How SQL Server 7.0 and SQL Server 2000 Autostats Work
http://support.microsoft.com/default.aspx?scid=kb;en-us;195565&Product=sql
This may be helpful...
And yes, in some cases updating of stats during a peak processing window can
slow performance. However, in general it's best to leave it on unless you
know for sure it's causing a problem and you schedule stats to be updated in
a non peak period...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Jim Fuller" <anonymous@.discussions.microsoft.com> wrote in message
news:d37801c3bab3$2e807a30$a601280a@.phx.gbl...
> SQL 2000 has option on database "Auto Update Statistics".
> How often does SQL server auto perform this update
> action? Can this action impact server performance?
> Thanks.
> -Jim Fuller
>|||Brian, Thank you very much.
-Jim
>--Original Message--
>INF: How SQL Server 7.0 and SQL Server 2000 Autostats
Work
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;195565&Product=sql
>This may be helpful...
>And yes, in some cases updating of stats during a peak
processing window can
>slow performance. However, in general it's best to leave
it on unless you
>know for sure it's causing a problem and you schedule
stats to be updated in
>a non peak period...
>
>--
>Brian Moran
>Principal Mentor
>Solid Quality Learning
>SQL Server MVP
>http://www.solidqualitylearning.com
>
>"Jim Fuller" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d37801c3bab3$2e807a30$a601280a@.phx.gbl...
>> SQL 2000 has option on database "Auto Update
Statistics".
>> How often does SQL server auto perform this update
>> action? Can this action impact server performance?
>> Thanks.
>> -Jim Fuller
>
>.
>