Add 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 −

ALTER DATABASE ADD <service>

Following perquisites should be met to perform this task −

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