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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2009-01-24 : 07:14:02
|
| Is it possible to perform re-indexing automatically? or does SQLserver do it by default? the problem is that our server performance is extremely low for around 15 minutes then it turns back to the normal state. I'd like to know if it is due to reindexing Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-24 : 11:13:45
|
| SQL won't rebuild indexes (or create indexes, or drop indexes) unless you tell it to do so.Check what jobs are running when the server goes slow. Especially if it's a regular occurrence.--Gail ShawSQL Server MVP |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2009-01-25 : 00:47:39
|
| Thank you Gail Another question is can we define a job to rebuild indexes? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2009-01-25 : 01:02:26
|
| Thank you very much indeed Tara :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Automatic Re-indexing