1.0

Table Of Contents
Monitor performance
and usage
Use the Data Director user interface to monitor tasks and events. See
Chapter 11, “Monitoring the Data Director Environment,” on page 89.
Stop and restart the
database
Stop and restart, for example, to perform maintenance tasks.
Decommission the
database
Disable and then delete databases. Free up the resources when they are no
longer needed.
Every database requires a database owner account that can perform all schema management operations. This
account is specific to the database and cannot log in to Data Director. You can add database owner accounts
after database creation. Data Director users must log in with their database-specific credentials to view the
database, its entities, and its data or to perform database management tasks.
Database administrators and application developers can manage databases only if they have appropriate
permissions and roles granted to them by the organization administrator. The permissions and roles must be
granted on the database group or on the database, and apply only within the organization in which they are
granted.
Requirements for Creating Databases
You must have certain permissions to create databases, and you must calculate the storage needed for database
and related data.
Permissions Required for Creating Databases
To create databases, you need Create Databases permission on the database group that will contain the
database and Use Template permission on at least one database configuration template.
It is useful to have the following permissions on the database group and on the database.
n
Create snapshots.
n
Create external backups.
n
Delete snapshots and manage their retention time.
n
Clone the database.
n
Recover the database from a backup or snapshot.
The organization administrator can create a role with these permissions and assign users in the organization
to the role.
Calculating Database Storage Allocation
During the database creation process, you specify database storage allocation, point-in-time recovery storage
allocation, and the database group for the database. The database group provides the CPU, memory, storage,
and network resources required to run the database. The storage and point-in-time recovery allocations specify
how much of the database group's resources to use for this database.
When you calculate the amount of storage to allocate to the database, proceed as follows.
n
Estimate how much data will be stored in the database.
n
Consider the number of users and average expected number of transactions in a particular time period
and include room for growth.
n
If you plan to enable point-in-time recovery, calculate additional storage to accommodate the point-in-
time recovery write-ahead logs (WALs). The size of the allocation depends on the expected volume of
transactions on the database.
VMware vFabric Data Director Administrator and User Guide
52 VMware, Inc.