Skip to content

for the dbo.DatabaseIntegrityCheck Add Azure Feature if service tier is to low just spit a message out or to log table #946

@lostsole

Description

@lostsole

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

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions