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
- 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.
- 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.
- 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
