0

Similar to Azure single database (PaaS), Azure SQL Managed Instance does not allow referencing or creating physical files on disk. However, it does still support filegroups when restoring an on-premise backup that used them or by using the ALTER DATABASE command.

This is great for migration compatibility for existing projects but are there performance benefits from using filegroups in managed instance (cloud hosted storage)?

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168
defect833
  • 275
  • 7
  • 22

1 Answers1

1

There is a blog post from the SQLCAT team describing best practices. In general you want to have the largest file size that you can to increase the IOPS.

My interpretation is that if by splitting the database to have multiple files then the sum of the individual IOPS would need to be larger than the corresponding single file IOPS. It may be that you end up with less.

Martin Cairney
  • 1,714
  • 1
  • 6
  • 18