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 |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2012-07-26 : 12:33:42
|
| I intend to Create Maintenance Plans --- Reorganize Index and Rebuild IndexWhen the best time to perform Maintenance Plans --- Reorganize Index and Rebuild Index?Is that the user is not interace with the database? Or the activity is low?Need explanation |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-07-27 : 21:42:34
|
| Like Tara said, when low or no activity is taking place is the best time. Usually midnight or after hours, but it depends.You can also use Perf. Monitor and track server activity. I did that at my new work. Not only allows you to create a baseline for all your servers but you will know exactly what your peak hours are. Set it for 5 days or a week. Perf. Mon files are really small, just a few MB.Also, check online for nice Defrag job solutions (I think that Tara has one) Those are smart jobs and defrag depending of the fragmentation value and number of pages. |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
|
|
|
|
|
Maintenance Plans --- Reorganize Index and Rebuild