LiteSpeed for SQL Server 8.9.1 - Security and Compliance Guide

Log Reader - SQL Server Clusters Support

The Log Reader partially supports monitoring of SQL Server clusters.

If a fail-over occurs, SQL Server continues to write data to the same log which is shared between the nodes in the cluster. However, the Log Reader installs server components to a local directory which is not shared. To read the log for a cluster, you must install the Log Reader server components on all computers where the cluster nodes reside.

To install the Log Reader Server Components on a cluster

1. Install the Log Reader server components on the active node of a cluster from the console. For more information, see Install Log Reader Server Components.
2. Copy one of the following files from the Log Reader Toad Log Reader plug-in installation directory (usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server\Toad for SQL Server x.x\Plugins\SqlServer\LogReader) on the computer where the console is installed to the SQL Server Binn directory (usually, C:\Program Files\Microsoft SQL Server\MSSQL\Binn) on the computer where the passive node of the cluster resides:
   • For 32-bit platforms, copy the xp_DellLogReader.dll file.
   • For Itanium 64-bit platforms, copy the xp_DellLogReader_ia64.dll file.
   • For 64-bit platforms other than Itanium, copy the xp_DellLogReader_x64.dll file.
3. In the Binn directory on the computer where the passive node of the cluster resides, rename the copied dll to xp_DellLogReader.dll.

Related Topics

Analyze Transaction Logs

Read Transaction Logs