博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

performance monitor没有SQL Server性能计数器

Posted on 2012-08-13 14:52  nzperfect  阅读(1181)  评论(0编辑  收藏  举报

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/