rweisssieker-xp/AX2012_Performance_Advisory - Page 2

ai-remediation-planner

Convert many AXPA findings into a phased remediation plan.

ai-runbook-copilot

Produce step-by-step operator runbook guidance for top AXPA findings.

ai-safe-action-classifier

Classify AXPA recommendations as observe, maintenance-window, TEST-only, CAB-required, or review-required.

ai-sql-plan-interpreter

Interpret SQL plan and query findings for AX workloads.

ai-ticket-auto-drafting

Draft Azure DevOps or Jira tickets from AXPA findings.

natural-language-root-cause-chat

Answer operator questions such as why AX is slow by grounding responses in AXPA evidence and findings.

aos-load-analysis

Analyze AOS counters, user sessions, batch/service distribution, AOS topology, and load-separation recommendations.

approval-workflow-governance

Manage findings through approval states from proposed to reviewed, approved, implemented, validated, and closed.

autonomous-evidence-planner

Identify missing evidence and produce a targeted read-only collection plan for low-confidence AX performance findings.

azure-devops-jira-export

Export or push AXPA findings as Azure DevOps or Jira tickets with dry-run support and credential checks.

blocking-analysis

Analyze SQL blocking, deadlocks, lock waits, root blockers, affected AX tables, and recommended low-risk remediation.

causal-graph-analysis

Analyze AX performance as a cause-effect graph linking root causes, waits, findings, tables, and business impact.

change-blast-radius-analysis

Analyze which AX modules, tables, findings, owners, and processes may be affected by a planned change.

custom-code-risk-map

Map custom AX code, X++ classes, reports, services, query families, and findings to owners and risk.

daily-health-check

Run a daily AX 2012 and SQL Server health check with prioritized risks, module health scores, root causes, and management summary.

data-lifecycle-advisor

Analyze AX table growth, archive candidates, retention policy, archiving impact, and lifecycle ROI.

environment-drift-analysis

Compare AX environments, explain TEST-vs-PROD gaps, produce repro checklist, and summarize fleet risk.

evidence-pack-audit

Create audit-ready evidence packs with masking, chain of custody, evidence quality grades, and validation artifacts.

index-risk-review

Review SQL Server missing-index and plan-warning evidence through AX-specific risk, write overhead, existing index overlap, and rollback guidance.

itil-change-draft

Generate ITIL/CAB change drafts from AX performance findings with risk, test plan, rollback, validation, and approval workflow.

knowledge-base-governance

Maintain known issues, self-healing rules, feedback loops, and anonymized AX performance pattern libraries.

legacy-modernization-advisor

Evaluate AX 2012 legacy risk, SQL Server 2016 lifecycle exposure, D365 migration signals, and modernization drivers.

operator-copilot-runbook

Generate operator runbooks, copilot context, next checks, incident replay, and root-cause narratives.

parameter-sniffing-analysis

Analyze plan-cache variance, Query Store runtime variation, and parameter-sensitive AX query candidates.

performance-contract-testing

Define and evaluate AX performance contracts, budgets, release gates, and generated regression tests.

performance-debt-governance

Govern recurring AX performance findings through debt register, debt interest, cost of delay, and continuous improvement scorecards.

performance-digital-twin

Build and use an AX performance digital twin containing topology, query families, hot tables, batch workload, AOS nodes, and business calendar.

powerbi-report-export

Export AXPA findings and metrics for Power BI CSV datasets or streaming endpoint push when credentials are configured.

query-store-regression-analysis

Analyze Query Store and plan-cache runtime evidence for SQL plan regressions and release-gate decisions.

remediation-portfolio-optimizer

Compare remediation scenarios and choose high-benefit, low-risk AX performance action portfolios.

sensitive-data-governance

Detect sensitive evidence boundaries, apply masking policies, and prepare share-safe AX performance evidence.

sla-anomaly-forecasting

Analyze SLOs, SLA breach prediction, anomalies, capacity exhaustion, and performance budgets for AX workloads.

statistics-maintenance-review

Analyze stale SQL statistics, modification counters, plan risk, and maintenance-window recommendations for AX workloads.

tempdb-io-analysis

Analyze TempDB pressure, file latency, PAGEIOLATCH/WRITELOG waits, spills, and storage-related AX performance risk.

temporal-hotspot-analysis

Analyze AX workload pressure by hour, day, business calendar, and maintenance window.

traceparser-dynamicsperf-analysis

Analyze Trace Parser and DynamicsPerf evidence, including long-running X++ code, SQL queries, call counts, call trees, and Query-to-X++ links.

ax-performance-analysis

Analyze Dynamics AX 2012 R3 performance by correlating SQL Server, AOS, batch, Trace Parser, and DynamicsPerf evidence into prioritized explainable findings.

batch-job-optimization

Analyze Dynamics AX 2012 batch jobs, SysOperation workloads, collisions, runtime trends, and SQL side effects to recommend safer scheduling and tuning actions.

management-report-generator

Generate executive and change-control reports for AX 2012 performance findings with risk, impact, evidence, recommendations, and audit-ready action plans.

sql-server-query-tuning

Interpret SQL Server 2016 performance evidence for Dynamics AX 2012 workloads, including expensive queries, waits, indexes, statistics, plan cache, Query Store, and parameter sniffing.