DB Maint. Plans on system databases

Is it recommended to run Optimization and Integrity Checks on system
databases? What's recommended?Hi,
Since the data change is very less, it is not required to perform a DBCC on
system database frequently.
May be you can execute the DBCC once in a month.
Thanks
Hari
MCDBA
"David Morrison" <davidbmorrison@.nospam.com> wrote in message
news:O70Ikfm7DHA.1592@.TK2MSFTNGP10.phx.gbl...
> Is it recommended to run Optimization and Integrity Checks on system
> databases? What's recommended?
>|||Thanks for the advice. Should I do this on all system databases?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23s8Rpmm7DHA.2168@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Since the data change is very less, it is not required to perform a DBCC
on
> system database frequently.
> May be you can execute the DBCC once in a month.
>
> Thanks
> Hari
> MCDBA
>
> "David Morrison" <davidbmorrison@.nospam.com> wrote in message
> news:O70Ikfm7DHA.1592@.TK2MSFTNGP10.phx.gbl...
>|||Hi,
You can do it on Master , MSDB and Model databases. Tempdb is not required,
since it is getting created on every service start.
Thanks
Hari
MCDBA
"David Morrison" <davidbmorrison@.nospam.com> wrote in message
news:uoggYpm7DHA.1040@.TK2MSFTNGP10.phx.gbl...
> Thanks for the advice. Should I do this on all system databases?
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23s8Rpmm7DHA.2168@.TK2MSFTNGP12.phx.gbl...
> on
>|||Thanks Hari!
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:eZT3UBn7DHA.712@.tk2msftngp13.phx.gbl...
> Hi,
> You can do it on Master , MSDB and Model databases. Tempdb is not
required,
> since it is getting created on every service start.
> Thanks
> Hari
> MCDBA
>
> "David Morrison" <davidbmorrison@.nospam.com> wrote in message
> news:uoggYpm7DHA.1040@.TK2MSFTNGP10.phx.gbl...
DBCC
>|||I agree with Hari regarding fragmentation. As for integrity checks, I'd do
it more often. Yes, I am paranoid.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"David Morrison" <davidbmorrison@.nospam.com> wrote in message
news:O70Ikfm7DHA.1592@.TK2MSFTNGP10.phx.gbl...
> Is it recommended to run Optimization and Integrity Checks on system
> databases? What's recommended?
>