Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.8 - Installation Guide

Push Statistics to Central Repository

There are two options for replicating statistics to the central repository. The first option replicates the LiteSpeed activity. The second option only replicates job status, maintenance plans and log shipping information.

If you did not select to populate the central repository automatically or via a scheduled job during Instance Configuration, you can manually force a replication at any time by calling the ActivityManager.exe file from the command line or using the extended stored procedures.

NOTE: The xp_replicate_activity_statistics command is designed for sync changes between the local and central repositories. LiteSpeed does not contain information about the native backup history because it is a SQL Server native tool. You must use the [LiteSpeedLocal]..[LiteSpeed_ImportNativeHistory] procedure to import the native backup history first into the local repository.

To replicate database and LiteSpeed activity information

On the local repository server, do one of the following:

  • Execute dbo.xp_replicate_activity_statistics against the master database.
  • From the command line, change the directory until you are in the directory containing the LiteSpeed command-line utilities (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine) and run ActivityManager.exe.

To replicate job, maintenance plans and log shipping information

On the local repository server, do one of the following:

  • Execute dbo.xp_replicate_job_statistics against the master database.
  • From the command line, change the directory until you are in the directory containing the LiteSpeed command-line utilities (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine) and run ActivityManager.exe -GatherJobStats.

 

Related Topics

Related Documents