Guidance on running `3_job_AdaptiveIndexDefrag` on Azure SQL
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
- Issue type
- Documentation
- Clarity
- Needs clarification
- Activity status
- Stale
- Tech stack
- azure, sql
- Domain
- cloud, databases, documentation
Research direction
Start by reading 3_job_AdaptiveIndexDefrag.sql and usp_AdaptiveIndexDefrag.sql, then compare their database context and references to Azure SQL capabilities. Check how references such as msdb.dbo.sysjobs apply in Azure SQL. Done means the repository documents the required context and a clear way to create or run the job in Azure SQL.
Written by the indexing model from the issue text.
Description
Trying to understand how to run 3_job_AdaptiveIndexDefrag.sql in an AzureSQL database is unclear, the only guidance in the scripts is on the usp_AdaptiveIndexDefrag.sql and it just says:
-- If you are using AdaptiveIndexDefrag together with the maintenance plans in http://blogs.msdn.com/b/blogdoezequiel/archive/2012/09/18/about-maintenance-plans-grooming-sql-server.aspx
-- please note that the job that runs AdaptiveIndexDefrag is expecting msdb. As such, change the database context accordingly.
But what is the context? what about the tables that don't exist in AzureSQL? tables and views like dbo.sysjobs don't exist so how are jobs managed and created?
- Dominant language
- Jupyter Notebook
- Stars
- 1.6k
- Forks
- 749
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from microsoft/tigertoolbox
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
microsoft/tigertoolbox#320 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 72/100
microsoft/tigertoolbox#199 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 48/100
microsoft/tigertoolbox#319 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
microsoft/tigertoolbox#312 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
microsoft/tigertoolbox#311 ·
All issues in microsoft/tigertoolbox
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
bug confmap/provider/googlesecretmanagerprovider needs triage
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
open-telemetry/opentelemetry-collector-contrib#51273 · 2 comments ·
-
Feature needs-triage pulumi/registry
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
infrastructure launch: scale production
Difficulty 2/5 Half a day Newbie friendliness 72/100
Practitionist/familiarise_web#1772 ·