Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Tenant databases

Profiling databases

Configure the cloud to allow users to profile tenant databases using the SQL Anywhere Profiler.

Prerequisites

You must have the AlterCloud privilege.

Your cloud must not have any version 12 cloud servers.

The tenant databases that you want to profile must run on version 17 or higher cloud servers.

Context

To use the SQL Anywhere Profiler with tenant databases, enable some cloud secure features so that the cloud servers can list files in active transaction log directories, create trace files, and so on.

Procedure

Run the AlterCloud task and set the secure_feature_list with the following properties:
all,-sp_delete_directory,-sp_create_directory,-create_trace_file,-sp_list_directory,-read_file,-write_file

All the properties must be specified on a single line.

Next Steps

Run the SQL Anywhere Profiler on your tenant databases. Refer to your SQL Anywhere documentation for details.