IISState log (IIS slow)

Where could be problem in my IIS? Processing SQL is very slow sometimes.
Here is IISState log:
***********************
Starting new log output
IISState version 3.0

Tue Nov 02 15:52:20 2004

OS = Windows 2003 Server
Executable: w3wp.exe
PID = 304

Note: Thread times are formatted as HH:MM:SS.ms

***********************




Thread ID: 0
System Thread ID: bbc
Kernel Time: 0:0:0.15
User Time: 0:0:0.46
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\system32\ntdll.dll -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\system32\kernel32.dll -
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 0006fe58 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0006fecc 77e4168f ntdll!NtWaitForSingleObject+0xc
02 010012a0 72617453 kernel32!WaitForSingleObject+0xf
03 33576c55 00000000 0x72617453




Thread ID: 1
System Thread ID: 868
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 00a4ff9c 77f4262b SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 00a4ffb8 77e4a990 ntdll!NtDelayExecution+0xc
02 00a4ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 2
System Thread ID: c74
Kernel Time: 0:0:0.93
User Time: 0:0:0.140
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
c:\windows\system32\inetsrv\W3TP.dll -
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 00cfff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 00cfff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 00cfff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 00cfffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 3
System Thread ID: dc
Kernel Time: 0:0:0.62
User Time: 0:0:0.125
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 00d3ff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 00d3ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 00d3ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 00d3ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 4
System Thread ID: 6a8
Kernel Time: 0:0:0.140
User Time: 0:0:0.296
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 00d7ff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 00d7ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 00d7ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 00d7ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 5
System Thread ID: 7d0
Kernel Time: 0:0:0.46
User Time: 0:0:0.93
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 00dbff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 00dbff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 00dbff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 00dbffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 6
System Thread ID: 7fc
Kernel Time: 0:0:0.15
User Time: 0:0:0.0
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 00e7fcec 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 00e7ffb8 77e4a990 ntdll!ZwWaitForMultipleObjects+0xc
02 00e7ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 7
System Thread ID: a0
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 0174ff14 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0174ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
02 77f420c6 4affc033 kernel32!WaitForSingleObject+0xf
03 0424548b 00000000 0x4affc033




Thread ID: 8
System Thread ID: 7f8
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 017cff8c 77f4262b SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 017cffb8 77e4a990 ntdll!NtDelayExecution+0xc
02 017cffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 9
System Thread ID: f4
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 027aff14 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 027aff88 77e4168f ntdll!NtWaitForSingleObject+0xc
02 027affec 00000000 kernel32!WaitForSingleObject+0xf




Thread ID: 10
System Thread ID: 158
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\system32\USER32.dll -
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
\\?\C:\WINDOWS\system32\inetsrv\asp.dll -
Thread Status: Thread is in a WAIT state.
Thread Type: ASP
Executing Page: ASP.dll symbols not found. Unable to locate ASP page.
Continuing with other analysis.

# ChildEBP RetAddr
00 02aefe1c 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 02aefec8 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 02aeff24 77d077f5 USER32!GetLastInputInfo+0xe4
03 02aeff40 70a183cc USER32!MsgWaitForMultipleObjects+0x1d
04 70a36fa0 00000310 asp!AspStatusHtmlDump+0x305c


....



Thread ID: 23
System Thread ID: a78
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\system32\RPCRT4.dll -
Thread Type: Possible ASP page. Possible DCOM activity
Executing Page: ASP.dll symbols not found. Unable to locate ASP page.
Continuing with other analysis.

*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\system32\ole32.dll -
OLE32.dll Symbols not found. Unable to proceed with DCOM check.
Continuing other analysis.

# ChildEBP RetAddr
00 035dfe20 77f4313f SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 035dff8c 77c696a9 ntdll!NtReplyWaitReceivePortEx+0xc
02 035dffb0 77c696d7 RPCRT4!I_RpcBindingIsClientLocal+0x799
03 035dffec 00000000 RPCRT4!I_RpcBindingIsClientLocal+0x7c7




Thread ID: 24
System Thread ID: ae8
Kernel Time: 0:0:0.93
User Time: 0:0:0.250
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 03daff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 03daff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 03daff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 03daffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 25
System Thread ID: ebc
Kernel Time: 0:1:57.93
User Time: 0:0:37.562
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\system32\ODBC32.dll -
Thread Status: Thread is in a WAIT state.
Other information: Thread is waiting for a lock to be released. Looking for
lock owner.
Owning thread System ID: ffff
Thread Type: Other
# ChildEBP RetAddr
00 03f9ecd0 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 03f9ed10 77f42044 ntdll!NtWaitForSingleObject+0xc
02 03f9ee1c 77e42e83 ntdll!RtlEnterCriticalSection+0x44
03 03f9ee4c 017d7ccc kernel32!FreeLibrary+0x11
04 03f9ee90 017d8058 ODBC32!SQLDescribeColW+0x2cc
05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
06 0c733a1d 00000000 0x11ce2a1c




Thread ID: 26
System Thread ID: 740
Kernel Time: 0:3:0.500
User Time: 0:0:59.390
Thread Type: Other
# ChildEBP RetAddr
WARNING: Stack unwind information not available. Following frames may be
wrong.
00 040ecf34 77f487a4 ntdll!RtlImageDirectoryEntryToData+0x520
01 040ecf50 77f50cde ntdll!RtlImageDirectoryEntryToData+0x2c9
02 040ecf88 77f47684 ntdll!RtlReAllocateHeap+0x1623
03 040ed1b4 77f4f648 ntdll!RtlAllocateHeap+0x3a8
04 040ed388 1f9ce43e ntdll!RtlpEnsureBufferSize+0x4e9
05 040ed3a8 1f9d79f6 SQLSRV32!SQLParamOptions+0x308
06 040ed408 1f9d7855 SQLSRV32!SQLColAttributeW+0x12a5
07 040ed4a4 02020e7e SQLSRV32!SQLColAttributeW+0x1104
08 e7ffffff 00000000 0x2020e7e




Thread ID: 27
System Thread ID: 834
Kernel Time: 0:0:14.921
User Time: 0:0:10.0
Thread Status: Thread is in a WAIT state.
Thread Type: Idle ASP thread
# ChildEBP RetAddr
00 0414fdcc 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0414fe78 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 0414fed4 77d077f5 USER32!GetLastInputInfo+0xe4
03 0414fef0 75614e57 USER32!MsgWaitForMultipleObjects+0x1d
04 0414ff84 77bc91ed comsvcs!CoCreateActivity+0x4e1a
05 0414ffb8 77e4a990 msvcrt!endthreadex+0x95
06 0414ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 28
System Thread ID: ce0
Kernel Time: 0:1:8.906
User Time: 0:0:30.390
Thread Status: Thread is in a WAIT state.
Other information: Thread is waiting for a lock to be released. Looking for
lock owner.
Owning thread System ID: ffff
Thread Type: Other
# ChildEBP RetAddr
00 0420de98 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0420ded8 77f42044 ntdll!NtWaitForSingleObject+0xc
02 0420df74 77f52042 ntdll!RtlEnterCriticalSection+0x44
03 0420dfb4 1f9d43cc ntdll!LdrGetProcedureAddress+0x17
04 0420e4e8 1f9d43eb SQLSRV32!SQLSetEnvAttr+0x88c
05 0420e4f4 1f9d4092 SQLSRV32!SQLSetEnvAttr+0x8ab
06 032d807a 006c0063 SQLSRV32!SQLSetEnvAttr+0x552
07 006d0074 00000000 0x6c0063




Thread ID: 29
System Thread ID: 94c
Kernel Time: 0:0:42.859
User Time: 0:0:14.609
Thread Status: Thread is in a WAIT state.
Other information: Thread is waiting for a lock to be released. Looking for
lock owner.
Owning thread System ID: 0
Thread Type: Other
# ChildEBP RetAddr
00 043cf2f4 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 043cf334 77f42044 ntdll!NtWaitForSingleObject+0xc
02 043cf368 017d8058 ntdll!RtlEnterCriticalSection+0x44
03 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
04 0c733a1d 00000000 0x11ce2a1c




Thread ID: 30
System Thread ID: a34
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 0456ff70 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0456ffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
02 0456ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 31
System Thread ID: c4c
Kernel Time: 0:0:0.78
User Time: 0:0:0.375
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 03b3ff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 03b3ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 03b3ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 03b3ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 32
System Thread ID: cd0
Kernel Time: 0:0:0.140
User Time: 0:0:0.187
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 03bcff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 03bcff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 03bcff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 03bcffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 33
System Thread ID: f0
Kernel Time: 0:0:0.187
User Time: 0:0:0.265
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 03d2ff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 03d2ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 03d2ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 03d2ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 34
System Thread ID: 7bc
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 03d6ff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 03d6ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 03d6ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 03d6ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 35
System Thread ID: 8a4
Kernel Time: 0:0:0.62
User Time: 0:0:0.109
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 0486ff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0486ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 0486ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 0486ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 36
System Thread ID: d0
Kernel Time: 0:1:1.375
User Time: 0:0:18.296
Thread Type: Other
# ChildEBP RetAddr
00 049bd39c 77f42d1b SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 049bd438 77f60066 ntdll!NtQueryDefaultUILanguage+0xc
02 049bd4a4 77d0a2ff ntdll!LdrFindResource_U+0x17
03 049bd4c8 77d0a799 USER32!GetSysColorBrush+0x85
04 049bd4ec 1f9d52b2 USER32!LoadStringA+0x1a
05 049bdf64 1f9c399e SQLSRV32!SQLSetEnvAttr+0x1772
06 049bdffc 00000105 SQLSRV32!SQLSetConnectAttrW+0x13e2




