locked
w3wp.exe use 100% CPU RRS feed

  • Question

  • Hi:

    I have a site with Classic ASP + ADO (SQL Server 2003). I get a report(Debug Diagnostic) about the process/threads with high consumptions CPU.

    I found two threads always appear,

    How I found the root problem?

    This is report:

    Thread 20 - System ID 5920

    Entry point   msvcrt!_endthreadex+2f
    Create time   3/4/2009 7:44:40 AM
    Time spent in user mode   0 Days 00:23:47.968
    Time spent in kernel mode   0 Days 01:14:14.390


    This thread is making a database operation using ADO.

    The call to MSADO15!CERRORLOOKUP::GETERRORDESCRIPTION originated from oledb32!CImpIErrorInfo::GetSource+9f

    Function   Source
    ntdll!KiFastSystemCallRet   
    ntdll!NtQueryDefaultUILanguage+c   
    ntdll!GetUILangID+2d   
    ntdll!LdrpSearchResourceSection_U+186   
    ntdll!LdrFindResource_U+18   
    kernel32!FindResourceExW+65   
    user32!LoadStringOrError+31   
    user32!LoadStringW+18   
    msado15!FetchInfo+ba   
    msado15!CErrorLookup::GetErrorDescription+20   
    oledb32!CImpIErrorInfo::GetSource+9f   
    msado15!CContext::FailedInvoke+9f   
    msado15!CFieldsDispatch::Invoke+27b   
    vbscript!IDispatchInvoke2+b2   
    vbscript!IDispatchInvoke+59   
    vbscript!InvokeDispatch+13a   
    vbscript!InvokeByName+42   
    vbscript!CScriptRuntime::RunNoEH+22b2   
    vbscript!CScriptRuntime::Run+62   
    vbscript!CScriptEntryPoint::Call+51   
    vbscript!CSession::Execute+b4   
    vbscript!COleScript::ExecutePendingScripts+144   
    vbscript!COleScript::SetScriptState+14d   
    asp!CActiveScriptEngine::TryCall+19   
    asp!CActiveScriptEngine::Call+31   
    asp!CallScriptFunctionOfEngine+5b   
    asp!ExecuteRequest+17e   
    asp!Execute+24c   
    asp!CHitObj::ViperAsyncCallback+3f0   
    asp!CViperAsyncRequest::OnCall+92   
    comsvcs!CSTAActivityWork::STAActivityWorkHelper+32   
    ole32!EnterForCallback+c4   
    ole32!SwitchForCallback+1a3   
    ole32!PerformCallback+54   
    ole32!CObjectContext::InternalContextCallback+159   
    ole32!CObjectContext::DoCallback+1c   
    comsvcs!CSTAActivityWork::DoWork+12d   
    comsvcs!CSTAThread::DoWork+18   
    comsvcs!CSTAThread::ProcessQueueWork+37   
    comsvcs!CSTAThread::WorkerLoop+190   
    msvcrt!_endthreadex+a3   
    kernel32!BaseThreadStart+34

    Thread 51 - System ID 4764

    Entry point   msvcrt!_endthreadex+2f
    Create time   3/4/2009 10:10:29 AM
    Time spent in user mode   0 Days 00:00:22.812
    Time spent in kernel mode   0 Days 00:00:44.937


    This thread is making a database operation using ADO.

    The call to MSADO15!CERRORLOOKUP::GETHELPINFO originated from oledb32!CImpIErrorInfo::GetHelpContext+98

    Function   Source
    ntdll!KiFastSystemCallRet   
    ntdll!NtQueryDefaultUILanguage+c   
    ntdll!GetUILangID+2d   
    ntdll!LdrAlternateResourcesEnabled+5   
    ntdll!LdrLoadAlternateResourceModule+5a   
    ntdll!LdrpSearchResourceSection_U+200   
    ntdll!LdrFindResource_U+18   
    kernel32!FindResourceExW+65   
    user32!LoadStringOrError+31   
    user32!LoadStringW+18   
    msado15!FetchInfo+ba   
    msado15!CErrorLookup::GetHelpInfo+1e   
    oledb32!CImpIErrorInfo::GetHelpContext+98   
    msado15!CContext::FailedInvoke+92   
    msado15!CRecordset::Invoke+832   
    vbscript!IDispatchInvoke2+b2   
    vbscript!IDispatchInvoke+59   
    vbscript!InvokeDispatch+13a   
    vbscript!InvokeByName+42   
    vbscript!CScriptRuntime::RunNoEH+234c   
    vbscript!CScriptRuntime::Run+62   
    vbscript!CScriptEntryPoint::Call+51   
    vbscript!CSession::Execute+b4   
    vbscript!COleScript::ExecutePendingScripts+144   
    vbscript!COleScript::SetScriptState+14d   
    asp!CActiveScriptEngine::TryCall+19   
    asp!CActiveScriptEngine::Call+31   
    asp!CallScriptFunctionOfEngine+5b   
    asp!ExecuteRequest+17e   
    asp!Execute+24c   
    asp!CHitObj::ViperAsyncCallback+3f0   
    asp!CViperAsyncRequest::OnCall+92   
    comsvcs!CSTAActivityWork::STAActivityWorkHelper+32   
    ole32!EnterForCallback+c4   
    ole32!SwitchForCallback+1a3   
    ole32!PerformCallback+54   
    ole32!CObjectContext::InternalContextCallback+159   
    ole32!CObjectContext::DoCallback+1c   
    comsvcs!CSTAActivityWork::DoWork+12d   
    comsvcs!CSTAThread::DoWork+18   
    comsvcs!CSTAThread::ProcessQueueWork+37   
    comsvcs!CSTAThread::WorkerLoop+190   
    msvcrt!_endthreadex+a3   
    kernel32!BaseThreadStart+34

    • Moved by Darren GosbellMVP Thursday, March 5, 2009 1:37 AM This is not a SQL Server Analysis Services related question (Moved from SQL Server Analysis Services to Off-Topic Posts (Do Not Post Here))
    Thursday, March 5, 2009 12:16 AM

Answers