Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhjackal
Starting Member
42 Posts |
 Posted - 2009-08-20 : 09:47:41
|
| I have a maintenance plan which run nightly to check db integrity and backup my system databases. My question is ; Is it ever necessary to rebuild / reorganise indexes or update statistics in the system databases?All comments / suggestions appreciated |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-20 : 10:10:15
|
| No. |
 |
|
|
dhjackal
Starting Member
42 Posts |
Posted - 2009-08-20 : 10:19:55
|
| Thanks Sodeep. Slightly off topic but if i rebuild / reorganise the indexes on my tables is it necessary to rebuild statistics or are they rebuilt as part of the rebuild / reorganise? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-20 : 12:23:13
|
| Rebuilding indexes will take care of updating statistics with Full Scan. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-08-20 : 13:19:27
|
| Rebuilding may be useful in MSDB, especially for things like the job history and backup history tables. Not for the other system DBs though. Master's seldom changed (new logins, new databases, new linked servers). Model should never be changed. TempDB should only have temp tables.--Gail ShawSQL Server MVP |
|
|
|
dhjackal
Starting Member
42 Posts |
Posted - 2009-08-24 : 06:13:25
|
| Thanks Sodeep / GailYour replies are appreciated. I'll amend my maintenance plans accordingly. |
|
|
|
|
|
|
system databases - maintenance plan