Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Installing AdaptiveIndexDefrag in MSDB ONLY to Defrag Multiple Databases #259

Open
MTL777 opened this issue Oct 21, 2021 · 1 comment
Open

Comments

@MTL777
Copy link

MTL777 commented Oct 21, 2021

This is not really an issue I am posting. I just have questions about AdaptiveIndexDefrag:

  1. 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.

  2. 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!

@jinja365
Copy link

jinja365 commented Mar 2, 2022

just put 2 footballs in orange juice thats how you fix it

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants