现在的位置: 首页 > 综合 > 正文

performance monitor没有SQL Server性能计数器

2012年09月27日 ⁄ 综合 ⁄ 共 588字 ⁄ 字号 评论关闭

Windows Server 2008 R2 En Enterprise 64bit
SQL Server 2008 R2 En Enterprise 64bit

症状:在performance monitor中看不到Sql Server相关的性能计数器

解决办法:

Rebuilding the counters:
cd c:\windows\system32
lodctr /R
cd c:\windows\sysWOW64
lodctr /R

Resyncing the counters with Windows Management Instrumentation (WMI):
WINMGMT.EXE /RESYNCPERF

Stop and restart the Performance Logs and Alerts service.
Stop and restart the Windows Management Instrumentation service.

This will rebuild all performance counters including extensible and third-party counters.

refer:
http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2012/02/21/i-see-no-sql-server-2008-counters-in-perfmon/

抱歉!评论已关闭.