Can I Run a maintenance plan that does Index Maintenance anytime?
I've got a slow database right now and I have a index maintenance plan that is set to run every week. I did database update yesterday and today system is very sluggish.
Can I run this maintenance plan now, while there are people connected to the database
- rebuild index task
- update statistics task
the database is about ~60MB and right now there is about 10 users connected to it.
what is the proper procedure for running this maintenance plan? it is scheduled to run each sunday 02:00