You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This is not really an issue I am posting. I just have questions about AdaptiveIndexDefrag:
By default the script creates the objects that AdaptiveIndexDefrag needs in the system database MSDB. In this setup with its objects in MSDB, can I use it to defrag the indexes in multiple databases all at the same time using several SQL Server jobs, one for each database? Will the SQL Server jobs not be colliding with each other, causing resource sharing or locking conflicts? I hope it will work fine and be able to defrag indexes in multiple databases when installed in MSDB alone because we have many databases on our server and it would be a pain to install it on each one. So my plan is for each SQL Server job to call EXEC MSDB.dbo.usp_AdaptiveIndexDefrag in the context of the particular database that each SQL Server job is assigned to operate upon.
If I setup the SQL Server jobs to start defragging our databases all together at 1:00 AM, would that be a good plan or should I setup the SQL Server jobs to start running at different times?
Thanks you so much in advance!
The text was updated successfully, but these errors were encountered:
This is not really an issue I am posting. I just have questions about AdaptiveIndexDefrag:
By default the script creates the objects that AdaptiveIndexDefrag needs in the system database MSDB. In this setup with its objects in MSDB, can I use it to defrag the indexes in multiple databases all at the same time using several SQL Server jobs, one for each database? Will the SQL Server jobs not be colliding with each other, causing resource sharing or locking conflicts? I hope it will work fine and be able to defrag indexes in multiple databases when installed in MSDB alone because we have many databases on our server and it would be a pain to install it on each one. So my plan is for each SQL Server job to call EXEC MSDB.dbo.usp_AdaptiveIndexDefrag in the context of the particular database that each SQL Server job is assigned to operate upon.
If I setup the SQL Server jobs to start defragging our databases all together at 1:00 AM, would that be a good plan or should I setup the SQL Server jobs to start running at different times?
Thanks you so much in advance!
The text was updated successfully, but these errors were encountered: