Don't start your partitioning adventure in production !

Read this thoroughly : https://www.sqlservercentral.com/forums/topic/partition-large-tables-needed#post-4292250

ref Partitioned tables and indexes

ref Create partitioned tables and indexes

ref SQL Server Partitioning: Getting Started

You can create different filegroups and different files on AzureSQLMI, you just cannot provide it with a filename !

Read Jeff's advice thoroughly!

Then decide...

Server side trace will have the least impact.

Have  look at the included sql file.

It needs a table in your DBA database. ( see script )

It creates 3 SQLAgent job:

1. DBA_SQLTrace_7Zip...

• You have not mentioned the version of the original SQL Server instance.
• For instances that do not support extended events, we used a (random) sampling methode to get a...

Have you tested that ?

CREATE DATABASE [MyPtDbOnSQLMI]
 CONTAINMENT = NONE

GO

ALTER DATABASE [MyPtDbOnSQLMI]...

Have you taken a look at this: Configure backups on secondary replicas of an Always On availability group

or this ( and the following ): Understanding backups on AlwaysOn...

Did we mention that autogrow should never be in percentages !  ( as the size of the growth gets larger every time it is executed )

If want to enable autogrowth,...

Yes !

ref: Database instant file initialization

For non-LOG files, IFI causes the grow to be 'instantly'...

Best is to prevent the autogrow !

Set the file to a size(s) you estimate will be needed to host the data for the next couple of months / years

Is this on an Azure Managed instance ? You need to put temporal tables in place to have access to job history.

• Have you rebuild all indexes and statistics after migration/upgrade ?
• Did you compare old vs new SQLplans ?
• How many indexes / indexed views are based on the target...

FWIW If you don't need sub second information in datetime2 values, just use datetime2(0) ( and you gain 2bytes storage )

done.

Now, send me the email 😎

How did you notice that?

Have you tested it?

Whas there an errormessage?

Why would you consider version 18?