Thread ID: 37
System Thread ID: 9d8
Kernel Time: 0:0:0.78
User Time: 0:0:0.156
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 04e3ff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 04e3ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 04e3ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 04e3ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 38
System Thread ID: 408
Kernel Time: 0:0:0.109
User Time: 0:0:0.250
Thread Type: HTTP Listener
# ChildEBP RetAddr
00 08aaff28 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 08aaff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
02 08aaff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
03 08aaffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c




Thread ID: 39
System Thread ID: 270
Kernel Time: 0:0:36.625
User Time: 0:0:12.125
Thread Status: Thread is in a WAIT state.
Other information: Thread is waiting for a lock to be released. Looking for
lock owner.
Owning thread System ID: ffff
Thread Type: Other
# ChildEBP RetAddr
00 08aed120 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 08aed160 77f42044 ntdll!NtWaitForSingleObject+0xc
02 08aed1fc 77f52042 ntdll!RtlEnterCriticalSection+0x44
03 08aed23c 1f9d52c6 ntdll!LdrGetProcedureAddress+0x17
04 08aedcac 1f9c399e SQLSRV32!SQLSetEnvAttr+0x1786
05 08aedd44 00000105 SQLSRV32!SQLSetConnectAttrW+0x13e2




Thread ID: 40
System Thread ID: 474
Kernel Time: 0:0:24.921
User Time: 0:0:14.156
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\Program Files\Common Files\System\ado\msado15.dll -
Thread Type: Other
# ChildEBP RetAddr
WARNING: Stack unwind information not available. Following frames may be
wrong.
00 08c2ee2c 02ce6ef8 msado15+0x1b7b
01 08c2ee68 02ce9946 msado15!DllGetClassObject+0x78
02 03ff3020 00000000 msado15!DllGetClassObject+0x2ac6




Thread ID: 41
System Thread ID: d30
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 090ffe54 77f4262b SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 090ffec0 77e416ee ntdll!NtDelayExecution+0xc
02 090fffb8 77e4a990 kernel32!Sleep+0xb
03 090fffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 42
System Thread ID: e24
Kernel Time: 0:0:0.156
User Time: 0:0:2.0
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 096aff10 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 096aff84 77e4168f ntdll!NtWaitForSingleObject+0xc
02 096affb8 77e4a990 kernel32!WaitForSingleObject+0xf
03 096affec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 43
System Thread ID: d84
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscorsvr.dll -
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 097ffe74 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 097fff20 77e4b0e4 ntdll!ZwWaitForMultipleObjects+0xc
02 097fffa0 7922d36a kernel32!WaitForMultipleObjects+0x17
03 097fffb8 77e4a990 mscorsvr!CoInitializeCor+0x90a7
04 097fffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 44
System Thread ID: 77c
Kernel Time: 0:0:0.0
User Time: 0:0:0.875
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 0984ff14 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0984ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
02 0984ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
03 0984ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 45
System Thread ID: d24
Kernel Time: 0:0:0.15
User Time: 0:0:0.500
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 0988ff14 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0988ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
02 0988ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
03 0988ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 46
System Thread ID: cc4
Kernel Time: 0:0:0.0
User Time: 0:0:0.546
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 0991ff14 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0991ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
02 0991ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
03 0991ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 47
System Thread ID: 43c
Kernel Time: 0:0:0.0
User Time: 0:0:0.781
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 09f5ff14 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 09f5ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
02 09f5ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
03 09f5ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 48
System Thread ID: f3c
Kernel Time: 0:0:0.0
User Time: 0:0:0.62
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 09f9fe90 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 09f9ff3c 77e4b0e4 ntdll!ZwWaitForMultipleObjects+0xc
02 09f9ff74 79201c3d kernel32!WaitForMultipleObjects+0x17
03 09f9ffb8 77e4a990 mscorsvr!GetMetaDataInternalInterface+0x15193
04 09f9ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 49
System Thread ID: df8
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
WARNING: Stack unwind information not available. Following frames may be
wrong.
00 0a0cffa4 791c066c ntdll!NtDelayExecution+0xc
01 0a0cffec 00000000 mscorsvr!Ordinal74+0x1066c




Thread ID: 50
System Thread ID: f8c
Kernel Time: 0:0:0.15
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 0b54ff14 77d06718 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0b54ff34 771b93ef USER32!DispatchMessageW+0x1f
02 0b54ff74 771b936d ole32!CoGetInterceptorFromTypeInfo+0x224a
03 0b54ff90 771b92b8 ole32!CoGetInterceptorFromTypeInfo+0x21c8
04 00000000 00000000 ole32!CoGetInterceptorFromTypeInfo+0x2113




Thread ID: 51
System Thread ID: fe0
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144cc f1df_1.0.100.0_x-ww_0D1F9F94\gdiplus.dll -
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 15c3fe48 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 15c3fef4 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 15c3ff50 77d077f5 USER32!GetLastInputInfo+0xe4
03 15c3ff6c 70cc1637 USER32!MsgWaitForMultipleObjects+0x1d
04 00000001 00000000 gdiplus+0x1637




Thread ID: 52
System Thread ID: 10f4
Kernel Time: 0:0:42.78
User Time: 0:0:11.875
Thread Status: Thread is in a WAIT state.
Other information: Thread is waiting for a lock to be released. Looking for
lock owner.
Owning thread System ID: ffff
Thread Type: SQL Query. Possible ASP page
Executing Page: ASP.dll symbols not found. Unable to locate ASP page.
Continuing with other analysis.

# ChildEBP RetAddr
00 0b14d310 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0b14d350 77f42044 ntdll!NtWaitForSingleObject+0xc
02 0b14d3ec 77f52042 ntdll!RtlEnterCriticalSection+0x44
03 0b14d42c 6d563747 ntdll!LdrGetProcedureAddress+0x17
04 0b14d448 6d56386a DBNETLIB!TermSSPIPackage+0x4f7
05 0b14d484 00000330 DBNETLIB!InitSSPIPackage+0xea



....




Thread ID: 69
System Thread ID: 161c
Kernel Time: 0:0:0.31
User Time: 0:0:0.46
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 0d7afca0 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 0d7afd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 0d7afda8 77d077f5 USER32!GetLastInputInfo+0xe4
03 0d7afdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
04 0d7afde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
05 0d7afef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
06 0d7aff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
07 0d7aff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
08 0d7affb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
09 0d7affec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 70
System Thread ID: 16f4
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 1497ff70 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 1497ffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
02 1497ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 71
System Thread ID: 1720
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 152fff70 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 152fffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
02 152fffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 72
System Thread ID: b2c
Kernel Time: 0:0:0.31
User Time: 0:0:0.78
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 160dfca0 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 160dfd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 160dfda8 77d077f5 USER32!GetLastInputInfo+0xe4
03 160dfdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
04 160dfde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
05 160dfef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
06 160dff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
07 160dff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
08 160dffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
09 160dffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 73
System Thread ID: c80
Kernel Time: 0:0:0.46
User Time: 0:0:0.125
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 1607fca0 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 1607fd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 1607fda8 77d077f5 USER32!GetLastInputInfo+0xe4
03 1607fdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
04 1607fde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
05 1607fef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
06 1607ff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
07 1607ff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
08 1607ffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
09 1607ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 74
System Thread ID: d18
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Type: Other
# ChildEBP RetAddr
00 1537ff70 77f430c7 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 1537ffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
02 1537ffec 00000000 kernel32!FlsSetValue+0x779




Thread ID: 75
System Thread ID: adc
Kernel Time: 0:0:0.109
User Time: 0:0:0.62
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 1700fca0 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 1700fd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 1700fda8 77d077f5 USER32!GetLastInputInfo+0xe4
03 1700fdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
04 1700fde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
05 1700fef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
06 1700ff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
07 1700ff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
08 1700ffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
09 1700ffec 00000000 kernel32!FlsSetValue+0x779

Thread ID: 76
System Thread ID: e74
Kernel Time: 0:0:0.78
User Time: 0:0:0.125
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 174dfca0 77f4372d SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 174dfd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
02 174dfda8 77d077f5 USER32!GetLastInputInfo+0xe4
03 174dfdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
04 174dfde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
05 174dfef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
06 174dff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
07 174dff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
08 174dffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
09 174dffec 00000000 kernel32!FlsSetValue+0x779

Thread ID: 77
System Thread ID: 210
Kernel Time: 0:0:0.0
User Time: 0:0:0.0
Thread Status: Thread is in a WAIT state.
Thread Type: Other
# ChildEBP RetAddr
00 1633ff10 77f43741 SharedUserData!SystemCallStub+0x4
WARNING: Stack unwind information not available. Following frames may be
wrong.
01 1633ff84 77e4168f ntdll!NtWaitForSingleObject+0xc
02 1633ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
03 1633ffec 00000000 kernel32!FlsSetValue+0x779

Re: IISState log (IIS slow)

IISState couldn't get to microsoft.com to get the symbols, so I can't tell
you much. But it does look like you are having a problem either in the
parsing of the query or processng the results. It doesn't look like there
is a problem w/the SQL server.

I would guess that you may have some query coming back that is huge (i.e.
Select * FROM myTableOfOneMillionRows ).

Pat

