Auto Update Stats

I have the above set on all my databases on one of our
2000 production servers. However, this server has a lot
of databases (about 150) and about 300+ Gig on it. I
remember reading an article posted here about an issue
where if a server has a lot of databases, it may need
manual runs of stats.
Can someone repoint me to that article? It actually
outlined the algorithm that Sql Server used, etc.
I couldn't find it in the kb or bol.Is this the one you are referring to?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q195565
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"GoBoy" <anonymous@.discussions.microsoft.com> wrote in message
news:178a01c4c1c5$ba8f0630$a501280a@.phx.gbl...
I have the above set on all my databases on one of our
2000 production servers. However, this server has a lot
of databases (about 150) and about 300+ Gig on it. I
remember reading an article posted here about an issue
where if a server has a lot of databases, it may need
manual runs of stats.
Can someone repoint me to that article? It actually
outlined the algorithm that Sql Server used, etc.
I couldn't find it in the kb or bol.|||Great article but that's not it. This article dealt more
with how Sql Server "round robins" through the databases
and the timing of that, etc.
>--Original Message--
>Is this the one you are referring to?
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q195565
>--
>HTH,
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/
>
>"GoBoy" <anonymous@.discussions.microsoft.com> wrote in
message
>news:178a01c4c1c5$ba8f0630$a501280a@.phx.gbl...
>I have the above set on all my databases on one of our
>2000 production servers. However, this server has a lot
>of databases (about 150) and about 300+ Gig on it. I
>remember reading an article posted here about an issue
>where if a server has a lot of databases, it may need
>manual runs of stats.
>Can someone repoint me to that article? It actually
>outlined the algorithm that Sql Server used, etc.
>I couldn't find it in the kb or bol.
>
>.
>