Counters: Low % Disk Idle on SQL Server High Avg. Disk Queue Length on SQL Server
Area of Analysis:
- Check whether the tracking database and Message box are on the same disks.
- Check whether the data and log files are on the same disks.
- Check the log sizes.
Possible Solutions:
- Use a SAN.
- Ensure that the tracking and Message-box databases are on different servers.
- If they are on the same server, ensure that they are on different disks.
- Ensure that the data and log files are not sharing the same disks.
Make sure the BizTalk agents are enabled on the server. The agents copy tracking data from the Message box to the tracking database. They also back up the databases and clean up the logs.