"Janis Buks" wrote in message
news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> Where could be problem in my IIS? Processing SQL is very slow sometimes.
> Here is IISState log:
> ***********************
> Starting new log output
> IISState version 3.0
>
> Tue Nov 02 15:52:20 2004
>
> OS = Windows 2003 Server
> Executable: w3wp.exe
> PID = 304
>
> Note: Thread times are formatted as HH:MM:SS.ms
>
> ***********************
>
>
>
>
> Thread ID: 0
> System Thread ID: bbc
> Kernel Time: 0:0:0.15
> User Time: 0:0:0.46
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\system32\ntdll.dll -
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\system32\kernel32.dll -
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0006fe58 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0006fecc 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 010012a0 72617453 kernel32!WaitForSingleObject+0xf
> 03 33576c55 00000000 0x72617453
>
>
>
>
> Thread ID: 1
> System Thread ID: 868
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 00a4ff9c 77f4262b SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 00a4ffb8 77e4a990 ntdll!NtDelayExecution+0xc
> 02 00a4ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 2
> System Thread ID: c74
> Kernel Time: 0:0:0.93
> User Time: 0:0:0.140
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> c:\windows\system32\inetsrv\W3TP.dll -
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 00cfff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 00cfff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 00cfff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 00cfffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 3
> System Thread ID: dc
> Kernel Time: 0:0:0.62
> User Time: 0:0:0.125
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 00d3ff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 00d3ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 00d3ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 00d3ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 4
> System Thread ID: 6a8
> Kernel Time: 0:0:0.140
> User Time: 0:0:0.296
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 00d7ff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 00d7ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 00d7ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 00d7ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 5
> System Thread ID: 7d0
> Kernel Time: 0:0:0.46
> User Time: 0:0:0.93
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 00dbff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 00dbff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 00dbff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 00dbffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 6
> System Thread ID: 7fc
> Kernel Time: 0:0:0.15
> User Time: 0:0:0.0
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 00e7fcec 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 00e7ffb8 77e4a990 ntdll!ZwWaitForMultipleObjects+0xc
> 02 00e7ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 7
> System Thread ID: a0
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0174ff14 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0174ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 77f420c6 4affc033 kernel32!WaitForSingleObject+0xf
> 03 0424548b 00000000 0x4affc033
>
>
>
>
> Thread ID: 8
> System Thread ID: 7f8
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 017cff8c 77f4262b SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 017cffb8 77e4a990 ntdll!NtDelayExecution+0xc
> 02 017cffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 9
> System Thread ID: f4
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 027aff14 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 027aff88 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 027affec 00000000 kernel32!WaitForSingleObject+0xf
>
>
>
>
> Thread ID: 10
> System Thread ID: 158
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\system32\USER32.dll -
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> \\?\C:\WINDOWS\system32\inetsrv\asp.dll -
> Thread Status: Thread is in a WAIT state.
> Thread Type: ASP
> Executing Page: ASP.dll symbols not found. Unable to locate ASP page.
> Continuing with other analysis.
>
> # ChildEBP RetAddr
> 00 02aefe1c 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 02aefec8 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 02aeff24 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 02aeff40 70a183cc USER32!MsgWaitForMultipleObjects+0x1d
> 04 70a36fa0 00000310 asp!AspStatusHtmlDump+0x305c
>
>
> ...
>
>
>
> Thread ID: 23
> System Thread ID: a78
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\system32\RPCRT4.dll -
> Thread Type: Possible ASP page. Possible DCOM activity
> Executing Page: ASP.dll symbols not found. Unable to locate ASP page.
> Continuing with other analysis.
>
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\system32\ole32.dll -
> OLE32.dll Symbols not found. Unable to proceed with DCOM check.
> Continuing other analysis.
>
> # ChildEBP RetAddr
> 00 035dfe20 77f4313f SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 035dff8c 77c696a9 ntdll!NtReplyWaitReceivePortEx+0xc
> 02 035dffb0 77c696d7 RPCRT4!I_RpcBindingIsClientLocal+0x799
> 03 035dffec 00000000 RPCRT4!I_RpcBindingIsClientLocal+0x7c7
>
>
>
>
> Thread ID: 24
> System Thread ID: ae8
> Kernel Time: 0:0:0.93
> User Time: 0:0:0.250
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 03daff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 03daff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 03daff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 03daffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 25
> System Thread ID: ebc
> Kernel Time: 0:1:57.93
> User Time: 0:0:37.562
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\system32\ODBC32.dll -
> Thread Status: Thread is in a WAIT state.
> Other information: Thread is waiting for a lock to be released. Looking
> for
> lock owner.
> Owning thread System ID: ffff
> Thread Type: Other
> # ChildEBP RetAddr
> 00 03f9ecd0 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 03f9ed10 77f42044 ntdll!NtWaitForSingleObject+0xc
> 02 03f9ee1c 77e42e83 ntdll!RtlEnterCriticalSection+0x44
> 03 03f9ee4c 017d7ccc kernel32!FreeLibrary+0x11
> 04 03f9ee90 017d8058 ODBC32!SQLDescribeColW+0x2cc
> 05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
> 06 0c733a1d 00000000 0x11ce2a1c
>
>
>
>
> Thread ID: 26
> System Thread ID: 740
> Kernel Time: 0:3:0.500
> User Time: 0:0:59.390
> Thread Type: Other
> # ChildEBP RetAddr
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 00 040ecf34 77f487a4 ntdll!RtlImageDirectoryEntryToData+0x520
> 01 040ecf50 77f50cde ntdll!RtlImageDirectoryEntryToData+0x2c9
> 02 040ecf88 77f47684 ntdll!RtlReAllocateHeap+0x1623
> 03 040ed1b4 77f4f648 ntdll!RtlAllocateHeap+0x3a8
> 04 040ed388 1f9ce43e ntdll!RtlpEnsureBufferSize+0x4e9
> 05 040ed3a8 1f9d79f6 SQLSRV32!SQLParamOptions+0x308
> 06 040ed408 1f9d7855 SQLSRV32!SQLColAttributeW+0x12a5
> 07 040ed4a4 02020e7e SQLSRV32!SQLColAttributeW+0x1104
> 08 e7ffffff 00000000 0x2020e7e
>
>
>
>
> Thread ID: 27
> System Thread ID: 834
> Kernel Time: 0:0:14.921
> User Time: 0:0:10.0
> Thread Status: Thread is in a WAIT state.
> Thread Type: Idle ASP thread
> # ChildEBP RetAddr
> 00 0414fdcc 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0414fe78 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 0414fed4 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 0414fef0 75614e57 USER32!MsgWaitForMultipleObjects+0x1d
> 04 0414ff84 77bc91ed comsvcs!CoCreateActivity+0x4e1a
> 05 0414ffb8 77e4a990 msvcrt!endthreadex+0x95
> 06 0414ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 28
> System Thread ID: ce0
> Kernel Time: 0:1:8.906
> User Time: 0:0:30.390
> Thread Status: Thread is in a WAIT state.
> Other information: Thread is waiting for a lock to be released. Looking
> for
> lock owner.
> Owning thread System ID: ffff
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0420de98 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0420ded8 77f42044 ntdll!NtWaitForSingleObject+0xc
> 02 0420df74 77f52042 ntdll!RtlEnterCriticalSection+0x44
> 03 0420dfb4 1f9d43cc ntdll!LdrGetProcedureAddress+0x17
> 04 0420e4e8 1f9d43eb SQLSRV32!SQLSetEnvAttr+0x88c
> 05 0420e4f4 1f9d4092 SQLSRV32!SQLSetEnvAttr+0x8ab
> 06 032d807a 006c0063 SQLSRV32!SQLSetEnvAttr+0x552
> 07 006d0074 00000000 0x6c0063
>
>
>
>
> Thread ID: 29
> System Thread ID: 94c
> Kernel Time: 0:0:42.859
> User Time: 0:0:14.609
> Thread Status: Thread is in a WAIT state.
> Other information: Thread is waiting for a lock to be released. Looking
> for
> lock owner.
> Owning thread System ID: 0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 043cf2f4 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 043cf334 77f42044 ntdll!NtWaitForSingleObject+0xc
> 02 043cf368 017d8058 ntdll!RtlEnterCriticalSection+0x44
> 03 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
> 04 0c733a1d 00000000 0x11ce2a1c
>
>
>
>
> Thread ID: 30
> System Thread ID: a34
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0456ff70 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0456ffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
> 02 0456ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 31
> System Thread ID: c4c
> Kernel Time: 0:0:0.78
> User Time: 0:0:0.375
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 03b3ff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 03b3ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 03b3ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 03b3ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 32
> System Thread ID: cd0
> Kernel Time: 0:0:0.140
> User Time: 0:0:0.187
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 03bcff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 03bcff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 03bcff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 03bcffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 33
> System Thread ID: f0
> Kernel Time: 0:0:0.187
> User Time: 0:0:0.265
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 03d2ff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 03d2ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 03d2ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 03d2ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 34
> System Thread ID: 7bc
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 03d6ff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 03d6ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 03d6ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 03d6ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 35
> System Thread ID: 8a4
> Kernel Time: 0:0:0.62
> User Time: 0:0:0.109
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 0486ff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0486ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 0486ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 0486ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 36
> System Thread ID: d0
> Kernel Time: 0:1:1.375
> User Time: 0:0:18.296
> Thread Type: Other
> # ChildEBP RetAddr
> 00 049bd39c 77f42d1b SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 049bd438 77f60066 ntdll!NtQueryDefaultUILanguage+0xc
> 02 049bd4a4 77d0a2ff ntdll!LdrFindResource_U+0x17
> 03 049bd4c8 77d0a799 USER32!GetSysColorBrush+0x85
> 04 049bd4ec 1f9d52b2 USER32!LoadStringA+0x1a
> 05 049bdf64 1f9c399e SQLSRV32!SQLSetEnvAttr+0x1772
> 06 049bdffc 00000105 SQLSRV32!SQLSetConnectAttrW+0x13e2
>
>
>
>
> Thread ID: 37
> System Thread ID: 9d8
> Kernel Time: 0:0:0.78
> User Time: 0:0:0.156
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 04e3ff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 04e3ff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 04e3ff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 04e3ffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 38
> System Thread ID: 408
> Kernel Time: 0:0:0.109
> User Time: 0:0:0.250
> Thread Type: HTTP Listener
> # ChildEBP RetAddr
> 00 08aaff28 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 08aaff58 5a302360 ntdll!ZwRemoveIoCompletion+0xc
> 02 08aaff90 5a302531 W3TP!THREAD_POOL::PostCompletion+0x78
> 03 08aaffec 00000000 W3TP!THREAD_POOL::~THREAD_POOL+0x11c
>
>
>
>
> Thread ID: 39
> System Thread ID: 270
> Kernel Time: 0:0:36.625
> User Time: 0:0:12.125
> Thread Status: Thread is in a WAIT state.
> Other information: Thread is waiting for a lock to be released. Looking
> for
> lock owner.
> Owning thread System ID: ffff
> Thread Type: Other
> # ChildEBP RetAddr
> 00 08aed120 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 08aed160 77f42044 ntdll!NtWaitForSingleObject+0xc
> 02 08aed1fc 77f52042 ntdll!RtlEnterCriticalSection+0x44
> 03 08aed23c 1f9d52c6 ntdll!LdrGetProcedureAddress+0x17
> 04 08aedcac 1f9c399e SQLSRV32!SQLSetEnvAttr+0x1786
> 05 08aedd44 00000105 SQLSRV32!SQLSetConnectAttrW+0x13e2
>
>
>
>
> Thread ID: 40
> System Thread ID: 474
> Kernel Time: 0:0:24.921
> User Time: 0:0:14.156
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\Program Files\Common Files\System\ado\msado15.dll -
> Thread Type: Other
> # ChildEBP RetAddr
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 00 08c2ee2c 02ce6ef8 msado15+0x1b7b
> 01 08c2ee68 02ce9946 msado15!DllGetClassObject+0x78
> 02 03ff3020 00000000 msado15!DllGetClassObject+0x2ac6
>
>
>
>
> Thread ID: 41
> System Thread ID: d30
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 090ffe54 77f4262b SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 090ffec0 77e416ee ntdll!NtDelayExecution+0xc
> 02 090fffb8 77e4a990 kernel32!Sleep+0xb
> 03 090fffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 42
> System Thread ID: e24
> Kernel Time: 0:0:0.156
> User Time: 0:0:2.0
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 096aff10 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 096aff84 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 096affb8 77e4a990 kernel32!WaitForSingleObject+0xf
> 03 096affec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 43
> System Thread ID: d84
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscorsvr.dll -
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 097ffe74 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 097fff20 77e4b0e4 ntdll!ZwWaitForMultipleObjects+0xc
> 02 097fffa0 7922d36a kernel32!WaitForMultipleObjects+0x17
> 03 097fffb8 77e4a990 mscorsvr!CoInitializeCor+0x90a7
> 04 097fffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 44
> System Thread ID: 77c
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.875
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0984ff14 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0984ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 0984ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
> 03 0984ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 45
> System Thread ID: d24
> Kernel Time: 0:0:0.15
> User Time: 0:0:0.500
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0988ff14 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0988ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 0988ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
> 03 0988ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 46
> System Thread ID: cc4
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.546
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0991ff14 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0991ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 0991ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
> 03 0991ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 47
> System Thread ID: 43c
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.781
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 09f5ff14 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 09f5ff88 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 09f5ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
> 03 09f5ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 48
> System Thread ID: f3c
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.62
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 09f9fe90 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 09f9ff3c 77e4b0e4 ntdll!ZwWaitForMultipleObjects+0xc
> 02 09f9ff74 79201c3d kernel32!WaitForMultipleObjects+0x17
> 03 09f9ffb8 77e4a990 mscorsvr!GetMetaDataInternalInterface+0x15193
> 04 09f9ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 49
> System Thread ID: df8
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 00 0a0cffa4 791c066c ntdll!NtDelayExecution+0xc
> 01 0a0cffec 00000000 mscorsvr!Ordinal74+0x1066c
>
>
>
>
> Thread ID: 50
> System Thread ID: f8c
> Kernel Time: 0:0:0.15
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0b54ff14 77d06718 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0b54ff34 771b93ef USER32!DispatchMessageW+0x1f
> 02 0b54ff74 771b936d ole32!CoGetInterceptorFromTypeInfo+0x224a
> 03 0b54ff90 771b92b8 ole32!CoGetInterceptorFromTypeInfo+0x21c8
> 04 00000000 00000000 ole32!CoGetInterceptorFromTypeInfo+0x2113
>
>
>
>
> Thread ID: 51
> System Thread ID: fe0
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> *** ERROR: Symbol file could not be found. Defaulted to export symbols
> for
> C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144cc f1df_1.0.100.0_x-ww_0D1F9F94\gdiplus.dll
> -
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 15c3fe48 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 15c3fef4 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 15c3ff50 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 15c3ff6c 70cc1637 USER32!MsgWaitForMultipleObjects+0x1d
> 04 00000001 00000000 gdiplus+0x1637
>
>
>
>
> Thread ID: 52
> System Thread ID: 10f4
> Kernel Time: 0:0:42.78
> User Time: 0:0:11.875
> Thread Status: Thread is in a WAIT state.
> Other information: Thread is waiting for a lock to be released. Looking
> for
> lock owner.
> Owning thread System ID: ffff
> Thread Type: SQL Query. Possible ASP page
> Executing Page: ASP.dll symbols not found. Unable to locate ASP page.
> Continuing with other analysis.
>
> # ChildEBP RetAddr
> 00 0b14d310 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0b14d350 77f42044 ntdll!NtWaitForSingleObject+0xc
> 02 0b14d3ec 77f52042 ntdll!RtlEnterCriticalSection+0x44
> 03 0b14d42c 6d563747 ntdll!LdrGetProcedureAddress+0x17
> 04 0b14d448 6d56386a DBNETLIB!TermSSPIPackage+0x4f7
> 05 0b14d484 00000330 DBNETLIB!InitSSPIPackage+0xea
>
>
>
> ...
>
>
>
>
> Thread ID: 69
> System Thread ID: 161c
> Kernel Time: 0:0:0.31
> User Time: 0:0:0.46
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 0d7afca0 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 0d7afd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 0d7afda8 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 0d7afdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
> 04 0d7afde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
> 05 0d7afef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
> 06 0d7aff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
> 07 0d7aff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
> 08 0d7affb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
> 09 0d7affec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 70
> System Thread ID: 16f4
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 1497ff70 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 1497ffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
> 02 1497ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 71
> System Thread ID: 1720
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 152fff70 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 152fffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
> 02 152fffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 72
> System Thread ID: b2c
> Kernel Time: 0:0:0.31
> User Time: 0:0:0.78
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 160dfca0 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 160dfd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 160dfda8 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 160dfdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
> 04 160dfde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
> 05 160dfef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
> 06 160dff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
> 07 160dff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
> 08 160dffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
> 09 160dffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 73
> System Thread ID: c80
> Kernel Time: 0:0:0.46
> User Time: 0:0:0.125
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 1607fca0 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 1607fd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 1607fda8 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 1607fdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
> 04 1607fde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
> 05 1607fef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
> 06 1607ff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
> 07 1607ff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
> 08 1607ffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
> 09 1607ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 74
> System Thread ID: d18
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Type: Other
> # ChildEBP RetAddr
> 00 1537ff70 77f430c7 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 1537ffb8 77e4a990 ntdll!ZwRemoveIoCompletion+0xc
> 02 1537ffec 00000000 kernel32!FlsSetValue+0x779
>
>
>
>
> Thread ID: 75
> System Thread ID: adc
> Kernel Time: 0:0:0.109
> User Time: 0:0:0.62
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 1700fca0 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 1700fd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 1700fda8 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 1700fdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
> 04 1700fde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
> 05 1700fef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
> 06 1700ff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
> 07 1700ff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
> 08 1700ffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
> 09 1700ffec 00000000 kernel32!FlsSetValue+0x779
>
> Thread ID: 76
> System Thread ID: e74
> Kernel Time: 0:0:0.78
> User Time: 0:0:0.125
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 174dfca0 77f4372d SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 174dfd4c 77d076f5 ntdll!ZwWaitForMultipleObjects+0xc
> 02 174dfda8 77d077f5 USER32!GetLastInputInfo+0xe4
> 03 174dfdc4 14cc405c USER32!MsgWaitForMultipleObjects+0x1d
> 04 174dfde4 14b9feec CRPE32!EnableDialogsHelp+0x1d85d
> 05 174dfef4 14b9fde0 CRPE32!PESetBackgroundThreadProc+0x3a0
> 06 174dff18 14d1994f CRPE32!PESetBackgroundThreadProc+0x294
> 07 174dff84 14cd0d2e CRPE32!EnableDialogsHelp+0x73150
> 08 174dffb8 77e4a990 CRPE32!EnableDialogsHelp+0x2a52f
> 09 174dffec 00000000 kernel32!FlsSetValue+0x779
>
> Thread ID: 77
> System Thread ID: 210
> Kernel Time: 0:0:0.0
> User Time: 0:0:0.0
> Thread Status: Thread is in a WAIT state.
> Thread Type: Other
> # ChildEBP RetAddr
> 00 1633ff10 77f43741 SharedUserData!SystemCallStub+0x4
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 01 1633ff84 77e4168f ntdll!NtWaitForSingleObject+0xc
> 02 1633ffb8 77e4a990 kernel32!WaitForSingleObject+0xf
> 03 1633ffec 00000000 kernel32!FlsSetValue+0x779
>

