FIX: "Performance Monitor Shared Memory Setup Failed: -1" Error Message When You Start SQL Server
Symptoms
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 waiting page.
Resolution
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:
Http://support.microsoft.com/default.aspx?scid=fh;n-us;cntactms
