Adding a service to a tenant database

To scale out a tenant database and/or distribute it across multiple hosts, you can add further server components, for example, an additional index server or a separate XS server. You add a service to a tenant database using the ALTER DATABASE SQL command.

You do this from the system database using the following command −


Following perquisites should be met to perform this task −

  • You are logged on to the system database.
  • You have the system privilege DATABASE ADMIN.