Re: IISState log (IIS slow)

Thank you for your reply. I would appriciate if you could help me to solve
this big trouble.

So this problem may be in asp code?

05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
06 0c733a1d 00000000 0x11ce2a1c
May be this is ODBC problem releasing connection??

All queries is limited to max ~10000 row return.

Here is my story(from another unanswered post here):
IIS processes pages normally without errors(only IIS Log sometimes throws
ODBC object not found exception), but
with delays(sometimes long delays).

We have 2003 server system with MSSQL2k on it and asp/asp.net applications
running. Previously we had win2k and iis 5.0 and same trouble. IIS uses only
NT4 file security when client requests file.

We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
AVG server load is 50-60% when IIS stops responding normally, asp&sql code I
think is optimised, but still there is lags when it
comes to opening asp files(even sometimes without asp code in it/plain html).

Two entrys I see in windows system log:

A lot of :

A worker process with process id of 'xxxx' serving application
pool 'DefaultAppPool' has requested a recycle because the worker process
reached its allowed processing time limit.


Followed by one:
A process serving application pool 'DefaultAppPool' exceeded time limits
during
shut down. The process id was 'xxxx'.

System Log fills with this stuff every 5-10 seconds. I have configured
recycle every 2 minutes in pool ,if not IIS totaly stops responding after
some time.


