sql server 2014 -missing performance monitor counter

All replies

• 

  

  0

  Sign in to vote

  Hello parul,

  Where are you looking for the Performance Counter? In a DMV or Windows PerfMon or ....?

  ---

  Olaf Helper

  [ Blog] [ Xing] [ MVP]

  Tuesday, May 27, 2014 6:07 AM
• 

  

  0

  Sign in to vote

  I need this counter from wherever possible (i guess value will be same only ) .Currently i am accessing from windows performance monitor .

  ---

  parul

  
  
  

  • Edited by Singla19 Tuesday, May 27, 2014 9:11 AM

  Tuesday, May 27, 2014 6:50 AM
• 

  

  0

  Sign in to vote

  Hi Parul,

  I ran into the same issue and solved it as follows:

  1. Locate the file sqlctr.ini
  (e.g. C:\Program Files\Microsoft SQL Server\MSSQL12.SQL_2014\MSSQL\Binn>)

  2. load the counter new by using the following command:
  lodctr sqlctr.ini

  3. Restart Microsoft SQL Server

  Perfect described here: http://blogs.technet.com/b/pfelatam/archive/2011/08/08/sql-performance-counters-are-missing.aspx

  ---

  MCM - SQL Server 2008
  MCSE - SQL Server 2012
  db Berater GmbH
  SQL Server Blog (german only)

  
  

  • Edited by Uwe RickenMVP Tuesday, May 27, 2014 10:56 AM
  • Proposed as answer by Shanky_621MVP Tuesday, May 27, 2014 11:02 AM
  • Marked as answer by tracycai Friday, May 30, 2014 7:30 AM

  Tuesday, May 27, 2014 10:54 AM
• 

  

  0

  Sign in to vote

  Hi Shanky ,

  Thanks a lot .it worked for me.

  One thing ,for me Restarting Microsoft SQL Server was not enough ,it needs to restart the machine itself sometimes.

  then i got the missing counters back . :)

  ---

  parul

  Friday, May 30, 2014 7:39 AM
• 

  

  0

  Sign in to vote

  Hello Everyone!

  I'm having a similar issue. I've followed the steeps listed above and have read nearly every article on this issue and can't seem to resolve it. I'm running SQL Sever 2014 (Build 12.0.4100.1) on Sever 2012R2. Any help or guidance would be appreciated. Thanks!

  Monday, June 8, 2015 7:23 PM
• 

  

  0

  Sign in to vote

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3f9709a9-fa0a-4d77-8e7c-ed2580ba2d14/performance-counters-not-installed-sql-server-2014-x64-standard?forum=sqltools

  The issue with performance counters for SQL Server 2014 has been resolved with the installation of CU2 for SQL Server 2014. Thx for the help.

  ---

  Marcelo at Esri

  Wednesday, June 17, 2015 10:07 PM