有台機器不定期出現以下錯誤:

  • Source: SideBySide
    Event ID: 59

    Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error message: Access is denied.
  • Source: SidebySide
    EventID: 59

    Generate Activation Context failed for D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is denied.

查詢了一下,很幸運地找到一篇相同的問題,並且有Microsoft Online Community Support的回答。

依據文中的說法,問題出在Performance Log Users群組對
\Program Files\Microsoft SQL Server\MSSQL.1\mssql\binn
\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin

兩個目錄沒有讀取權限。檢查的結果,MSSQL.1\mssql\binn權限OK,但MSSQL.2\OLAP\bin的確沒有授予權限給Performance Log Users群組。

另外,在同一台機器上我還發現了一大堆Performance Counter Error Event: (有些可能與前面的權限問題有關,有些看起來又不像)

  • Source: Perflib
    Event ID: 1008

    The Open Procedure for service "ContentFilter" in DLL "C:\WINDOWS\System32\query.dll" failed. Performance data for this service will not be available. The Status code returned is the first DWORD in the attached data.
  • Source: Perflib
    Event ID: 1005

    Windows cannot access the file 푸ǖ for one of the following reasons: there is a problem with the network connection, the disk that the file is stored on, or the storage drivers installed on this computer; or the disk is missing. Windows closed the program C:\WINDOWS\system32\sqlctr90.dll because of this error.
    Program: C:\WINDOWS\system32\sqlctr90.dll
    File: 푸ǖ
    The error value is listed in the Additional Data section...(後略)
  • Source: Perflib
    Event ID: 1018

    Performance counter data collection from the "MSSQL$MICROSOFT##SSEE" service has been disabled for this session due to one or more errors generated by the performance counter library for that service. The error(s) that forced this action have been written to the application event log.
  • Source: Perflib
    Event ID: 1023

    Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first DWORD in data section is the Windows error code.

Performance Counter的Error問題還挺常見的,今天找到Windows 2000 Resource Kit裡有個exctrlst.exe工具可以列出及停用某些損壞的Performance Counter,只要眼不見為淨,不失為一個良好的鋸箭法。

【下載】Extensible Performance Counter List(exctrlst.exe)
http://www.microsoft.com/downloads/details.aspx?familyid=7ff99683-b7ec-4da6-92ab-793193604ba4&displaylang=en


Comments

# by wild

出现这种问题真是郁闷,出现频率非常高,严重影响服务器性能,真是叫天天不应,找了好久好久终于看到这个贴,问题搞定,谢谢!

Post a comment