Page History
Table of Contents | ||||
---|---|---|---|---|
|
This section helps you configure the SQL Server-based PMDB after you install Precise. This is not a replacement of the content within Installation and Administration. The configuration recommendations help you to fine-tune the PMDB, which then results in faster and more efficient performance.
...
Table 1 Additional DBA settings
Setting | Description | Value |
---|---|---|
Size of the datafile | The default size when you create the PMDB. | 2GB |
Size of the log file | The default size when you create the PMDB. | 500MB |
Auto extent size for datafiles and logs | The size of the new segment to be allocated. | 30% of the initial datafile For example, if the datafile is initially 1GB, the auto extent size should be 300MB. If you have a very large installation, the auto extent size should be 1GB. |
Tempdb location | Put the tempdb database on a fast I/O system. |