@sakuraime

Can you please convey what is the use case here. The Azure SQL server handles this internally. Please convey the premises behind the ask to take this further.

Thanks
Navtej S

@sakuraime

We did check with our team and got the following answer:

"The answer is that we don’t document how we physically store files (whether they are on the primary or a user defined filegroup) for Managed Instance except that for General Purpose we use Azure Blob Storage and for Business Critical we use local SSD storage."

These are handled internally for all the PaaS services. Additionally if the concern is failure of disk, rest assured that Azure takes care of ensuring the safety of the data.

Hope this helps.

Thanks
Navtej S

@sakuraime

Please let us know if you need any further help regarding this.

Thanks
Navtej S

@SagiShkedy-4729 Please let us know if you need any further help with this,

@William-8680

Please let us know if you further help.

Regards
Navtej S

@RaikarNiranjan-1486 Were you able to check this and raise the ticket with support.

@RaikarNiranjan-1486

Thank you for using Microsoft Q&A. Please check this document which explains the details on rebuilding the index. Also mentions the performance gets better with time.

Having said that we would recommend here that you raise a ticket with support as they will need to check your workload and set up to check this issue better. Please share the ticket number and we can get traction for the same.

Please let us know if you need any further help.

Regards
Navtej S

@MahmoudElsayed-5211 Were you able to check this further,

@MahmoudElsayed-5211

Our team has conveyed that this appears to be issue with the backup file itself, which is not created by Cosmos DB. Can you confirm the same sequence of commands works in native MongoDB?

Please convey to take this forward.

Regards
Navtej S

@sqluser-0880 We don’t stream query text to LA b/c it’s PII data. You can find the query text corresponding to a query id by querying the azure_sys database directly. The view query_store.query_texts_view has the mapping.

Please let us know if any other question.

Regards
Navtej S

@CloudRock We are checking with our team regarding this and will get back to you.

@AdamPliska-1173 Please let us know if you need any further help.