IISState shows only that what I already know, how i could point out the
problem?
I have several requests which are stuck waiting for a non-existent
thread and this is the problem so far.

Here is the asp code example that we have in average all our pages:

<%
var qstring="dsn=mydsn;uid=user;pwd=pass"

var ServerConnection=Server.CreateObject("ADODB.Connection"), RecordClone,
query;

//Initialize server connection
function CreateServer()
{
ServerConnection.Open(qstring);
}


//Finilize server connection
function DeleteServer(){
ServerConnection.Close();
ServerConnection=null;
}

//Function than runs sql query and in case of error parses error description
function runSQL(query) {
try {
RecordClone=ServerConnection.Execute(query);
return RecordClone;
}
catch (exception) {
Response.Write("");
}
}


CreateServer();
....

var data = runSQL("select xx from yy"); //lots of simple queries
runSQL("update xx set yy=zz");

....

DeleteServer();
%>

Nothing special as you see. ODBC connection, some simple queries, html
output and thats all. Same sql queries which I launch in asp, through query
analyzer runs in 0 secs
We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications on
it, also
sometimes we access sql server through access 2000/xp applications.Previously
we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
Overall system serves 50 users, approx 10 of them use server simultaneously
at one moment.



"Pat [MSFT]" rakstîja:

> IISState couldn't get to microsoft.com to get the symbols, so I can't tell
> you much. But it does look like you are having a problem either in the
> parsing of the query or processng the results. It doesn't look like there
> is a problem w/the SQL server.
>
> I would guess that you may have some query coming back that is huge (i.e.
> Select * FROM myTableOfOneMillionRows ).
>
> Pat
>
> "Janis Buks" wrote in message
> news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> > Where could be problem in my IIS? Processing SQL is very slow sometimes.
> > Here is IISState log:
> > ***********************
> > Starting new log output
> > IISState version 3.0
> >
> > Tue Nov 02 15:52:20 2004
> >
> > OS = Windows 2003 Server
> > Executable: w3wp.exe
> > PID = 304
> >
> > Note: Thread times are formatted as HH:MM:SS.ms
> >
> > ***********************
> >
> >
> >...

Re: IISState log (IIS slow)

> AVG server load is 50-60% when IIS stops responding normally,
> asp&sql code I think is optimised, but still there is lags when it
> comes to opening asp files(even sometimes without asp code in it
> /plain html).


It doesn't matter if the file does not have any ASP code in it or not. If
you have the exact same content in two files, one named default.htm and the
other default.asp, default.htm will be served faster. This is because the
former is handled directly by the IIS Static file handler, which sends the
file as-is and as fast as possible, while the latter must be first parsed by
ASP to make sure it has NO ASP code, and then it is sent. The same applies
if you have a *-scriptmap -- because that scriptmap will be loaded to handle
the request instead of allowing the fast IIS static file handler to do the
work. In other words, configuration is important to performance.


> Two entrys I see in windows system log:
> A lot of :
> A worker process with process id of 'xxxx' serving
> application pool 'DefaultAppPool' has requested a
> recycle because the worker process reached
> its allowed processing time limit.
>
> Followed by one:
> A process serving application pool 'DefaultAppPool'
> exceeded time limits during shut down. The
> process id was 'xxxx'.
>
> System Log fills with this stuff every 5-10 seconds. I have
> configured recycle every 2 minutes in pool ,if not IIS
> totaly stops responding after some time.

You've set up the AppPool to recycle every 2 minutes. This is insane. The
two events you reported tell me that you have requests that take >
210seconds to return (based on default configuration + your stated
settings), which under any sort of appreciable load means your server is
hosed no matter WHAT you do. Your application simply chews up the available
threads being blocked on something, and recycling every 2 minutes ensures
nothing is cached and repeatedly incur any startup costs. In other words,
your server is going to be dropping connections, have high CPU, and still
not function -- mostly because your web application isn't working.

So, I suggest you focus on lowering latency for your pages so that they do
not tie up the server. IIS tweaks cannot workaround all misbehaving
applications.

--
//David
IIS
This posting is provided "AS IS" with no warranties, and confers no rights.
//
"Janis Buks" wrote in message
news:261698D8-2FA8-4807-A6D9-5323512851B6@microsoft.com...
Thank you for your reply. I would appriciate if you could help me to solve
this big trouble.

So this problem may be in asp code?

05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
06 0c733a1d 00000000 0x11ce2a1c
May be this is ODBC problem releasing connection??

All queries is limited to max ~10000 row return.

Here is my story(from another unanswered post here):
IIS processes pages normally without errors(only IIS Log sometimes throws
ODBC object not found exception), but
with delays(sometimes long delays).

We have 2003 server system with MSSQL2k on it and asp/asp.net applications
running. Previously we had win2k and iis 5.0 and same trouble. IIS uses only
NT4 file security when client requests file.

We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
AVG server load is 50-60% when IIS stops responding normally, asp&sql code I
think is optimised, but still there is lags when it
comes to opening asp files(even sometimes without asp code in it/plain
html).

Two entrys I see in windows system log:

A lot of :

A worker process with process id of 'xxxx' serving application
pool 'DefaultAppPool' has requested a recycle because the worker process
reached its allowed processing time limit.


Followed by one:
A process serving application pool 'DefaultAppPool' exceeded time limits
during
shut down. The process id was 'xxxx'.

System Log fills with this stuff every 5-10 seconds. I have configured
recycle every 2 minutes in pool ,if not IIS totaly stops responding after
some time.


IISState shows only that what I already know, how i could point out the
problem?
I have several requests which are stuck waiting for a non-existent
thread and this is the problem so far.

Here is the asp code example that we have in average all our pages:

<%
var qstring="dsn=mydsn;uid=user;pwd=pass"

var ServerConnection=Server.CreateObject("ADODB.Connection"), RecordClone,
query;

//Initialize server connection
function CreateServer()
{
ServerConnection.Open(qstring);
}


//Finilize server connection
function DeleteServer(){
ServerConnection.Close();
ServerConnection=null;
}

//Function than runs sql query and in case of error parses error description
function runSQL(query) {
try {
RecordClone=ServerConnection.Execute(query);
return RecordClone;
}
catch (exception) {
Response.Write("");
}
}


CreateServer();
....

var data = runSQL("select xx from yy"); //lots of simple queries
runSQL("update xx set yy=zz");

....

DeleteServer();
%>

Nothing special as you see. ODBC connection, some simple queries, html
output and thats all. Same sql queries which I launch in asp, through query
analyzer runs in 0 secs
We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications on
it, also
sometimes we access sql server through access 2000/xp
applications.Previously
we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
Overall system serves 50 users, approx 10 of them use server simultaneously
at one moment.



"Pat [MSFT]" rakstîja:

> IISState couldn't get to microsoft.com to get the symbols, so I can't tell
> you much. But it does look like you are having a problem either in the
> parsing of the query or processng the results. It doesn't look like there
> is a problem w/the SQL server.
>
> I would guess that you may have some query coming back that is huge (i.e.
> Select * FROM myTableOfOneMillionRows ).
>
> Pat
>
> "Janis Buks" wrote in message
> news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> > Where could be problem in my IIS? Processing SQL is very slow sometimes.
> > Here is IISState log:
> > ***********************
> > Starting new log output
> > IISState version 3.0
> >
> > Tue Nov 02 15:52:20 2004
> >
> > OS = Windows 2003 Server
> > Executable: w3wp.exe
> > PID = 304
> >
> > Note: Thread times are formatted as HH:MM:SS.ms
> >
> > ***********************
> >
> >
> >...

Re: IISState log (IIS slow)

Talking about 2 minutes recycle configuration. Yes I know, not the best way
to configure IIS. But it's only way to return IIS to normal life. If this
parameter is 10,20 or more(turned off), IIS stops responding pages in less
than 30-60 seconds. It's only way how I can drop those locks which unknownly
occurs time to time. After recycling IIS produces pages very very fast, so I
can say that recycling IIS so often produces better result than if not.

"David Wang [Msft]" wrote:

