Error in log - "Performance monitor shared memory setup failed: -1"

• Rob-188054

  SSC-Addicted

  Points: 416

  More actions

  January 3, 2006 at 11:21 am

  #113061

  Hi All,

  Just wondering if you can help me tackle a problem affecting 3 servers (1 development box, 2 production servers)

  The symptoms are:

  1) an error in the SQL Server error log saying "Performance monitor shared memory setup failed: -1"

  2) master..sysperfinfo is empty

  The environment:

  - The development box run on Windows 2000

  - The production boxes run on Win 2003

  - SQL Server 2000 with SP4

  My internet research has pointed me to http://support.microsoft.com/default.aspx?scid=kb;en-us;812915

  - which gives a resolution of loading the lastest SP (sp4 was loaded in August).

  This started happening to these 3 servers in November, which could coincide with some Windows server patches that our domain admins were doing. However 10 SQL Servers were patched and rebooted, and this error only happens on 3 servers.

  Anyone have any ideas on how to fix this? The SQL Servers has been rebooted at least once since this error began.

  Thanks in advance,

  -Rob H

• Shawn Denogeon

  SSChasing Mays

  Points: 634

  More actions

  January 3, 2006 at 6:42 pm

  #612499

  Simply rebooting sometimes solves it.

  And, this is what I was looking for last week but didn't look far enough becAUSE I remembered unloadctr not unlodctr...:

  http://www.sql-server-performance.com/performance_monitor_tips.asp

  At the command prompt, type in the following: unlodctr.exe MSSQLServer

  Then type in the following: lodctr.exe \binn\sqlctr.ini

  Reboot the server

• Rob-188054

  SSC-Addicted

  Points: 416

  More actions

  January 5, 2006 at 4:27 pm

  #613072

  Hi Shawn,

  Thanks for your reply.

  I don't think the ulodctr/lodctr will work for this problem because nothing is getting into master..sysperfinfo. When I executed unlodctr on a test box (not experienceing this error), counters were still being updated in master..sysperfinfo, but the Performance Monitor just had the SQL Server measures missing.

  My problem is that master..sysperfinfo has no rows on the affected servers.

  I will try another reboot when I can... even the development server is being used heavily right now. I'm not convinced this will be a definate solution because I've rebooted it since the problem began.

  Thanks,

  -Rob

• berto

  SSCommitted

  Points: 1878

  More actions

  December 2, 2007 at 5:18 am

  #756278

  I have similar issue. I moved server from one domain to another one and on one node (this is cluster) after SQL Service starts I have following error in SQL Server Error log:

  Performance monitor shared memory setup failed: -1

  This error only appears on node A not on node B.

  I found following article: http://support.microsoft.com/kb/812915/en-us

  But they claim that it's solved in SP4 which is applied on my SQL Cluster.

  Any ideas?

  MCP ID# 1115468 Ceritified Since 1998
  MCP, MCSE, MCP+I, MCSE+I, MCSA,
  MCDBA SQL7.0 SQL 2000, MCTS SQL 2005