Changetracking and Temporaldb data

[srini1978]

If we enabled Read scale out on Azure hyperscale db, can the read only copy access change tracking and temporal db information ?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 7a2961d1-4448-11b7-2dc2-3b738bd70939
• Version Independent ID: 206eb022-25c4-66d7-7285-0d53a84956e3
• Content: Read queries on replicas - Azure SQL Database
• Content Source: articles/sql-database/sql-database-read-scale-out.md
• Service: sql-database
• Sub-service: scale-out
• GitHub Login: @anosov1960
• Microsoft Alias: sashan

[NavtejSaini-MSFT]

@srini1978 We are checking this and will get back to you.

[NavtejSaini-MSFT]

@srini1978 The Document explains this here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out#using-tempdb-on-read-only-replica Hope this helps.

[NavtejSaini-MSFT]

@srini1978 Please let us know if you have any further question on Temp DB. Regd Change tracking we are trying to find this info and will let you know once we have an answer.

[NavtejSaini-MSFT]

@yorek Please check this thread further and provide input.

[srini1978]

@NavtejSaini-MSFT I apology for the confusion but my question was on temporal tables support - https://docs.microsoft.com/en-us/azure/sql-database/sql-database-temporal-tables in Hyperscale database

[yorek]

Temporal Tables can be used on Secondary Replicas, while Change Tracking is not available on Secondary Replicas at the moment,

[NavtejSaini-MSFT]

@yorek Thanks for the reply. @srini1978 Let us know if you need any further help.

[srini1978]

@NavtejSaini-MSFT @yorek Thanks for helping me but let me post the original question. @yorek you have answered for the secondary replica however the question was on the read scale out. If we enabled Read scale out on Azure hyperscale db, can the read only copy access change tracking and temporal db information ?

[yorek]

Secondary Replicas and Read-Scale out, at the moment, in Azure SQL Hyperscale are the same thing.

[srini1978]

Thanks @yorek . So if I look at this link - https://azure.microsoft.com/en-in/updates/azure-sql-database-hyperscale-change-tracking-support-now-available/ where it says change tracking is available for the hyperscale, it means only the primary replica. is there a plan to make it available for secondary replica and scale out in future ?

[yorek]

Hi @srini1978. That's correct. AFAIK the limitation exists for all secondaries, not only for Azure SQL Hyperscale secondaries. Yes, the idea is to have CT available on secondaries too. Unfortunately at the moment I don't have any ETA to share.

[srini1978]

Thanks @yorek

[NavtejSaini-MSFT]

@yorek Thanks for all the help here. @srini1978 We are going ahead and closing this thread, you can also provide your feedback if you need this feature here. https://feedback.azure.com/forums/217321-sql-database