DB Maintenance

Hi All,
Are there any nightly or weekly proceeses I should be
running? How often should I run sp_updatestats on all my
DBs?
Are there any Microsoft suggested maintenance plans? If
so are they published anywhere?
Thanks,
GPHi,
You can execute the update statistics on all databases based on the time
user access is limited. In my case I am
doing update statistics daily scheduled usng the SQL Agent -- Jobs.
How often should I run sp_updatestats on all my DBs?
Depends up on the amount of Insert / Update and Delete happening in the
table. If your application makes many modifications to the data in
a particular table, update the statistics frequently to improve the
efficiency of queries
Are there any Microsoft suggested maintenance plans? If so are they
published anywhere?
Have a look in the below link;
http://www.sql-server-performance.com/statistics.asp
Thanks
Hari
MCDBA
"GeorgeP" <anonymous@.discussions.microsoft.com> wrote in message
news:19f2301c41d5b$d9bd7c80$a301280a@.phx.gbl...
> Hi All,
> Are there any nightly or weekly proceeses I should be
> running? How often should I run sp_updatestats on all my
> DBs?
> Are there any Microsoft suggested maintenance plans? If
> so are they published anywhere?
> Thanks,
> GP|||Thanks for the info!
I am sure once a week will be sufficient for my Databases.
GP