Description of the feature
SELECT
edition = DATABASEPROPERTYEX(DB_NAME(), 'Edition'),
service_objective = DATABASEPROPERTYEX(DB_NAME(), 'ServiceObjective');
if the Service Objective (Tier)
MS response:
The basic, S0,S1 and S2 tiers in Azure SQL Database are part of the Standard DTU-based purchasing model, which offers limited compute and memory resources:
making them unsuitable for resource-intensive operations like DBCC CHECKDB or CHECKTABLE. Microsoft recommends S3 or higher for such workload
A small database that is has less than 12 GB of data and 252 tables, takes 4 to 5 hours because it hits it Limits.
if service tier is to low just spit a message out or to log table