| By product |
| Other |
|
Knowledgebase Tips and How-to Articles for ApexSQL Tools How to improve ApexSQL Log performance over a network? Applies to ApexSQL Log Summary This article describes how to improve ApexSQL Log performance when the audited transaction log is located on a remote server Description If the transaction log audited by ApexSQL Log is located on a remote server, it’s possible to experience a noticeable increase in the time needed to retrieve the database log information. This decrease in performance can be noted particularly in scenarios where the remote server is accessed via a slow broadband or VPN connection or when the audited transaction log file is quite large. Usually, the biggest chunk of the time spent on auditing in these cases is wasted on waiting the remote server to respond. In some cases, that chunk can take up to 99% of the time spent on the entire process. However, the very low effective I/O speed due to network I/O bottlenecks can be mitigated by: 1. Improving network I/O 2. Moving the auditing process closer to the server that stores the transaction log sources and to the server that stores the database. If the transaction logs and the database aren’t stored on the same server, it’s better to have the auditing process running closer to the transaction log sources than the database, since reading the transaction log sources has the most impact on I/O 3. Moving the transaction log sources closer to the auditing process This can be achieved by auditing transaction log backups or detached transaction log files, instead of auditing the remote online transaction log files Last updated August 16, 2011 Labels: ApexSQL Log |
