SQL Server Performance

Problemas con SQL Diagnostic de Idera

Discussion in 'Preguntas sobre SQL Server en Español.' started by rollback, Jan 31, 2007.

  1. rollback New Member

    Tengo el SQL Diagnostic de idera y de vez en cuando me arroja un stack dump y me bota el servidor, tengo entendido que no funciona con el SQL 7.0 PERO SI con el SQL 2000, lamentablemente el error lo dá en algunas máquinas que tengo con 2000 y service pack 4..<br /> Alguien tiene sabe si existe un parche del idera que me resuelva este problema??<br /><br /><br />sqlDumpExceptionHandler: Process 141 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..<br />* *******************************************************************************<br />*<br />* BEGIN STACK DUMP:<br />* 01/25/07 13:09:44 spid 141<br />*<br />* Exception Address = 00647125 (CRowsetTraceData::FGetNextRow + 0000015B Line 0+00000000)<br />* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION<br />* Access Violation occurred reading address 13862000<br />* Input Buffer 4088 bytes -<br />* SET LOCK_TIMEOUT 20000 SET IMPLICIT_TRANSACTIONS OFF if @@TRANCOUNT &gt; 0 <br />* COMMIT TRANSACTION SET Language us_english SET ANSI_WARNINGS OFF SET CU<br />* RSOR_CLOSE_ON_COMMIT OFF SET QUERY_GOVERNOR_COST_LIMIT 0 SET TRANSACTI<br />* ON ISOLATION LEVEL READ UNCOMMITTED set nocount on declare @P1 int, @on<br />* bit, @counter int, @rowcount int, @rc varchar, @eventclass int, @previo<br />* useventclass int, @sqltext varchar(3061), @duration int, @reads int, @wr<br />* ites int, @cpu int, @date varchar(4), @time varchar(<img src='/community/emoticons/emotion-11.gif' alt='8)' />, @mm varchar(2), <br />* @dd varchar(2), @hh varchar(2), @mi varchar(2), @ss varchar(2), @hex var<br />* binary(30), @ntusername varchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' />, @ntdomainname varchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' />, @hostn<br />* ame varchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' />, @appname varchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' />, @sqlname varchar(255), @DBID in<br />* t select @on = 1 begin transaction if not exists (select * from tempdb.<br />* .sysobjects where id = object_id('tempdb..SQLProbe_Process_Traces1') and<br />* type = 'U') create table tempdb..SQLProbe_Process_Traces1 (host_name v<br />* archar(255), queue_number int) select @P1 = queue_number from tempdb..S<br />* QLProbe_Process_Traces1 where host_name = HOST_NAME() select @rowcount <br />* = @@rowcount if @rowcount &gt; 0 goto correct_trace recreate_trace: delete <br />* from tempdb..SQLProbe_Process_Traces1 where host_name = HOST_NAME() exe<br />* c @rc = sp_trace_create @P1 output, 1, NULL, NULL, NULL if @P1 &lt;&gt; 0 inse<br />* rt into tempdb..SQLProbe_Process_Traces1 values (HOST_NAME(), @P1) exec<br />* @rc = sp_trace_setevent @P1, 43, 1, @on exec @rc = sp_trace_setevent @<br />* P1, 43, 3, @on exec @rc = sp_trace_setevent @P1, 43, 6, @on exec @rc = <br />* sp_trace_setevent @P1, 43, 7, @on exec @rc = sp_trace_setevent @P1, 43, <br />* 8, @on exec @rc = sp_trace_setevent @P1, 43, 10, @on exec @rc = sp_trace<br />* _setevent @P1, 43, 11, @on exec @rc = sp_trace_setevent @P1, 43, 13, @on<br />* exec @rc = sp_trace_setevent @P1, 43, 15, @on exec @rc = sp_trace_setev<br />* ent @P1, 43, 16, @on exec @rc = sp_trace_setevent @P1, 43, 17, @on exec <br />* @rc = sp_trace_setevent @P1, 43, 18, @on exec @rc = sp_trace_setevent @<br />* P1, 41, 1, @on exec @rc = sp_trace_setevent @P1, 41, 3, @on exec @rc =<br />* sp_trace_setevent @P1, 41, <br />* <br />*<br />* MODULE BASE END SIZE<br />* sqlservr 00400000 00B32FFF 00733000<br />* ntdll 7C800000 7C8BFFFF 000c0000<br />* kernel32 77E40000 77F41FFF 00102000<br />* ADVAPI32 77F50000 77FEBFFF 0009c000<br />* RPCRT4 77C50000 77CEFFFF 000a0000<br />* USER32 77380000 77411FFF 00092000<br />* GDI32 77C00000 77C47FFF 00048000<br />* OPENDS60 41060000 41065FFF 00006000<br />* MSVCRT 77BA0000 77BF9FFF 0005a000<br />* UMS 41070000 4107BFFF 0000c000<br />* SQLSORT 42AE0000 42B6FFFF 00090000<br />* MSVCIRT 60020000 6002FFFF 00010000<br />* sqlevn70 10000000 10006FFF 00007000<br />* Secur32 76F50000 76F62FFF 00013000<br />* NETAPI32 11090000 110E7FFF 00058000<br />* ole32 11500000 11633FFF 00134000<br />* XOLEHLP 11640000 11645FFF 00006000<br />* MSDTCPRX 11650000 116C7FFF 00078000<br />* msvcp60 116D0000 11730FFF 00061000<br />* MTXCLU 11740000 11758FFF 00019000<br />* VERSION 11760000 11767FFF 00008000<br />* WSOCK32 11770000 11778FFF 00009000<br />* WS2_32 11780000 11796FFF 00017000<br />* WS2HELP 117A0000 117A7FFF 00008000<br />* OLEAUT32 117B0000 1183BFFF 0008c000<br />* CLUSAPI 11880000 11891FFF 00012000<br />* RESUTILS 118A0000 118B2FFF 00013000<br />* USERENV 118C0000 11983FFF 000c4000<br />* mswsock 119A0000 119E0FFF 00041000<br />* DNSAPI 119F0000 11A1EFFF 0002f000<br />* winrnr 11A60000 11A66FFF 00007000<br />* WLDAP32 11A70000 11A9DFFF 0002e000<br />* rasadhlp 11AC0000 11AC7FFF 00008000<br />* SSNETLIB 00C70000 00C84FFF 00015000<br />* NTMARTA 00CC0000 00CE1FFF 00022000<br />* SAMLIB 122A0000 122AEFFF 0000f000<br />* security 125B0000 125B3FFF 00004000<br />* hnetcfg 125C0000 12618FFF 00059000<br />* wshtcpip 12660000 12667FFF 00008000<br />* SSmsLPCn 12EF0000 12EF7FFF 00008000<br />* SSnmPN70 12F00000 12F05FFF 00006000<br />* ntdsapi 12F90000 12FA4FFF 00015000<br />* msv1_0 12FB0000 12FD6FFF 00027000<br />* iphlpapi 12FE0000 12FF9FFF 0001a000<br />* PSAPI 13000000 1300AFFF 0000b000<br />* rsaenh 13410000 1343EFFF 0002f000<br />* xpsp2res 12B30000 12DF4FFF 002c5000<br />* CLBCatQ 13AA0000 13B22FFF 00083000<br />* COMRes 13B30000 13BF5FFF 000c6000<br />* sqloledb 13C00000 13C80FFF 00081000<br />* MSDART 12730000 12749FFF 0001a000<br />* MSDATL3 12750000 12764FFF 00015000<br />* oledb32 13F50000 13FC8FFF 00079000<br />* OLEDB32R 12A10000 12A20FFF 00011000<br />* xpstar 13FD0000 14016FFF 00047000<br />* SQLRESLD 12A30000 12A36FFF 00007000<br />* SQLSVC 12E40000 12E56FFF 00017000<br />* ODBC32 14020000 1405CFFF 0003d000<br />* COMCTL32 14060000 140F6FFF 00097000<br />* comdlg32 14100000 14149FFF 0004a000<br />* SHELL32 14150000 14953FFF 00804000<br />* SHLWAPI 14960000 149B1FFF 00052000<br />* odbcbcp 138A0000 138A5FFF 00006000<br />* W95SCM 13950000 1395BFFF 0000c000<br />* SQLUNIRL 149C0000 149ECFFF 0002d000<br />* WINSPOOL 149F0000 14A16FFF 00027000<br />* SHFOLDER 14A20000 14A28FFF 00009000<br />* comctl32 14A40000 14B42FFF 00103000<br />* odbcint 14D30000 14D46FFF 00017000<br />* NDDEAPI 14E50000 14E56FFF 00007000<br />* SQLSVC 14E60000 14E65FFF 00006000<br />* xpstar 14E90000 14E98FFF 00009000<br />* xplog70 12A90000 12AA1FFF 00012000<br />* xplog70 12540000 12543FFF 00004000<br />* DBNETLIB 12780000 1279BFFF 0001c000<br />* crypt32 14EA0000 14F32FFF 00093000<br />* MSASN1 127A0000 127B1FFF 00012000<br />* SQLFTQRY 15040000 15071FFF 00032000<br />* xpsqlbot 00D00000 00D05FFF 00006000<br />* sqlvdi 12AB0000 12ABBFFF 0000c000<br />* ACTIVEDS 150F0000 15122FFF 00033000<br />* adsldpc 15130000 15156FFF 00027000<br />* credui 15160000 1518DFFF 0002e000<br />* ATL 15190000 151A7FFF 00018000<br />* adsldp 151F0000 1521DFFF 0002e000<br />* dbghelp 16150000 16204FFF 000b5000<br />*<br />* Edi: 193C1BF0: 00000000 00000000 00000000 00000000 00000000 00000000 <br />* Esi: 13861FFE: <br />* Eax: 6E0068F4: 45550008 6E006880 4543494F 00000001 00400038 0099CB68 <br />* Ebx: 73BD0D08: 009B4E58 00000001 00000001 00000001 42C9BAD8 00000000 <br />* Ecx: 1B76D34D: 00000000 00000000 00000000 00000000 00000000 00000000 <br />* Edx: 00000000: <br />* Eip: 00647125: C88BA5F3 F303E183 FC458BA4 04D0448B 42204301 7CF8553B <br />* Ebp: 163CE914: 163CE924 009304D3 73BD0648 73BD0518 163CE980 00572BEE <br />* SegCs: 0000001B: <br />* EFlags: 00010202: 00730079 00650074 0033006D 005C0032 006D0063 002E0064 <br />* Esp: 163CE900: 73BD0CC0 73BD0654 00000000 00000001 42C9BAF8 163CE924 <br />* SegSs: 00000023: <br />* *******************************************************************************<br />* -------------------------------------------------------------------------------<br />* Short Stack Dump<br />* 00647125 Module(sqlservr+00247125) (CRowsetTraceData::FGetNextRow+0000015B)<br />* 009304D3 Module(sqlservr+005304D3) (CUtRowset::GetNextRows+00000050)<br />* 00572BEE Module(sqlservr+00172BEE) (CQScanRmtScan::GetRow+00000155)<br />* 004110B3 Module(sqlservr+000110B3) (CQueryScan::GetRow+00000014)<br />* 0041D3EF Module(sqlservr+0001D3EF) (CStmtQuery::ErsqExecuteQuery+00000357)<br />* 0042C4AF Module(sqlservr+0002C4AF) (CStmtSelect:<img src='/community/emoticons/emotion-12.gif' alt=':X' />retExecute+00000229)<br />* 0041C3CB Module(sqlservr+0001C3CB) (CMsqlExecContext::ExecuteStmts+000003B9)<br />* 0041BA11 Module(sqlservr+0001BA11) (CMsqlExecContext::Execute+000001B6)<br />* 0041B02D Module(sqlservr+0001B02D) (CSQLSource::Execute+00000357)<br />* 00564774 Module(sqlservr+00164774) (CStmtExec:<img src='/community/emoticons/emotion-12.gif' alt=':X' />retLocalExec+0000014D)<br />* 00564610 Module(sqlservr+00164610) (CStmtExec:<img src='/community/emoticons/emotion-12.gif' alt=':X' />retExecute+0000031A)<br />* 0060909E Module(sqlservr+0020909E) (CStmtDML:<img src='/community/emoticons/emotion-12.gif' alt=':X' />retExecuteInsertExec+0000036E)<br />* 00583E5D Module(sqlservr+00183E5D) (CStmtDML:<img src='/community/emoticons/emotion-12.gif' alt=':X' />retExecute+00000012)<br />* 0041C3CB Module(sqlservr+0001C3CB) (CMsqlExecContext::ExecuteStmts+000003B9)<br />* 0041BA11 Module(sqlservr+0001BA11) (CMsqlExecContext::Execute+000001B6)<br />* 0041B02D Module(sqlservr+0001B02D) (CSQLSource::Execute+00000357)<br />* 0048DAE8 Module(sqlservr+0008DAE<img src='/community/emoticons/emotion-11.gif' alt='8)' /> (language_exec+000003E1)<br />* 004292A5 Module(sqlservr+000292A5) (process_commands+0000010E)<br />* 41072838 Module(UMS+0000283<img src='/community/emoticons/emotion-11.gif' alt='8)' /> (ProcessWorkRequests+00000272)<br />* 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+0000009<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br />* 77BCB3CA Module(MSVCRT+0002B3CA) (endthread+000000AB)<br />* 77E660C3 Module(kernel32+000260C3) (GetModuleFileNameA+000000EB)<br />* -------------------------------------------------------------------------------
  2. Luis Martin Moderator

    El Diagnostic Manager lo tienes instalado en el servidor o en un puesto de trabajo?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page