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 |
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2009-02-04 : 10:31:41
|
Should I be running updatestats and index rebuild on the 2 ssrs dbs like I do with my own dbs? |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 10:44:01
|
Do they show any fragmentation when you check? |
 |
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2009-02-04 : 12:09:43
|
not much, but wont it get worse over time? |
 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 12:11:46
|
You could do it:http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/overlooking-system-databases-and-fragmen |
 |
|
|
|
|