Replication data is not written in the Spotlight Statistic Repository (4284141)

Despite setting the collection schedule, replication data are not showing up in the Spotlight Statistic Repository.  There isn’t any data in the spotlight_perfdata table for any of the statistic_classes of the type replication.

1. Go to \Diagnostic Server\Agent\conf\Package\replication\2005\Agents.sql

2. Look for "{{DistributorDB.Name}}"

3. Change from "use [{{DistributorDB.Name}}]" to "use [distribution]"

STATUS:

Issue fixed in version 11.7.0. The latest version of Spotlight on SQL Server Enterprise can be downloaded at Support Link.