Skip to content

rebuild index never done ONLINE on Azure SQL ? due to EngineEdition IN (1804890536, 1872460670, 610778273, -2117995310) #319

@Strada-EricFr

Description

@Strada-EricFr

hi,
not sure but in the code of usp_AdaptiveIndexDefrag.sql
/* Refer to http://docs.microsoft.com/sql/t-sql/functions/serverproperty-transact-sql */
IF (SELECT SERVERPROPERTY('EditionID')) IN (1804890536, 1872460670, 610778273, -2117995310)
SET @editionCheck = 1 -- supports enterprise only features: online rebuilds, partitioned indexes and MaxDOP
ELSE
SET @editionCheck = 0; -- does not support enterprise only features: online rebuilds, partitioned indexes and MaxDOP

running in Azure SQL, it will set then @editionCheck = 0; correct ?
Anf when readign this:
https://learn.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-ver17

Database Engine edition of the instance of SQL Server installed on the server.

1 = Personal or Desktop Engine (Not available in SQL Server 2005 (9.x) and later versions.)
2 = Standard (For Standard, Standard Developer, Web, and Business Intelligence.)
3 = Enterprise (For Enterprise, Enterprise Developer, Developer, and Evaluation editions.)
4 = Express (For Express, Express with Tools, and Express with Advanced Services)
5 = SQL Database
6 = Azure Synapse Analytics
8 = Azure SQL Managed Instance
9 = Azure SQL Edge (For all editions of Azure SQL Edge)
11 = Azure Synapse serverless SQL pool, or Microsoft Fabric
12 = Microsoft Fabric SQL database in Microsoft Fabric.

I have add in my script this :
/* Azure SQL Database / Hyperscale always supports online index rebuilds regardless of EditionID */
IF @engineedition IN (5, 8)
SET @editionCheck = 1;

to suppor Azure SQL

Did my understand is wrong ?

regards,
Eric

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions