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 |
|
debug2k
Starting Member
18 Posts |
 Posted - 2004-04-22 : 12:24:59
|
| Hi All,Need a foolproof Reindexing and checkdb strategy for a critical 24X7 database.Platform is SQL 2000 Standard edition.3 Databases - Max DB size 5 GBRegards,Debug |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-22 : 12:56:34
|
| DBCC DBREINDEX or DBCC INDEXDEFRAGandDBCC CHECKDBWe run them at least once a week, on some systems daily.Tara |
 |
|
|
debug2k
Starting Member
18 Posts |
Posted - 2004-04-23 : 07:54:49
|
| Thanks Tara.But i beleive u do it on off peak hours. and are these Shed jobs or u do it manuallyRegards,Deepak U |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-04-23 : 10:10:53
|
| Run DBCC Checkdb at least once a week or nightly. Why are you running Reindex? Are you having performance issues? If so you should start with doing an 'update stats' on any problem tables and see if this helps first. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 12:17:10
|
| You should have DBCC DBREINDEX scheduled as well. You don't just run it when you have performance issues. You do it to keep things optimized.So yes you have both scheduled and yes they are performed during off peak hours.Tara |
|
|
|
|
|
|
Reindexing and check DB strategy for 24X7 database