Configuring a Workload
- User-defined types
- User-defined functions/external stored procedures
- Foreign server definitions
- Tables with circular referential integrity
- On the Overview page in the Getting Started section, click Add a Workload.
- Under Workload Settings, enter the required information and click SAVE.
- Add a database or individual objects to the workload.
Adding a user database copies the objects in the database but not does not apply access rights unless you select the user as one of the user workloads.
Screen Action Databases
- Click .
- Select one or more databases and click Add n Selected.
- Click .
- Select one or more objects and click Add n Selected.
- [Optional] On the Objects screen, select one or more objects to modify the object settings.Included objects automatically inherit the default settings that you define when configuring a job.
Option Description Foreign View
Uses QueryGrid to create a view on the target system that points back to the original table on the source system.
Common use cases: (1) a large source table not heavily used by the workload, or (2) a frequently-updated source table for which the workload requires access to the most recent data.
[Tables, hash indexes, and join indexes only]
Copies statistics from the source to the target system. This option is not available if the object is copied as a foreign view. Skip Does not copy an object if it already exists on the target system. Exclude Excludes objects from the workload.
Common use case: if you select an entire database (which includes all its associated objects) but want to exclude temporary or unused objects.
Include Includes an object that was previously excluded.
- On the Users screen, select individual users to copy to the target system.Copying users to the target system applies the same permissions they have on the source system.