System information

Figure 162. Microsoft SQL Enterprise Manager - Server Configuration, Security Options
Next, you have to create a new database. For better performance it should
be created on a separate device. A device is a part of the disk reserved for
use by databases. Within this space multiple databases can be placed. For
each database, you must allocate a place to store the data log itself and a
place to store log entires. In our case the data and logs will be put into
same device.
Before you create a device or a database, you should calculate the amount
of space you will need. The size of the database depends on how many
clients you intend to manage and how much data you are storing into the
database.
As a rule of thumb, every client with hardware and software inventory data
stored to a database will use approximately 50 KB of data space and 8 KB of
log space.
If you intend to export data from the System Monitor, the amount of space
per client can easily multiply. Do not define the device too small. Devices
can be expanded or reseized if necessary but it is best to define the
databases large enough to start with. Make sure you also leave room for
expansion.
8. To create the database, highlight the server in the tree and choose Manage
from the top menu. Then select Databases... and the Manage Databases
window appears.
Chapter 5. TME 10 NetFinity Database Support 133