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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-06-20 : 18:28:37
|
| From BOL I assumed that DBReindex can be run anytime. But after reading some forums, I am confused. I donot have it set up in the maintenance plan because I remember one time I tried, it filled up log. Luckily, we weren't live that time.Can I run when users are logged in? - We have lot of queries and processess running because we process payroll weekly.How often should I perform DBREINDEX? Can I not get an idea from some parameter that it is time to run or should I just wait until users complain about slow performance?Thanks,Sarat. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-06-20 : 20:03:24
|
| Why are you constantly rebuilding indexes? Are you suffering from data (index) corruption? Is it just bad performance? Is it possible you just need to UPDATE STATISTICS? Or maybe you need a different index schema than you currently have? |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2002-06-20 : 20:27:20
|
| I haven't run DBREINDEX until now. I want to know if it is std maintenance thing which we should run now and then and if yes what is the best way to do it.everything (data n performance) is good until now.sarat. |
|
|
|
|
|
|
DBCC DBREINDEX