You can move the physical-log file to try to improve performance. When the database server initializes disk space, it places the disk pages allocated for the logical log and the physical log in the root dbspace. You might improve performance by moving the physical log, the logical-log files, or both to other dbspaces.
For advice on where to place the physical log, see Location of the Physical Log. For advice on sizing the physical log, seeSize and Location of the Physical Log. To obtain information about the physical log, see Monitoring Physical and Logical Logging Activity.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]