This article provides some considerations for distributing MDB tables across multiple disks. This article applies to SQL Server.
The following actions may help with the performance of the MDB on SQL Server for the CA Service Desk Manager application:
Keep in mind that CA Service Desk Manager operations and functionality are based on objects. It may be necessary to understand the mapping of tables to objects. In an out-of-the box Service Desk, the act_log and evt_log tables are written to frequently.
To achieve the highest level of performance, the frequency, urgency, and importance of each operation within CA Service Desk Manger in relation to the needs of your business may need to be well understood. Measurements, projections, and adaptations may be necessary. Despite conclusions made after experimentation, there may be situation in which the results are not as expected..
Additionally, you may want to review the article titled "Configuring Database Files for Optimal Performance" which currently exists, at the time of this writing, at the following link: