Maintenance Plans - Master, MSDB, etc.

I currently have a maintenance plan setup to do typical
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
MarkOptimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>