Select the product you need help with
You cannot use WMI to collect SQL performance counters for all the instances of SQL Server 2000 on a computer that is running Windows Server 2003Article ID: 888990 - View products that this article applies to. On This PageSYMPTOMSIf multiple instances of Microsoft SQL Server 2000 are
running on a single computer that is running Microsoft Windows Server 2003, you
cannot use Windows Management Instrumentation (WMI) to collect SQL performance
counters for all the instances. CAUSEThis problem occurs because WMI does not correctly behave
when a service uses the Linkage registry subkey to list data
for multiple instances.RESOLUTIONWindows Server 2003Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft Windows Server 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:889100
(http://support.microsoft.com/kb/889100/
)
How to obtain the latest service pack for Windows Server 2003
Hotfix informationA supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix. Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: http://support.microsoft.com/contactus/?ws=support Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
(http://support.microsoft.com/contactus/?ws=support)
PrerequisitesNo prerequisites are required.Restart requirementYou do not have to restart the computer after you apply this hotfix.Hotfix replacement informationThis hotfix does not replace any other hotfixes.File informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.Windows Server 2003, 32-bit versions Date Time Version Size File name -------------------------------------------------------------- 16-Nov-2004 22:46 5.2.3790.233 41,472 Wbemperf.dll Date Time Version Size File name Platform -------------------------------------------------------------- 16-Nov-2004 06:51 5.2.3790.233 108,032 Wbemperf.dll IA-64 16-Nov-2004 06:46 5.2.3790.233 41,472 Wwbemperf.dll x86 Windows XPA supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix. Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: http://support.microsoft.com/contactus/?ws=support Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
(http://support.microsoft.com/contactus/?ws=support)
PrerequisitesYou must have Windows XP Service Pack 2 installed to apply this hotfix.Restart requirementYou do not have to restart the computer after you apply this hotfix.Hotfix replacement informationThis hotfix does not replace any other hotfixes.File informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.Collapse this table
STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section. This problem was corrected in Windows Server 2003
Service Pack 1.
MORE INFORMATIONPrograms that manage multiple devices and performance data
for each device must add a Linkage registry subkey to the
Services registry
subkey. The Linkage
registry key must contain an Export entry. The value of this entry is a list of
the device names.For example, a system with two Etherlink cards might use the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Elnkii\Linkage "\Device\Elnk01" "\Device\Elnk02" REFERENCES For
more information about the terminology that is used in this article, click the
following article number to view the article in the Microsoft Knowledge Base: 824684
(http://support.microsoft.com/kb/824684/
)
Description of the standard terminology that is used to describe Microsoft software updatesPropertiesArticle ID: 888990 - Last Review: October 9, 2011 - Revision: 4.0 APPLIES TO
|
Back to the top