> > AVG server load is 50-60% when IIS stops responding normally,
> > asp&sql code I think is optimised, but still there is lags when it
> > comes to opening asp files(even sometimes without asp code in it
> > /plain html).
>
>
> It doesn't matter if the file does not have any ASP code in it or not. If
> you have the exact same content in two files, one named default.htm and the
> other default.asp, default.htm will be served faster. This is because the
> former is handled directly by the IIS Static file handler, which sends the
> file as-is and as fast as possible, while the latter must be first parsed by
> ASP to make sure it has NO ASP code, and then it is sent. The same applies
> if you have a *-scriptmap -- because that scriptmap will be loaded to handle
> the request instead of allowing the fast IIS static file handler to do the
> work. In other words, configuration is important to performance.
>
>
> > Two entrys I see in windows system log:
> > A lot of :
> > A worker process with process id of 'xxxx' serving
> > application pool 'DefaultAppPool' has requested a
> > recycle because the worker process reached
> > its allowed processing time limit.
> >
> > Followed by one:
> > A process serving application pool 'DefaultAppPool'
> > exceeded time limits during shut down. The
> > process id was 'xxxx'.
> >
> > System Log fills with this stuff every 5-10 seconds. I have
> > configured recycle every 2 minutes in pool ,if not IIS
> > totaly stops responding after some time.
>
> You've set up the AppPool to recycle every 2 minutes. This is insane. The
> two events you reported tell me that you have requests that take >
> 210seconds to return (based on default configuration + your stated
> settings), which under any sort of appreciable load means your server is
> hosed no matter WHAT you do. Your application simply chews up the available
> threads being blocked on something, and recycling every 2 minutes ensures
> nothing is cached and repeatedly incur any startup costs. In other words,
> your server is going to be dropping connections, have high CPU, and still
> not function -- mostly because your web application isn't working.
>
> So, I suggest you focus on lowering latency for your pages so that they do
> not tie up the server. IIS tweaks cannot workaround all misbehaving
> applications.
>
> --
> //David
> IIS
> This posting is provided "AS IS" with no warranties, and confers no rights.
> //
> "Janis Buks" wrote in message
> news:261698D8-2FA8-4807-A6D9-5323512851B6@microsoft.com...
> Thank you for your reply. I would appriciate if you could help me to solve
> this big trouble.
>
> So this problem may be in asp code?
>
> 05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
> 06 0c733a1d 00000000 0x11ce2a1c
> May be this is ODBC problem releasing connection??
>
> All queries is limited to max ~10000 row return.
>
> Here is my story(from another unanswered post here):
> IIS processes pages normally without errors(only IIS Log sometimes throws
> ODBC object not found exception), but
> with delays(sometimes long delays).
>
> We have 2003 server system with MSSQL2k on it and asp/asp.net applications
> running. Previously we had win2k and iis 5.0 and same trouble. IIS uses only
> NT4 file security when client requests file.
>
> We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
> AVG server load is 50-60% when IIS stops responding normally, asp&sql code I
> think is optimised, but still there is lags when it
> comes to opening asp files(even sometimes without asp code in it/plain
> html).
>
> Two entrys I see in windows system log:
>
> A lot of :
>
> A worker process with process id of 'xxxx' serving application
> pool 'DefaultAppPool' has requested a recycle because the worker process
> reached its allowed processing time limit.
>
>
> Followed by one:
> A process serving application pool 'DefaultAppPool' exceeded time limits
> during
> shut down. The process id was 'xxxx'.
>
> System Log fills with this stuff every 5-10 seconds. I have configured
> recycle every 2 minutes in pool ,if not IIS totaly stops responding after
> some time.
>
>
> IISState shows only that what I already know, how i could point out the
> problem?
> I have several requests which are stuck waiting for a non-existent
> thread and this is the problem so far.
>
> Here is the asp code example that we have in average all our pages:
>
> <%
> var qstring="dsn=mydsn;uid=user;pwd=pass"
>
> var ServerConnection=Server.CreateObject("ADODB.Connection"), RecordClone,
> query;
>
> //Initialize server connection
> function CreateServer()
> {
> ServerConnection.Open(qstring);
> }
>
>
> //Finilize server connection
> function DeleteServer(){
> ServerConnection.Close();
> ServerConnection=null;
> }
>
> //Function than runs sql query and in case of error parses error description
> function runSQL(query) {
> try {
> RecordClone=ServerConnection.Execute(query);
> return RecordClone;
> }
> catch (exception) {
> Response.Write("");
> }
> }
>
>
> CreateServer();
> ....
>
> var data = runSQL("select xx from yy"); //lots of simple queries
> runSQL("update xx set yy=zz");
>
> ....
>
> DeleteServer();
> %>
>
> Nothing special as you see. ODBC connection, some simple queries, html
> output and thats all. Same sql queries which I launch in asp, through query
> analyzer runs in 0 secs
> We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications on
> it, also
> sometimes we access sql server through access 2000/xp
> applications.Previously
> we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
> Overall system serves 50 users, approx 10 of them use server simultaneously
> at one moment.
>
>
>
> "Pat [MSFT]" rakstîja:
>
> > IISState couldn't get to microsoft.com to get the symbols, so I can't tell
> > you much. But it does look like you are having a problem either in the
> > parsing of the query or processng the results. It doesn't look like there
> > is a problem w/the SQL server.
> >
> > I would guess that you may have some query coming back that is huge (i.e.
> > Select * FROM myTableOfOneMillionRows ).
> >
> > Pat
> >
> > "Janis Buks" wrote in message
> > news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> > > Where could be problem in my IIS? Processing SQL is very slow sometimes.
> > > Here is IISState log:
> > > ***********************
> > > Starting new log output
> > > IISState version 3.0
> > >
> > > Tue Nov 02 15:52:20 2004
> > >
> > > OS = Windows 2003 Server
> > > Executable: w3wp.exe
> > > PID = 304
> > >
> > > Note: Thread times are formatted as HH:MM:SS.ms
> > >
> > > ***********************
> > >
> > >
> > >...
>
>
>

Re: IISState log (IIS slow)

I can't really say more w/out better information. IISState needs to have
internet access at least 1 time to download the symbols from MS.com. After
that, they are cached on the local HDD.

As to the problem...

Could be a bug in ODBC, could be a problem in the SQL, could be a problem
w/an ASP page in an endless loop; inside the loop a query is being executed
making the problem look like a SQL issue.


Pat

"Janis Buks" wrote in message
news:261698D8-2FA8-4807-A6D9-5323512851B6@microsoft.com...
> Thank you for your reply. I would appriciate if you could help me to solve
> this big trouble.
>
> So this problem may be in asp code?
>
> 05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
> 06 0c733a1d 00000000 0x11ce2a1c
> May be this is ODBC problem releasing connection??
>
> All queries is limited to max ~10000 row return.
>
> Here is my story(from another unanswered post here):
> IIS processes pages normally without errors(only IIS Log sometimes throws
> ODBC object not found exception), but
> with delays(sometimes long delays).
>
> We have 2003 server system with MSSQL2k on it and asp/asp.net applications
> running. Previously we had win2k and iis 5.0 and same trouble. IIS uses
> only
> NT4 file security when client requests file.
>
> We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
> AVG server load is 50-60% when IIS stops responding normally, asp&sql code
> I
> think is optimised, but still there is lags when it
> comes to opening asp files(even sometimes without asp code in it/plain
> html).
>
> Two entrys I see in windows system log:
>
> A lot of :
>
> A worker process with process id of 'xxxx' serving application
> pool 'DefaultAppPool' has requested a recycle because the worker process
> reached its allowed processing time limit.
>
>
> Followed by one:
> A process serving application pool 'DefaultAppPool' exceeded time limits
> during
> shut down. The process id was 'xxxx'.
>
> System Log fills with this stuff every 5-10 seconds. I have configured
> recycle every 2 minutes in pool ,if not IIS totaly stops responding after
> some time.
>
>
> IISState shows only that what I already know, how i could point out the
> problem?
> I have several requests which are stuck waiting for a non-existent
> thread and this is the problem so far.
>
> Here is the asp code example that we have in average all our pages:
>
> <%
> var qstring="dsn=mydsn;uid=user;pwd=pass"
>
> var ServerConnection=Server.CreateObject("ADODB.Connection"),
> RecordClone,
> query;
>
> //Initialize server connection
> function CreateServer()
> {
> ServerConnection.Open(qstring);
> }
>
>
> //Finilize server connection
> function DeleteServer(){
> ServerConnection.Close();
> ServerConnection=null;
> }
>
> //Function than runs sql query and in case of error parses error
> description
> function runSQL(query) {
> try {
> RecordClone=ServerConnection.Execute(query);
> return RecordClone;
> }
> catch (exception) {
> Response.Write("");
> }
> }
>
>
> CreateServer();
> ...
>
> var data = runSQL("select xx from yy"); //lots of simple queries
> runSQL("update xx set yy=zz");
>
> ...
>
> DeleteServer();
> %>
>
> Nothing special as you see. ODBC connection, some simple queries, html
> output and thats all. Same sql queries which I launch in asp, through
> query
> analyzer runs in 0 secs
> We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications
> on
> it, also
> sometimes we access sql server through access 2000/xp
> applications.Previously
> we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
> Overall system serves 50 users, approx 10 of them use server
> simultaneously
> at one moment.
>
>
>
> "Pat [MSFT]" rakstîja:
>
>> IISState couldn't get to microsoft.com to get the symbols, so I can't
>> tell
>> you much. But it does look like you are having a problem either in the
>> parsing of the query or processng the results. It doesn't look like
>> there
>> is a problem w/the SQL server.
>>
>> I would guess that you may have some query coming back that is huge (i.e.
>> Select * FROM myTableOfOneMillionRows ).
>>
>> Pat
>>
>> "Janis Buks" wrote in message
>> news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
>> > Where could be problem in my IIS? Processing SQL is very slow
>> > sometimes.
>> > Here is IISState log:
>> > ***********************
>> > Starting new log output
>> > IISState version 3.0
>> >
>> > Tue Nov 02 15:52:20 2004
>> >
>> > OS = Windows 2003 Server
>> > Executable: w3wp.exe
>> > PID = 304
>> >
>> > Note: Thread times are formatted as HH:MM:SS.ms
>> >
>> > ***********************
>> >
>> >
>> >...

Re: IISState log (IIS slow)

