First of all, Azure SQL Database does not have the SQL Server Agent as a service. If you are running SQL Server in an Azure VM, or are using Azure SQL Managed Instance, you can use the Agent but ...

But if you have a large database (in several GBs or TBs), separating the data into different files help you to optimize the performance. You can store the data files in different disks. This will also ...