I have a Maintenance plan that runs once per week to optimize all of the databases on the server. The plan tries to 'Re-organize Data and Index Pages' and set the 'Free space per page percentage' to 10%. When this plan last ran it took 44 hours to comlpete!
I noticed on monday that there were 4 x SQLMAINT.exe's running on the server.
The server is in a production environment that runs 24x7.
I set the time of the plan to run at 02:30 on monday mornings every week - this is when the server is at its lowest activity (event still, the processes are still accessing the database).
On monday i stopped all of the production processes running, after this the maint plan completed and the 4 x SQLMAINT.exe's were gone.
What can cause this? was there a process holding onto a resource that caused the SQLMAINT.exe's to wait?
Any advice would be most greatful, especially on when and when not to carry out maintenance on the database.
thanx
I noticed on monday that there were 4 x SQLMAINT.exe's running on the server.
The server is in a production environment that runs 24x7.
I set the time of the plan to run at 02:30 on monday mornings every week - this is when the server is at its lowest activity (event still, the processes are still accessing the database).
On monday i stopped all of the production processes running, after this the maint plan completed and the 4 x SQLMAINT.exe's were gone.
What can cause this? was there a process holding onto a resource that caused the SQLMAINT.exe's to wait?
Any advice would be most greatful, especially on when and when not to carry out maintenance on the database.
thanx