How does Security Manager use the MSDTC log file?
How do I change the size of the MSDTC log file?
Security Manager 3.X
Security Manager 4.X
The msdtc.log file is used by the Security Manager Database and Data Access Server (DAS) computers as part of the data collection process. This log file is generated by the Microsoft Distributed Transaction Coordinator service, and is used to ensure successful data-gathering operations in coordination with Microsoft SQL Server.
As part of the Security Manager software requirements, NetIQ recommends increasing the size of the msdtc.log file on both the Database computer and on any DAS computers to 512 MB. It is also recommended that the MSDTC log be placed on a different storage device from the Security Manager database files.
The DAS server writes to the OnePoint database using two-phase commit processes. If the input and output (I/O) load is high on the DAS server(s), then the I/O load will also be high on the database computer. Because of this, the MSDTC log needs to be sized accordingly to ensure that data is successfully collected during times of high activity.
To adjust the size of the MSDTC.log perform the following steps:
For Windows NT machines: Note: ensure that the DAC.exe component is installed. This is available in the NT4 Option Pack:
- Ensure you have more than 512 MB available on the hard drive.
- Stop the MSDTC service.
- Using the NT Option Pack Transaction Server Explorer, navigate to the MSDTC Log File Size screen.
- Adjust the slider bar to 512 MB.
- Press the RESETLog button. This step has to be taken for the resizing process to occur.
- Click OK.
- Restart the MSDTC service.
For Windows 2000 machines:
- Navigate to Start | Run and type mmc.exe . The Microsoft Management Console (MMC) window appears.
- Select Console | Add/Remove Snap-in....
- On the 'Standalone' tab, click the Add button.
- From the list of snap-ins, select Component Services, click the Add button, and then click Close.
- Click OK. The Component Services snap-in should appear in the MMC.
- Navigate to Component Services | Computers | MyComputer.
- Right-click on My Computer and select Properties.
- Click on the 'MSDTC' tab.
- Click on the Stop button to stop the Distributed Transaction Coordinator service.
- In the field labeled Capacity, change the value to 512.
- Click the Reset log button. The DTC Console Message window appears with an informational message.
- Click Yes to reset the log file.
- Click the Start button to restart the Distributed Transaction Coordinator service.
NOTE: Do not delete an existing MSDTC log prior to resizing it! This results in a corrupted MSDTC service and usually requires reinstallation of the operating system.
Please refer to the following Microsoft Knowledge Base article for information about reinstalling the MSDTC service in the event that it becomes unusable: