"Performance Monitor Shared Memory Setup Failed: -1"

原创 2004年06月22日 19:10:00

FIX: "Performance Monitor Shared Memory Setup Failed: -1" Error Message When You Start SQL Server


When you run System Monitor from the Performance console on a computer that is running SQL Server with Service Pack 3 (SP3) and you restart SQL Server without closing the Performance console, the following message is logged in the SQL Server error log:

Performance monitor shared memory setup failed: -1
You may notice that SQL Server-related objects do not appear in the Performance object list.

Additionally, if you query the sysprocesses table in the master database, the value of the waittype column and the waittime column is always zero for all system process IDs (SPIDs). The value of the waittype column and the waittime column may remain at zero, even if you query the sysprocesses table several times.


A supported fix is now available from Microsoft, but it is only intended to correct the problem described in this article. Only apply it to systems that are experiencing this specific problem. This fix may receive additional testing to further ensure product quality. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next SQL Server 2000 service pack that contains this fix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:


Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

Note Turn off the monitor programs that are running on your computer and restart the SQL Server service before you install this hotfix. The monitor programs may cause a shared memory segment that was created before the installation of the hotfix to be left open with the corresponding Access Control Lists (ACL), even after you install the hotfix on your computer.

chrome64新增的Performance Monitor

chrome64中新增了一个可以多角度实时查看页面性能的开发者工具,可以这么打开: 用它检测一下国内的这几个主流的视频网站的首页 cpu usage的数据都是变来变去的,估计是因为...
  • zgrbsbf
  • zgrbsbf
  • 2017年11月30日 14:14
  • 163

c# - 使用Performance Monitor API 列出本机所有 Performance Counters

在Windows下, 使用Performance monitor取得性能信息(CPU, I/O, Memory, Process) 是首选.  使用Performance monitor API 可...
  • yuxuac
  • yuxuac
  • 2012年06月26日 23:01
  • 2046

ORA-27125: unable to create shared memory segment的解决方法(转)

ORA-27125: unable to create shared memory segment的解决方法(转)  # Kernel sysctl configuration file for Re...
  • li951383937
  • li951383937
  • 2016年10月18日 00:56
  • 1474

ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 1: Operation not permitted

  • sustwct
  • sustwct
  • 2014年04月17日 09:00
  • 2364

常用的 Performance / Monitor 工具

http://benjr.tw/532 雖然自己是從事 QA(Quality Assurance) 相關測試工作,但對於這些工具的使用還是有很多問號,下面列出 Linux 下我常用的效能(Per...
  • hshl1214
  • hshl1214
  • 2016年12月25日 00:27
  • 818

如何分析Performance Monitor (PerfMon) Log

  Windows 2003 和xp提供了性能监视器的几个命令行工具,他们是logman utility (logman.exe),relog utility (relog.exe) 和type...
  • shanyou
  • shanyou
  • 2008年06月17日 18:44
  • 1180

共享内存(Shared Memory)介绍

  • 2017年02月22日 14:17
  • 2625

Android Studio打开Android Device Monitor报错

一开始是报failed to load the jni shared library,一脸萌币,然后就各种找解决方法,没找到。不过隐约找到可能是Java的JDK版本问题,所以就把版本从1.8更新到1....
  • baostorm
  • baostorm
  • 2017年11月28日 19:16
  • 563

远程性能监视器(Remote Performance Monitor)

原文地址::http://hi.baidu.com/timematter/item/619a4f488152bce1bcf4513a 相关网帖 1.使用Wince 自带的远程工具-...
  • xqhrs232
  • xqhrs232
  • 2013年03月19日 17:52
  • 1623


1、日志简介 nginx日志主要有两种:访问日志和错误日志。访问日志主要记录客户端访问nginx的每一个请求,格式可以自定义;错误日志主要记录客户端访问nginx出错时的日志,格式不支持自定义。两种...
  • Flood_Dragon
  • Flood_Dragon
  • 2014年05月20日 11:59
  • 1306
您举报文章:"Performance Monitor Shared Memory Setup Failed: -1"