Article ID: 955632 - Last Review: March 19, 2009 - Revision: 2.0

The SSIS performance counter is no longer available in the Performance Monitor after you upgrade to Windows Server 2008

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

SYMPTOMS

After you upgrade a server from Windows Server 2003 to Windows Server 2008, the SQL Server 2008 Integration Services (SSIS) performance counter is no longer available in the Performance Monitor.
Back to the top

RESOLUTION

To resolve this problem, restore the SSIS performance counter, and then manually repair SQL Server 2008.

To restore the SSIS performance counter, repair the Microsoft SQL Server 2008 installation. To do this, follow these steps:
  1. Use the SQL Server 2008 installation media to start the SQL Server Setup program. After the Setup program verifies the prerequisites and the system, the Setup program displays the SQL Server Installation Center page.
  2. In the navigation pane, click Maintenance, and then click Repair.
To manually repair SQL Server 2008, follow these steps:
  1. At a command prompt, type CD %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Release, and then press ENTER.
  2. Type setup.exe /ACTION=/proxy/https/web.archive.org/web/20111112202346/http:/support.microsoft.com:80/kb/repair%3C/span>, and then press ENTER.
Back to the top

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Back to the top
APPLIES TO
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
Back to the top
Keywords: 
sql2008relnoteintegrationservices sql2008relnote kbinstallation kbexpertiseinter kbtshoot kbbug KB955632
Back to the top