Event Type: ErrorThis happens during the installation of SQL Server on a x64 server. SQL Server Setup sets the registry entry for the x64 SQL Server:SSIS Pipeline performance object to the wrong location. Thus the perfomance counter cannot be found.
Event Source: Health Service Modules
Event Category: None
Event ID: 10102
Date: xx-x-xxxx
Time: xx:xx:xx
User: N/A
Computer: xxxx
Description:
In PerfDataSource, could not resolve counter SQLServer:SSIS Pipeline, Rows written, . Module will be unloaded.
One or more workflows were affected by this.
Workflow name: Microsoft.SQLServer.2005.SQLServer_SSIS_Pipeline_Rows_Written_15.0_minutes_2_Rule
Instance name: MsDtsServer
Instance ID: {8CF3D89A-4393-20C5-1178-6715DD04AA4F}
Management group: xxxxxxx
The solution is simple:
Open a cmd-prompt on the SQL-server and type these commands, each followed by an
cd DriveLetter:\Program Files\Microsoft SQL Server\90\DTS\Binn
unlodctr dtspipeline
lodctr dtsperf.ini
This should solve the problem. There is a KB article about this issue: KB941154
Sometimes step 2 in this KB article is needed as well (editing the registry). There is an easy way to check whether the mentioned steps have helped: Start Perfmon and check whether the counter 'SQL Server:SSIS Pipeline'
No comments:
Post a Comment