AI agents: use the documentation index at llms.txt to locate machine-readable pages. This section is indexed by https://docs.particular.net/transports/llms.txt. The markdown version of this page is served as plain text. An MCP server at /mcp serves the same content via the search_docs and read_doc tools; it is read-only and needs no credentials. Markdown versions of documentation pages are available by appending .md to the page URL. Directory URLs use index.md. They are served as text/plain because some retrieval backends reject text/markdown.

SQL Server Transport Upgrade - Non-clustered index in the input queue

This document explains how to patch a system using the SQL Server transport to remove clustered index on the queue table for improved performance.

Upgrade steps

Existing queue tables need to be migrated manually to the new schema. This can be done by executing the following script for each input queue table in the system:

DROP INDEX [Index_RowVersion] ON <schema>.<table> WITH ( ONLINE = ON )

CREATE NONCLUSTERED INDEX Index_RowVersion ON <schema>.<table>
(
    [RowVersion] ASC
)

This will result in dropping the clustered index Index_RowVersion and creating a new non-clustered index with the same name.

New index schema creation script has been introduced in the following patch version of the SQL Server transport:

In this article