I wonder if this is affecting your situation -- are you using Access MDB?

http://support.microsoft.com/default.aspx?scid=kb;en-us;8383 06

--
//David
IIS
This posting is provided "AS IS" with no warranties, and confers no rights.
//
"Janis Buks" wrote in message
news:777CBB62-F6CC-4713-ABE8-A9029DFE32B5@microsoft.com...
Talking about 2 minutes recycle configuration. Yes I know, not the best way
to configure IIS. But it's only way to return IIS to normal life. If this
parameter is 10,20 or more(turned off), IIS stops responding pages in less
than 30-60 seconds. It's only way how I can drop those locks which unknownly
occurs time to time. After recycling IIS produces pages very very fast, so I
can say that recycling IIS so often produces better result than if not.

"David Wang [Msft]" wrote:

> > AVG server load is 50-60% when IIS stops responding normally,
> > asp&sql code I think is optimised, but still there is lags when it
> > comes to opening asp files(even sometimes without asp code in it
> > /plain html).
>
>
> It doesn't matter if the file does not have any ASP code in it or not. If
> you have the exact same content in two files, one named default.htm and
the
> other default.asp, default.htm will be served faster. This is because the
> former is handled directly by the IIS Static file handler, which sends the
> file as-is and as fast as possible, while the latter must be first parsed
by
> ASP to make sure it has NO ASP code, and then it is sent. The same
applies
> if you have a *-scriptmap -- because that scriptmap will be loaded to
handle
> the request instead of allowing the fast IIS static file handler to do the
> work. In other words, configuration is important to performance.
>
>
> > Two entrys I see in windows system log:
> > A lot of :
> > A worker process with process id of 'xxxx' serving
> > application pool 'DefaultAppPool' has requested a
> > recycle because the worker process reached
> > its allowed processing time limit.
> >
> > Followed by one:
> > A process serving application pool 'DefaultAppPool'
> > exceeded time limits during shut down. The
> > process id was 'xxxx'.
> >
> > System Log fills with this stuff every 5-10 seconds. I have
> > configured recycle every 2 minutes in pool ,if not IIS
> > totaly stops responding after some time.
>
> You've set up the AppPool to recycle every 2 minutes. This is insane.
The
> two events you reported tell me that you have requests that take >
> 210seconds to return (based on default configuration + your stated
> settings), which under any sort of appreciable load means your server is
> hosed no matter WHAT you do. Your application simply chews up the
available
> threads being blocked on something, and recycling every 2 minutes ensures
> nothing is cached and repeatedly incur any startup costs. In other words,
> your server is going to be dropping connections, have high CPU, and still
> not function -- mostly because your web application isn't working.
>
> So, I suggest you focus on lowering latency for your pages so that they do
> not tie up the server. IIS tweaks cannot workaround all misbehaving
> applications.
>
> --
> //David
> IIS
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> //
> "Janis Buks" wrote in message
> news:261698D8-2FA8-4807-A6D9-5323512851B6@microsoft.com...
> Thank you for your reply. I would appriciate if you could help me to solve
> this big trouble.
>
> So this problem may be in asp code?
>
> 05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
> 06 0c733a1d 00000000 0x11ce2a1c
> May be this is ODBC problem releasing connection??
>
> All queries is limited to max ~10000 row return.
>
> Here is my story(from another unanswered post here):
> IIS processes pages normally without errors(only IIS Log sometimes throws
> ODBC object not found exception), but
> with delays(sometimes long delays).
>
> We have 2003 server system with MSSQL2k on it and asp/asp.net applications
> running. Previously we had win2k and iis 5.0 and same trouble. IIS uses
only
> NT4 file security when client requests file.
>
> We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
> AVG server load is 50-60% when IIS stops responding normally, asp&sql code
I
> think is optimised, but still there is lags when it
> comes to opening asp files(even sometimes without asp code in it/plain
> html).
>
> Two entrys I see in windows system log:
>
> A lot of :
>
> A worker process with process id of 'xxxx' serving application
> pool 'DefaultAppPool' has requested a recycle because the worker process
> reached its allowed processing time limit.
>
>
> Followed by one:
> A process serving application pool 'DefaultAppPool' exceeded time limits
> during
> shut down. The process id was 'xxxx'.
>
> System Log fills with this stuff every 5-10 seconds. I have configured
> recycle every 2 minutes in pool ,if not IIS totaly stops responding after
> some time.
>
>
> IISState shows only that what I already know, how i could point out the
> problem?
> I have several requests which are stuck waiting for a non-existent
> thread and this is the problem so far.
>
> Here is the asp code example that we have in average all our pages:
>
> <%
> var qstring="dsn=mydsn;uid=user;pwd=pass"
>
> var ServerConnection=Server.CreateObject("ADODB.Connection"),
RecordClone,
> query;
>
> //Initialize server connection
> function CreateServer()
> {
> ServerConnection.Open(qstring);
> }
>
>
> //Finilize server connection
> function DeleteServer(){
> ServerConnection.Close();
> ServerConnection=null;
> }
>
> //Function than runs sql query and in case of error parses error
description
> function runSQL(query) {
> try {
> RecordClone=ServerConnection.Execute(query);
> return RecordClone;
> }
> catch (exception) {
> Response.Write("");
> }
> }
>
>
> CreateServer();
> ....
>
> var data = runSQL("select xx from yy"); //lots of simple queries
> runSQL("update xx set yy=zz");
>
> ....
>
> DeleteServer();
> %>
>
> Nothing special as you see. ODBC connection, some simple queries, html
> output and thats all. Same sql queries which I launch in asp, through
query
> analyzer runs in 0 secs
> We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications
on
> it, also
> sometimes we access sql server through access 2000/xp
> applications.Previously
> we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
> Overall system serves 50 users, approx 10 of them use server
simultaneously
> at one moment.
>
>
>
> "Pat [MSFT]" rakstîja:
>
> > IISState couldn't get to microsoft.com to get the symbols, so I can't
tell
> > you much. But it does look like you are having a problem either in the
> > parsing of the query or processng the results. It doesn't look like
there
> > is a problem w/the SQL server.
> >
> > I would guess that you may have some query coming back that is huge
(i.e.
> > Select * FROM myTableOfOneMillionRows ).
> >
> > Pat
> >
> > "Janis Buks" wrote in message
> > news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> > > Where could be problem in my IIS? Processing SQL is very slow
sometimes.
> > > Here is IISState log:
> > > ***********************
> > > Starting new log output
> > > IISState version 3.0
> > >
> > > Tue Nov 02 15:52:20 2004
> > >
> > > OS = Windows 2003 Server
> > > Executable: w3wp.exe
> > > PID = 304
> > >
> > > Note: Thread times are formatted as HH:MM:SS.ms
> > >
> > > ***********************
> > >
> > >
> > >...
>
>
>

Re: IISState log (IIS slow)

As about IIState symbols I will try as soon as possible to connect production
server to internet(we have difficulties connecting production server to
external network - security issues..)

"Pat [MSFT]" wrote:

> I can't really say more w/out better information. IISState needs to have
> internet access at least 1 time to download the symbols from MS.com. After
> that, they are cached on the local HDD.
>
> As to the problem...
>
> Could be a bug in ODBC, could be a problem in the SQL, could be a problem
> w/an ASP page in an endless loop; inside the loop a query is being executed
> making the problem look like a SQL issue.
>
>
> Pat
>
> "Janis Buks" wrote in message
> news:261698D8-2FA8-4807-A6D9-5323512851B6@microsoft.com...
> > Thank you for your reply. I would appriciate if you could help me to solve
> > this big trouble.
> >
> > So this problem may be in asp code?
> >
> > 05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
> > 06 0c733a1d 00000000 0x11ce2a1c
> > May be this is ODBC problem releasing connection??
> >
> > All queries is limited to max ~10000 row return.
> >
> > Here is my story(from another unanswered post here):
> > IIS processes pages normally without errors(only IIS Log sometimes throws
> > ODBC object not found exception), but
> > with delays(sometimes long delays).
> >
> > We have 2003 server system with MSSQL2k on it and asp/asp.net applications
> > running. Previously we had win2k and iis 5.0 and same trouble. IIS uses
> > only
> > NT4 file security when client requests file.
> >
> > We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
> > AVG server load is 50-60% when IIS stops responding normally, asp&sql code
> > I
> > think is optimised, but still there is lags when it
> > comes to opening asp files(even sometimes without asp code in it/plain
> > html).
> >
> > Two entrys I see in windows system log:
> >
> > A lot of :
> >
> > A worker process with process id of 'xxxx' serving application
> > pool 'DefaultAppPool' has requested a recycle because the worker process
> > reached its allowed processing time limit.
> >
> >
> > Followed by one:
> > A process serving application pool 'DefaultAppPool' exceeded time limits
> > during
> > shut down. The process id was 'xxxx'.
> >
> > System Log fills with this stuff every 5-10 seconds. I have configured
> > recycle every 2 minutes in pool ,if not IIS totaly stops responding after
> > some time.
> >
> >
> > IISState shows only that what I already know, how i could point out the
> > problem?
> > I have several requests which are stuck waiting for a non-existent
> > thread and this is the problem so far.
> >
> > Here is the asp code example that we have in average all our pages:
> >
> > <%
> > var qstring="dsn=mydsn;uid=user;pwd=pass"
> >
> > var ServerConnection=Server.CreateObject("ADODB.Connection"),
> > RecordClone,
> > query;
> >
> > //Initialize server connection
> > function CreateServer()
> > {
> > ServerConnection.Open(qstring);
> > }
> >
> >
> > //Finilize server connection
> > function DeleteServer(){
> > ServerConnection.Close();
> > ServerConnection=null;
> > }
> >
> > //Function than runs sql query and in case of error parses error
> > description
> > function runSQL(query) {
> > try {
> > RecordClone=ServerConnection.Execute(query);
> > return RecordClone;
> > }
> > catch (exception) {
> > Response.Write("");
> > }
> > }
> >
> >
> > CreateServer();
> > ...
> >
> > var data = runSQL("select xx from yy"); //lots of simple queries
> > runSQL("update xx set yy=zz");
> >
> > ...
> >
> > DeleteServer();
> > %>
> >
> > Nothing special as you see. ODBC connection, some simple queries, html
> > output and thats all. Same sql queries which I launch in asp, through
> > query
> > analyzer runs in 0 secs
> > We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications
> > on
> > it, also
> > sometimes we access sql server through access 2000/xp
> > applications.Previously
> > we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
> > Overall system serves 50 users, approx 10 of them use server
> > simultaneously
> > at one moment.
> >
> >
> >
> > "Pat [MSFT]" rakstîja:
> >
> >> IISState couldn't get to microsoft.com to get the symbols, so I can't
> >> tell
> >> you much. But it does look like you are having a problem either in the
> >> parsing of the query or processng the results. It doesn't look like
> >> there
> >> is a problem w/the SQL server.
> >>
> >> I would guess that you may have some query coming back that is huge (i.e.
> >> Select * FROM myTableOfOneMillionRows ).
> >>
> >> Pat
> >>
> >> "Janis Buks" wrote in message
> >> news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> >> > Where could be problem in my IIS? Processing SQL is very slow
> >> > sometimes.
> >> > Here is IISState log:
> >> > ***********************
> >> > Starting new log output
> >> > IISState version 3.0
> >> >
> >> > Tue Nov 02 15:52:20 2004
> >> >
> >> > OS = Windows 2003 Server
> >> > Executable: w3wp.exe
> >> > PID = 304
> >> >
> >> > Note: Thread times are formatted as HH:MM:SS.ms
> >> >
> >> > ***********************
> >> >
> >> >
> >> >...
>
>
>

