6.1 Design and Planning

The following are key considerations when planning your Sybase implementation:

6.1.1 Database Size and File Locations

SQL Anywhere uses four types of files: the database file, the transaction log file, the transaction log mirror, and the temporary file. These files should exist on separate drives. ZENworks recommends 10 GB of hard disk space for every 1,000 devices. A minimum 4GB RAM is recommended for the external Sybase server or the machine that hosts Sybase.

Database file organization significantly impacts the performance of the database. Database performance can be improved when database files are placed in separate drives that are attached to different I/O controllers. It is recommended that you put temporary files on the fastest device, physically separate from the one that holds the actual database file.The following link provides more details about the minimum hardware requirements for SQLAnywhere 12.0.1: Sybase Database Hardware Requirements

The following link provides more details about the SQLAnywhere 12.0.1 size and number limitations: Sybase ASA Limitations

6.1.2 Saving the ZENworks Database Password

When you create a new ZENworks zone, a database password is generated and subsequently used by each Primary Server. To back up the ZENworks database password, run the zman dgc command and save the retrieved password in a secure location.