Series
Indexes, set-based operations, temp tables, batch parallelism, and the Trace Parser habits that keep F&O jobs under an hour.
6 articles
HTTP 429 from Dynamics 365 Finance & Operations is usually the query shape, not the request count — cross-company scans, $filter that cannot seek, $batch that still burns SQL, and why retrying harder makes month-end worse.
Design resilient D365 Finance and Operations OData integrations with 429 handling, Retry-After, batching, backoff, jitter, and DMF fallbacks.
How to scale D365 F&O batch: batch groups bound to servers, max threads per AOS, splitting work into parallel tasks with SysOperation, task dependencies, and troubleshooting.
Clear X++ guide to TempDB vs InMemory temporary tables in D365 F&O, with joins, indexes, set-based operations, and performance tradeoffs.
How to diagnose and fix slow X++ queries in D365 Finance & Operations using Trace Parser, LCS SQL insights, execution plans, proper index design, join selection, and set-based operations.
How to build batch jobs using the SysOperation framework in D365 Finance & Operations — contract, controller, and service classes with X++ code samples.