Re: IISState log (IIS slow)

As about http://support.microsoft.com/default.aspx?scid=kb;en-us;8383 06
article, I suppose Jet is used when asp accesses only MSAccess database file,
am I right? Therefore it's not my case because one and only datasource we
hawe MSSQL server. Througt MSAccess we access MSSQL not vice versa(ASP->MDB).

"David Wang [Msft]" wrote:

> I wonder if this is affecting your situation -- are you using Access MDB?
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;8383 06
>
> --
> //David
> IIS
> This posting is provided "AS IS" with no warranties, and confers no rights.
> //
> "Janis Buks" wrote in message
> news:777CBB62-F6CC-4713-ABE8-A9029DFE32B5@microsoft.com...
> Talking about 2 minutes recycle configuration. Yes I know, not the best way
> to configure IIS. But it's only way to return IIS to normal life. If this
> parameter is 10,20 or more(turned off), IIS stops responding pages in less
> than 30-60 seconds. It's only way how I can drop those locks which unknownly
> occurs time to time. After recycling IIS produces pages very very fast, so I
> can say that recycling IIS so often produces better result than if not.
>
> "David Wang [Msft]" wrote:
>
> > > AVG server load is 50-60% when IIS stops responding normally,
> > > asp&sql code I think is optimised, but still there is lags when it
> > > comes to opening asp files(even sometimes without asp code in it
> > > /plain html).
> >
> >
> > It doesn't matter if the file does not have any ASP code in it or not. If
> > you have the exact same content in two files, one named default.htm and
> the
> > other default.asp, default.htm will be served faster. This is because the
> > former is handled directly by the IIS Static file handler, which sends the
> > file as-is and as fast as possible, while the latter must be first parsed
> by
> > ASP to make sure it has NO ASP code, and then it is sent. The same
> applies
> > if you have a *-scriptmap -- because that scriptmap will be loaded to
> handle
> > the request instead of allowing the fast IIS static file handler to do the
> > work. In other words, configuration is important to performance.
> >
> >
> > > Two entrys I see in windows system log:
> > > A lot of :
> > > A worker process with process id of 'xxxx' serving
> > > application pool 'DefaultAppPool' has requested a
> > > recycle because the worker process reached
> > > its allowed processing time limit.
> > >
> > > Followed by one:
> > > A process serving application pool 'DefaultAppPool'
> > > exceeded time limits during shut down. The
> > > process id was 'xxxx'.
> > >
> > > System Log fills with this stuff every 5-10 seconds. I have
> > > configured recycle every 2 minutes in pool ,if not IIS
> > > totaly stops responding after some time.
> >
> > You've set up the AppPool to recycle every 2 minutes. This is insane.
> The
> > two events you reported tell me that you have requests that take >
> > 210seconds to return (based on default configuration + your stated
> > settings), which under any sort of appreciable load means your server is
> > hosed no matter WHAT you do. Your application simply chews up the
> available
> > threads being blocked on something, and recycling every 2 minutes ensures
> > nothing is cached and repeatedly incur any startup costs. In other words,
> > your server is going to be dropping connections, have high CPU, and still
> > not function -- mostly because your web application isn't working.
> >
> > So, I suggest you focus on lowering latency for your pages so that they do
> > not tie up the server. IIS tweaks cannot workaround all misbehaving
> > applications.
> >
> > --
> > //David
> > IIS
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > //
> > "Janis Buks" wrote in message
> > news:261698D8-2FA8-4807-A6D9-5323512851B6@microsoft.com...
> > Thank you for your reply. I would appriciate if you could help me to solve
> > this big trouble.
> >
> > So this problem may be in asp code?
> >
> > 05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
> > 06 0c733a1d 00000000 0x11ce2a1c
> > May be this is ODBC problem releasing connection??
> >
> > All queries is limited to max ~10000 row return.
> >
> > Here is my story(from another unanswered post here):
> > IIS processes pages normally without errors(only IIS Log sometimes throws
> > ODBC object not found exception), but
> > with delays(sometimes long delays).
> >
> > We have 2003 server system with MSSQL2k on it and asp/asp.net applications
> > running. Previously we had win2k and iis 5.0 and same trouble. IIS uses
> only
> > NT4 file security when client requests file.
> >
> > We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
> > AVG server load is 50-60% when IIS stops responding normally, asp&sql code
> I
> > think is optimised, but still there is lags when it
> > comes to opening asp files(even sometimes without asp code in it/plain
> > html).
> >
> > Two entrys I see in windows system log:
> >
> > A lot of :
> >
> > A worker process with process id of 'xxxx' serving application
> > pool 'DefaultAppPool' has requested a recycle because the worker process
> > reached its allowed processing time limit.
> >
> >
> > Followed by one:
> > A process serving application pool 'DefaultAppPool' exceeded time limits
> > during
> > shut down. The process id was 'xxxx'.
> >
> > System Log fills with this stuff every 5-10 seconds. I have configured
> > recycle every 2 minutes in pool ,if not IIS totaly stops responding after
> > some time.
> >
> >
> > IISState shows only that what I already know, how i could point out the
> > problem?
> > I have several requests which are stuck waiting for a non-existent
> > thread and this is the problem so far.
> >
> > Here is the asp code example that we have in average all our pages:
> >
> > <%
> > var qstring="dsn=mydsn;uid=user;pwd=pass"
> >
> > var ServerConnection=Server.CreateObject("ADODB.Connection"),
> RecordClone,
> > query;
> >
> > //Initialize server connection
> > function CreateServer()
> > {
> > ServerConnection.Open(qstring);
> > }
> >
> >
> > //Finilize server connection
> > function DeleteServer(){
> > ServerConnection.Close();
> > ServerConnection=null;
> > }
> >
> > //Function than runs sql query and in case of error parses error
> description
> > function runSQL(query) {
> > try {
> > RecordClone=ServerConnection.Execute(query);
> > return RecordClone;
> > }
> > catch (exception) {
> > Response.Write("");
> > }
> > }
> >
> >
> > CreateServer();
> > ....
> >
> > var data = runSQL("select xx from yy"); //lots of simple queries
> > runSQL("update xx set yy=zz");
> >
> > ....
> >
> > DeleteServer();
> > %>
> >
> > Nothing special as you see. ODBC connection, some simple queries, html
> > output and thats all. Same sql queries which I launch in asp, through
> query
> > analyzer runs in 0 secs
> > We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications
> on
> > it, also
> > sometimes we access sql server through access 2000/xp
> > applications.Previously
> > we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
> > Overall system serves 50 users, approx 10 of them use server
> simultaneously
> > at one moment.
> >
> >
> >
> > "Pat [MSFT]" rakstîja:
> >
> > > IISState couldn't get to microsoft.com to get the symbols, so I can't
> tell
> > > you much. But it does look like you are having a problem either in the
> > > parsing of the query or processng the results. It doesn't look like
> there
> > > is a problem w/the SQL server.
> > >
> > > I would guess that you may have some query coming back that is huge
> (i.e.
> > > Select * FROM myTableOfOneMillionRows ).
> > >
> > > Pat
> > >
> > > "Janis Buks" wrote in message
> > > news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> > > > Where could be problem in my IIS? Processing SQL is very slow
> sometimes.
> > > > Here is IISState log:
> > > > ***********************
> > > > Starting new log output
> > > > IISState version 3.0
> > > >
> > > > Tue Nov 02 15:52:20 2004
> > > >
> > > > OS = Windows 2003 Server
> > > > Executable: w3wp.exe
> > > > PID = 304
> > > >
> > > > Note: Thread times are formatted as HH:MM:SS.ms
> > > >
> > > > ***********************
> > > >
> > > >
> > > >...
> >
> >
> >
>
>
>