---
id: post/duiliotacconi-com/1786
type: post
title: Guid.CreateSequentialGuid in AL
summary: Dynamics 365 Business Central 2025 Wave 2 introduces Guid.CreateSequentialGuid, a new AL statement that generates sequential GUIDs instead of random ones, reducing index fragmentation and improving performance for GUID-based keys and systemId fields without requiring SQL roundtrips.
tier: community
language: en
tags:
  - guid generation
  - performance optimization
  - index fragmentation
  - al development
  - sequential identifiers
system: development
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:57:54.941Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 6618d85fd47684f5b0e957537128a8ea0f37393d34cb2a7db8ab31c2ad7f0cee
evidence:
  - kind: blog
    url: https://duiliotacconi.com/2025/12/24/guid-createsequentialguid-in-al/
    title: Guid.CreateSequentialGuid in AL
    date: "2025-12-24"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://duiliotacconi.com/2025/12/24/guid-createsequentialguid-in-al/
    title: Guid.CreateSequentialGuid in AL
    date: "2025-12-24"
    commit: null
    t: null
    quote: sequential GUID will be created at NST level (in the middle tier) - no useless roundtrip to SQL
  - kind: blog
    url: https://duiliotacconi.com/2025/12/24/guid-createsequentialguid-in-al/
    title: Guid.CreateSequentialGuid in AL
    date: "2025-12-24"
    commit: null
    t: null
    quote: indexes are reduced in fragmentation compared to randomly generated GUIDs
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "1786"
source_id: duiliotacconi-com
source_name: Duilio Tacconi
url: https://duiliotacconi.com/2025/12/24/guid-createsequentialguid-in-al/
published_at: "2025-12-24T15:01:51.000Z"
author: Duilio Tacconi
full_text: false
words: 581
quotes:
  - text: sequential GUID will be created at NST level (in the middle tier) - no useless roundtrip to SQL
    why_it_matters: "Explains the architectural advantage of the new feature: eliminating database roundtrips improves performance"
  - text: indexes are reduced in fragmentation compared to randomly generated GUIDs
    why_it_matters: "Highlights the core benefit: sequential GUIDs maintain index integrity better than random ones"
code_objects_mentioned: []
systems:
  - development
  - platform
versions_mentioned:
  - 2025 Wave 2
preview:
  embeddable: true
  frame_url: https://duiliotacconi.com/2025/12/24/guid-createsequentialguid-in-al/embed/
  image: https://duiliotacconi.com/wp-content/uploads/2025/12/sequentialguidgenv.png
  image_alt: null
  image_w: 736
  image_h: 317
  site_name: Dynamics 365 Business Central tales, myths, legends. And something serious.
  favicon: https://duiliotacconi.com/wp-content/uploads/2023/07/cropped-wordpress.png?w=32
  probed_at: "2026-10-07T11:50:45.516Z"
---

# Guid.CreateSequentialGuid in AL

[Read the post](https://duiliotacconi.com/2025/12/24/guid-createsequentialguid-in-al/) · Duilio Tacconi (Duilio Tacconi, MVP) · 2025-12-24 · 581 words · tier community · reviewed (checked by Opus)

> Dynamics 365 Business Central 2025 Wave 2 introduces Guid.CreateSequentialGuid, a new AL statement that generates sequential GUIDs instead of random ones, reducing index fragmentation and improving performance for GUID-based keys and systemId fields without requiring SQL roundtrips.

## Key points

- Guid.CreateSequentialGuid, new in Business Central 2025 Wave 2, produces consecutive GUIDs instead of the random ones from CreateGuid.
- GUIDs are generated on the NST middle tier, so no extra roundtrip to SQL Server is needed.
- The main benefit is fewer page splits and less index fragmentation; generation may also be slightly faster.
- The author recommends replacing CreateGuid with CreateSequentialGuid in new or refactored code, since GUIDs are increasingly common in API-facing tables.

## Quotes

- "sequential GUID will be created at NST level (in the middle tier) - no useless roundtrip to SQL" (Explains the architectural advantage of the new feature: eliminating database roundtrips improves performance)
- "indexes are reduced in fragmentation compared to randomly generated GUIDs" (Highlights the core benefit: sequential GUIDs maintain index integrity better than random ones)

## Context

- Features: Guid.CreateSequentialGuid, sequential GUID generation
- Versions: 2025 Wave 2

Source: Duilio Tacconi, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.