Error File BugCheck Dump
-
The SQL server I generate this dump and after this, when I conduct some operations, like cursors, it consumes all the memory to me of the server :
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server 1792.842
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is Award Modular BIOS v4.51PG
aN**** PCA-6178 BIOS Version V1.11 Date: 06/09/2000 ****
Current local time is Tue Jul 17 17:53:04 2007
1 Intel x86 level 6, 1 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
------
MemoryLoad = 98% TotalPhys = 255 MB AvailPhys = 2 MB
TotalPageFile = 1002 MB
Dump thread - spid = 7, PSS = 0x1fa9c084, EC = 0x1fa9c234
Stack Dump being sent to C:\MSSQL7\log\SQL00001.dmp
*******************************************************************************
*
* BEGIN STACK DUMP:
* 07/17/07 17:53:04 spid 7
*
*
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f96be6 Module(ntdll+16be6) (ZwGetContextThread+b)
0x00784f83 Module(sqlservr+384f83) (utassert_fail+19f)
0x006c3061 Module(sqlservr+2c3061) (SDES:
ropBlobs+59) 0x00594a3f Module(sqlservr+194a3f) (SDES::IndexDeleteRow+364)
0x0078003e Module(sqlservr+38003e) (UpdateSysindexes+175)
0x0078021a Module(sqlservr+38021a) (SEDropIndex+183)
0x005b9115 Module(sqlservr+1b9115) (FUpsBuildStatsSample+8b)
0x00783844 Module(sqlservr+383844) (FUpsBuildStats+11c)
0x005b9f23 Module(sqlservr+1b9f23) (updatestats+5ca)
0x00602132 Module(sqlservr+202132) (CStmtUpdStats::XretExecute+65)
0x004145f1 Module(sqlservr+145f1) (CMsqlExecContext::ExecuteStmts+11a)
0x0041409f Module(sqlservr+1409f) (CMsqlExecContext::Execute+16a)
PSS @0x1FA9C084
---------------
pspid = 7 m_dwLoginFlags = 0x0000 plsid = 9
pbackground = 1
pbSid
-----
01 .
sSecFlags = 0x10
pdeadlockpri = 0 poffsets = 0x0 pss_stats = 0x0
ptickcount = 144587 pcputickcount = 151275910877
ploginstamp = 11 ptimestamp = 1900-01-01 00:00:00.000
prowcount = 0 plangid = 0 pdateformat = 0
pdatefirst = 0 Language = RemServer =
UserName = sa HostName = poptions = 0x200020
poptions2 = 0x4020 pline = 1 pcurstepno = 1
prowcount = 0 pstatlist = 0 pcurcmd = 241
pseqstat = 0 ptextsize = 4096 pretstat = 0
pslastbatchstarttime = 1900-01-01 00:00:00.000 pmemusage = 572
hLicense = 0 tpFlags = 0x1 isolation_level = 0
fips_flag = 0x0 sSaveSecFlags = 0x0 psavedb = 0
pfetchstat = 0 pcrsrows = -1
pslastbatchtime = 1900-01-01 00:00:00.000 pubexecdb = 0
fInReplicatedProcExec = 0 pdelimitor = pxcb = 0x1f972028
pxcb->xcb_xactcnt = 0 pxcb_lock_recursion = 0 pdlckseq = 0
presSemCount = [0]531218996 presSemCount = [0]531218996
pcputot = 0 pcputotstart = 0 pcpucmdstart = 0
pbufread = 4244 pbufreadstart = 0 plogbufread = 78841
plogbufreadstart = 0 pbufwrite = 81 pbufwritestart = 0
pLockTimeout = 4294967295
pec
---
ecid = 0 ec_stat = 0x400 pcurdb = 7
ec_curckptdb = 0x0 ec_lasterror = 0 ec_preverror = 0
ec_cpucur = 0 ec_cmderrs = 0 ec_timeslice = 95
ec_dbtable = 0x1f972840 ec_reswait = 0x0 ec_dbindex = 1
psrvproc->eclClient = 2 psrvproc->status = 2 psrvproc->bNewPacket = 0
psrvproc->pmo = 0x1fa9c028 psrvproc->ums_context = 0x0
psrvproc->pV7LoginRec
---------------------
00000000: 00000000 00000000 00000000 00000000 00000000 ....................
00000014: 00000000 00000000 00000000 00000000 00000000 ....................
00000028: 00000000 00000000 00000000 00000000 00000000 ....................
0000003c: 00000000 00000000 00000000 00000000 00000000 ....................
00000050: 00000000 00000000 ........
Top SRV_RPCINFO structure
---------------------------
00000000: 00000000 00000000 00000000 00000000 00000000 ....................
00000014: 00000000 00000000 00000000 00000000 00000000 ....................
00000028: 00000000 00000000 00000000 ............
psrvproc->srvio.outbuff
-----------------------
00000000: 04001000 00000000 ff010000 00010000 00ff0100 ....................
00000014: 00000000 0000ff01 00000000 000000ab a6000656 ...................V
00000028: 00000000 4d005300 51004c00 53006500 72007600 ....M.S.Q.L.S.e.r.v.
0000003c: 65007200 41006700 65006e00 74002000 69007300 e.r.A.g.e.n.t. .i.s.
00000050: 20006e00 6f007400 20006300 75007200 72006500 .n.o.t. .c.u.r.r.e.
00000064: 6e007400 6c007900 20007200 75006e00 6e006900 n.t.l.y. .r.u.n.n.i.
00000078: 6e006700 20007300 6f002000 63006100 6e006e00 n.g. .s.o. .c.a.n.n.
0000008c: 6f007400 20006200 65002000 6e006f00 74006900 o.t. .b.e. .n.o.t.i.
000000a0: 66006900 65006400 20006f00 66002000 74006800 f.i.e.d. .o.f. .t.h.
000000b4: 69007300 20006100 63007400 69006f00 6e002e00 i.s. .a.c.t.i.o.n...
000000c8: 00000000 ff010000 00000000 00ff0100 00000000 ....................
000000dc: 0000aba6 00065600 0000004d 00530051 004c0053 ......V....M.S.Q.L.S
000000f0: 00650072 00760065 00720041 00670065 006e0074 .e.r.v.e.r.A.g.e.n.t
00000104: 00200069 00730020 006e006f 00740020 00630075 . .i.s. .n.o.t. .c.u
00000118: 00720072 0065006e 0074006c 00790020 00720075 .r.r.e.n.t.l.y. .r.u
0000012c: 006e006e 0069006e 00670020 0073006f 00200063 .n.n.i.n.g. .s.o. .c
00000140: 0061006e 006e006f 00740020 00620065 0020006e .a.n.n.o.t. .b.e. .n
00000154: 006f0074 00690066 00690065 00640020 006f0066 .o.t.i.f.i.e.d. .o.f
00000168: 00200074 00680069 00730020 00610063 00740069 . .t.h.i.s. .a.c.t.i
0000017c: 006f006e 002e0000 000000ff 01000000 00000000 .o.n................
00000190: ff010000 00000000 00aba600 06560000 00004d00 .............V....M.
000001a4: 53005100 4c005300 65007200 76006500 72004100 S.Q.L.S.e.r.v.e.r.A.
000001b8: 67006500 6e007400 20006900 73002000 6e006f00 g.e.n.t. .i.s. .n.o.
000001cc: 74002000 63007500 72007200 65006e00 74006c00 t. .c.u.r.r.e.n.t.l.
000001e0: 79002000 72007500 6e006e00 69006e00 67002000 y. .r.u.n.n.i.n.g. .
000001f4: 73006f00 20006300 61006e00 6e006f00 74002000 s.o. .c.a.n.n.o.t. .
00000208: 62006500 20006e00 6f007400 69006600 69006500 b.e. .n.o.t.i.f.i.e.
0000021c: 64002000 6f006600 20007400 68006900 73002000 d. .o.f. .t.h.i.s. .
00000230: 61006300 74006900 6f006e00 2e000000 0000ff01 a.c.t.i.o.n.........
00000244: 00000000 000000ff 01000000 00000000 ff010000 ....................
00000258: 00000000 00aba600 06560000 00004d00 53005100 .........V....M.S.Q.
0000026c: 4c005300 65007200 76006500 72004100 67006500 L.S.e.r.v.e.r.A.g.e.
00000280: 6e007400 20006900 73002000 6e006f00 74002000 n.t. .i.s. .n.o.t. .
00000294: 63007500 72007200 65006e00 74006c00 79002000 c.u.r.r.e.n.t.l.y. .
000002a8: 72007500 6e006e00 69006e00 67002000 73006f00 r.u.n.n.i.n.g. .s.o.
000002bc: 20006300 61006e00 6e006f00 74002000 62006500 .c.a.n.n.o.t. .b.e.
000002d0: 20006e00 6f007400 69006600 69006500 64002000 .n.o.t.i.f.i.e.d. .
000002e4: 6f006600 20007400 68006900 73002000 61006300 o.f. .t.h.i.s. .a.c.
000002f8: 74006900 6f006e00 2e000000 0000ff01 00000000 t.i.o.n.............
0000030c: 000000ff 01000000 00000000 aba60006 56000000 ................V...
00000320: 004d0053 0051004c 00530065 00720076 00650072 .M.S.Q.L.S.e.r.v.e.r
00000334: 00410067 0065006e 00740020 00690073 0020006e .A.g.e.n.t. .i.s. .n
00000348: 006f0074 00200063 00750072 00720065 006e0074 .o.t. .c.u.r.r.e.n.t
0000035c: 006c0079 00200072 0075006e 006e0069 006e0067 .l.y. .r.u.n.n.i.n.g
00000370: 00200073 006f0020 00630061 006e006e 006f0074 . .s.o. .c.a.n.n.o.t
00000384: 00200062 00650020 006e006f 00740069 00660069 . .b.e. .n.o.t.i.f.i
00000398: 00650064 0020006f 00660020 00740068 00690073 .e.d. .o.f. .t.h.i.s
000003ac: 00200061 00630074 0069006f 006e002e 00000000 . .a.c.t.i.o.n......
000003c0: 00ff0100 00000000 0000ff01 00000000 000000ff ....................
000003d4: 01000000 00000000 aba60006 56000000 004d0053 ............V....M.S
000003e8: 0051004c 00530065 00720076 00650072 00410067 .Q.L.S.e.r.v.e.r.A.g
000003fc: 0065006e 00740020 00690073 0020006e 006f0074 .e.n.t. .i.s. .n.o.t
00000410: 00200063 00750072 00720065 006e0074 006c0079 . .c.u.r.r.e.n.t.l.y
00000424: 00200072 0075006e 006e0069 006e0067 00200073 . .r.u.n.n.i.n.g. .s
00000438: 006f0020 00630061 006e006e 006f0074 00200062 .o. .c.a.n.n.o.t. .b
0000044c: 00650020 006e006f 00740069 00660069 00650064 .e. .n.o.t.i.f.i.e.d
00000460: 0020006f 00660020 00740068 00690073 00200061 . .o.f. .t.h.i.s. .a
00000474: 00630074 0069006f 006e002e 00000000 00ff0100 .c.t.i.o.n..........
00000488: 00000000 0000ff01 00000000 000000ab a6000656 ...................V
0000049c: 00000000 4d005300 51004c00 53006500 72007600 ....M.S.Q.L.S.e.r.v.
000004b0: 65007200 41006700 65006e00 74002000 69007300 e.r.A.g.e.n.t. .i.s.
000004c4: 20006e00 6f007400 20006300 75007200 72006500 .n.o.t. .c.u.r.r.e.
000004d8: 6e007400 6c007900 20007200 75006e00 6e006900 n.t.l.y. .r.u.n.n.i.
000004ec: 6e006700 20007300 6f002000 63006100 6e006e00 n.g. .s.o. .c.a.n.n.
00000500: 6f007400 20006200 65002000 6e006f00 74006900 o.t. .b.e. .n.o.t.i.
00000514: 66006900 65006400 20006f00 66002000 74006800 f.i.e.d. .o.f. .t.h.
00000528: 69007300 20006100 63007400 69006f00 6e002e00 i.s. .a.c.t.i.o.n...
0000053c: 00000000 ff010000 00000000 00ff0100 00000000 ....................
00000550: 0000aba6 00065600 0000004d 00530051 004c0053 ......V....M.S.Q.L.S
00000564: 00650072 00760065 00720041 00670065 006e0074 .e.r.v.e.r.A.g.e.n.t
00000578: 00200069 00730020 006e006f 00740020 00630075 . .i.s. .n.o.t. .c.u
0000058c: 00720072 0065006e 0074006c 00790020 00720075 .r.r.e.n.t.l.y. .r.u
000005a0: 006e006e 0069006e 00670020 0073006f 00200063 .n.n.i.n.g. .s.o. .c
000005b4: 0061006e 006e006f 00740020 00620065 0020006e .a.n.n.o.t. .b.e. .n
000005c8: 006f0074 00690066 00690065 00640020 006f0066 .o.t.i.f.i.e.d. .o.f
000005dc: 00200074 00680069 00730020 00610063 00740069 . .t.h.i.s. .a.c.t.i
000005f0: 006f006e 002e0000 000000ff 01000000 00000000 .o.n................
00000604: ff010000 00000000 00ff0100 00000000 0000aba6 ....................
00000618: 00065600 0000004d 00530051 004c0053 00650072 ..V....M.S.Q.L.S.e.r
0000062c: 00760065 00720041 00670065 006e0074 00200069 .v.e.r.A.g.e.n.t. .i
00000640: 00730020 006e006f 00740020 00630075 00720072 .s. .n.o.t. .c.u.r.r
00000654: 0065006e 0074006c 00790020 00720075 006e006e .e.n.t.l.y. .r.u.n.n
00000668: 0069006e 00670020 0073006f 00200063 0061006e .i.n.g. .s.o. .c.a.n
0000067c: 006e006f 00740020 00620065 0020006e 006f0074 .n.o.t. .b.e. .n.o.t
00000690: 00690066 00690065 00640020 006f0066 00200074 .i.f.i.e.d. .o.f. .t
000006a4: 00680069 00730020 00610063 00740069 006f006e .h.i.s. .a.c.t.i.o.n
000006b8: 002e0000 000000ff 01000000 00000000 ff010000 ....................
000006cc: 00000000 00ff0100 00000000 0000aba6 00065600 ..................V.
000006e0: 0000004d 00530051 004c0053 00650072 00760065 ...M.S.Q.L.S.e.r.v.e
000006f4: 00720041 00670065 006e0074 00200069 00730020 .r.A.g.e.n.t. .i.s.
00000708: 006e006f 00740020 00630075 00720072 0065006e .n.o.t. .c.u.r.r.e.n
0000071c: 0074006c 00790020 00720075 006e006e 0069006e .t.l.y. .r.u.n.n.i.n
00000730: 00670020 0073006f 00200063 0061006e 006e006f .g. .s.o. .c.a.n.n.o
00000744: 00740020 00620065 0020006e 006f0074 00690066 .t. .b.e. .n.o.t.i.f
00000758: 00690065 00640020 006f0066 00200074 00680069 .i.e.d. .o.f. .t.h.i
0000076c: 00730020 00610063 00740069 006f006e 002e0000 .s. .a.c.t.i.o.n....
00000780: 000000ff 01000000 00000000 ff010000 00000000 ....................
00000794: 00aba600 06560000 00004d00 53005100 4c005300 .....V....M.S.Q.L.S.
000007a8: 65007200 76006500 72004100 67006500 6e007400 e.r.v.e.r.A.g.e.n.t.
000007bc: 20006900 73002000 6e006f00 74002000 63007500 .i.s. .n.o.t. .c.u.
000007d0: 72007200 65006e00 74006c00 79002000 72007500 r.r.e.n.t.l.y. .r.u.
000007e4: 6e006e00 69006e00 67002000 73006f00 20006300 n.n.i.n.g. .s.o. .c.
000007f8: 61006e00 6e006f00 74002000 62006500 20006e00 a.n.n.o.t. .b.e. .n.
0000080c: 6f007400 69006600 69006500 64002000 6f006600 o.t.i.f.i.e.d. .o.f.
00000820: 20007400 68006900 73002000 61006300 74006900 .t.h.i.s. .a.c.t.i.
00000834: 6f006e00 2e000000 0000ff01 00000000 000000ff o.n.................
00000848: 01000000 00000000 aba60006 56000000 004d0053 ............V....M.S
0000085c: 0051004c 00530065 00720076 00650072 00410067 .Q.L.S.e.r.v.e.r.A.g
00000870: 0065006e 00740020 00690073 0020006e 006f0074 .e.n.t. .i.s. .n.o.t
00000884: 00200063 00750072 00720065 006e0074 006c0079 . .c.u.r.r.e.n.t.l.y
00000898: 00200072 0075006e 006e0069 006e0067 00200073 . .r.u.n.n.i.n.g. .s
000008ac: 006f0020 00630061 006e006e 006f0074 00200062 .o. .c.a.n.n.o.t. .b
000008c0: 00650020 006e006f 00740069 00660069 00650064 .e. .n.o.t.i.f.i.e.d
000008d4: 0020006f 00660020 00740068 00690073 00200061 . .o.f. .t.h.i.s. .a
000008e8: 00630074 0069006f 006e002e 00000000 00ff0100 .c.t.i.o.n..........
000008fc: 00000000 0000ff01 00000000 000000ff 01000000 ....................
00000910: 00000000 aba60006 56000000 004d0053 0051004c ........V....M.S.Q.L
00000924: 00530065 00720076 00650072 00410067 0065006e .S.e.r.v.e.r.A.g.e.n
00000938: 00740020 00690073 0020006e 006f0074 00200063 .t. .i.s. .n.o.t. .c
0000094c: 00750072 00720065 006e0074 006c0079 00200072 .u.r.r.e.n.t.l.y. .r
00000960: 0075006e 006e0069 006e0067 00200073 006f0020 .u.n.n.i.n.g. .s.o.
00000974: 00630061 006e006e 006f0074 00200062 00650020 .c.a.n.n.o.t. .b.e.
00000988: 006e006f 00740069 00660069 00650064 0020006f .n.o.t.i.f.i.e.d. .o
0000099c: 00660020 00740068 00690073 00200061 00630074 .f. .t.h.i.s. .a.c.t
000009b0: 0069006f 006e002e 00000000 00ff0100 00000000 .i.o.n..............
000009c4: 0000ff01 00000000 000000ab a6000656 00000000 ...............V....
000009d8: 4d005300 51004c00 53006500 72007600 65007200 M.S.Q.L.S.e.r.v.e.r.
000009ec: 41006700 65006e00 74002000 69007300 20006e00 A.g.e.n.t. .i.s. .n.
00000a00: 6f007400 20006300 75007200 72006500 6e007400 o.t. .c.u.r.r.e.n.t.
00000a14: 6c007900 20007200 75006e00 6e006900 6e006700 l.y. .r.u.n.n.i.n.g.
00000a28: 20007300 6f002000 63006100 6e006e00 6f007400 .s.o. .c.a.n.n.o.t.
00000a3c: 20006200 65002000 6e006f00 74006900 66006900 .b.e. .n.o.t.i.f.i.
00000a50: 65006400 20006f00 66002000 74006800 69007300 e.d. .o.f. .t.h.i.s.
00000a64: 20006100 63007400 69006f00 6e002e00 00000000 .a.c.t.i.o.n.......
00000a78: ff010000 00000000 00ff0100 00000000 0000ff01 ....................
00000a8c: 00000000 000000ab a6000656 00000000 4d005300 ...........V....M.S.
00000aa0: 51004c00 53006500 72007600 65007200 41006700 Q.L.S.e.r.v.e.r.A.g.
00000ab4: 65006e00 74002000 69007300 20006e00 6f007400 e.n.t. .i.s. .n.o.t.
00000ac8: 20006300 75007200 72006500 6e007400 6c007900 .c.u.r.r.e.n.t.l.y.
00000adc: 20007200 75006e00 6e006900 6e006700 20007300 .r.u.n.n.i.n.g. .s.
00000af0: 6f002000 63006100 6e006e00 6f007400 20006200 o. .c.a.n.n.o.t. .b.
00000b04: 65002000 6e006f00 74006900 66006900 65006400 e. .n.o.t.i.f.i.e.d.
00000b18: 20006f00 66002000 74006800 69007300 20006100 .o.f. .t.h.i.s. .a.
00000b2c: 63007400 69006f00 6e002e00 00000000 ff010000 c.t.i.o.n...........
00000b40: 00000000 00ff0100 00000000 0000aba6 00065600 ..................V.
00000b54: 0000004d 00530051 004c0053 00650072 00760065 ...M.S.Q.L.S.e.r.v.e
00000b68: 00720041 00670065 006e0074 00200069 00730020 .r.A.g.e.n.t. .i.s.
00000b7c: 006e006f 00740020 00630075 00720072 0065006e .n.o.t. .c.u.r.r.e.n
00000b90: 0074006c 00790020 00720075 006e006e 0069006e .t.l.y. .r.u.n.n.i.n
00000ba4: 00670020 0073006f 00200063 0061006e 006e006f .g. .s.o. .c.a.n.n.o
00000bb8: 00740020 00620065 0020006e 006f0074 00690066 .t. .b.e. .n.o.t.i.f
00000bcc: 00690065 00640020 006f0066 00200074 00680069 .i.e.d. .o.f. .t.h.i
00000be0: 00730020 00610063 00740069 006f006e 002e0000 .s. .a.c.t.i.o.n....
00000bf4: 000000ff 01000000 00000000 ff010000 00000000 ....................
00000c08: 00aba600 06560000 00004d00 53005100 4c005300 .....V....M.S.Q.L.S.
00000c1c: 65007200 76006500 72004100 67006500 6e007400 e.r.v.e.r.A.g.e.n.t.
00000c30: 20006900 73002000 6e006f00 74002000 63007500 .i.s. .n.o.t. .c.u.
00000c44: 72007200 65006e00 74006c00 79002000 72007500 r.r.e.n.t.l.y. .r.u.
00000c58: 6e006e00 69006e00 67002000 73006f00 20006300 n.n.i.n.g. .s.o. .c.
00000c6c: 61006e00 6e006f00 74002000 62006500 20006e00 a.n.n.o.t. .b.e. .n.
00000c80: 6f007400 69006600 69006500 64002000 6f006600 o.t.i.f.i.e.d. .o.f.
00000c94: 20007400 68006900 73002000 61006300 74006900 .t.h.i.s. .a.c.t.i.
00000ca8: 6f006e00 2e000000 0000ff01 00000000 000000ff o.n.................
00000cbc: 01000000 00000000 ff010000 00000000 00aba600 ....................
00000cd0: 06560000 00004d00 53005100 4c005300 65007200 .V....M.S.Q.L.S.e.r.
00000ce4: 76006500 72004100 67006500 6e007400 20006900 v.e.r.A.g.e.n.t. .i.
00000cf8: 73002000 6e006f00 74002000 63007500 72007200 s. .n.o.t. .c.u.r.r.
00000d0c: 65006e00 74006c00 79002000 72007500 6e006e00 e.n.t.l.y. .r.u.n.n.
00000d20: 69006e00 67002000 73006f00 20006300 61006e00 i.n.g. .s.o. .c.a.n.
00000d34: 6e006f00 74002000 62006500 20006e00 6f007400 n.o.t. .b.e. .n.o.t.
00000d48: 69006600 69006500 64002000 6f006600 20007400 i.f.i.e.d. .o.f. .t.
00000d5c: 68006900 73002000 61006300 74006900 6f006e00 h.i.s. .a.c.t.i.o.n.
00000d70: 2e000000 0000ff01 00000000 000000ff 01000000 ....................
00000d84: 00000000 aba60006 56000000 004d0053 0051004c ........V....M.S.Q.L
00000d98: 00530065 00720076 00650072 00410067 0065006e .S.e.r.v.e.r.A.g.e.n
00000dac: 00740020 00690073 0020006e 006f0074 00200063 .t. .i.s. .n.o.t. .c
00000dc0: 00750072 00720065 006e0074 006c0079 00200072 .u.r.r.e.n.t.l.y. .r
00000dd4: 0075006e 006e0069 006e0067 00200073 006f0020 .u.n.n.i.n.g. .s.o.
00000de8: 00630061 006e006e 006f0074 00200062 00650020 .c.a.n.n.o.t. .b.e.
00000dfc: 006e006f 00740069 00660069 00650064 0020006f .n.o.t.i.f.i.e.d. .o
00000e10: 00660020 00740068 00690073 00200061 00630074 .f. .t.h.i.s. .a.c.t
00000e24: 0069006f 006e002e 00000000 00ff0100 00000000 .i.o.n..............
00000e38: 0000ff01 00000000 000000ff 01000000 00000000 ....................
00000e4c: aba60006 56000000 004d0053 0051004c 00530065 ....V....M.S.Q.L.S.e
00000e60: 00720076 00650072 00410067 0065006e 00740020 .r.v.e.r.A.g.e.n.t.
00000e74: 00690073 0020006e 006f0074 00200063 00750072 .i.s. .n.o.t. .c.u.r
00000e88: 00720065 006e0074 006c0079 00200072 0075006e .r.e.n.t.l.y. .r.u.n
00000e9c: 006e0069 006e0067 00200073 006f0020 00630061 .n.i.n.g. .s.o. .c.a
00000eb0: 006e006e 006f0074 00200062 00650020 006e006f .n.n.o.t. .b.e. .n.o
00000ec4: 00740069 00660069 00650064 0020006f 00660020 .t.i.f.i.e.d. .o.f.
00000ed8: 00740068 00690073 00200061 00630074 0069006f .t.h.i.s. .a.c.t.i.o
00000eec: 006e002e 00000000 00ff0100 00000000 0000ff01 .n..................
00000f00: 00000000 000000ab a6000656 00000000 4d005300 ...........V....M.S.
00000f14: 51004c00 53006500 72007600 65007200 41006700 Q.L.S.e.r.v.e.r.A.g.
00000f28: 65006e00 74002000 69007300 20006e00 6f007400 e.n.t. .i.s. .n.o.t.
00000f3c: 20006300 75007200 72006500 6e007400 6c007900 .c.u.r.r.e.n.t.l.y.
00000f50: 20007200 75006e00 6e006900 6e006700 20007300 .r.u.n.n.i.n.g. .s.
00000f64: 6f002000 63006100 6e006e00 6f007400 20006200 o. .c.a.n.n.o.t. .b.
00000f78: 65002000 6e006f00 74006900 66006900 65006400 e. .n.o.t.i.f.i.e.d.
00000f8c: 20006f00 66002000 74006800 69007300 20006100 .o.f. .t.h.i.s. .a.
00000fa0: 63007400 69006f00 6e002e00 00000000 ff010000 c.t.i.o.n...........
00000fb4: 00000000 00ff0100 00000000 0000aba6 00065600 ..................V.
00000fc8: 0000004d 00530051 004c0053 00650072 00760065 ...M.S.Q.L.S.e.r.v.e
00000fdc: 00720041 00670065 006e0074 00200069 00730020 .r.A.g.e.n.t. .i.s.
00000ff0: 006e006f 00740020 00630075 00720072 .n.o.t. .c.u.r.r
various psrvproc flags = 0x00000100
EC @0x1FA9C234
--------------
ec_pss->pspid = 0x7 ecid = 0 ec_cmderrs = 0
ec_stat = 0x400 ec_stat2 = 0x20001 ec_curdb = 7
ec_dbtable = 0x1f972840 ec_dbstat = 0x0 ec_lospin = 0x0
ec_dbindex = 1 ec_dbopen = 0 ec_waitfor = 0x0
ec_lasterror = 0 ec_save_ex_number = 208 ec_cpucur = 0
ec_timeslice = 95 ec_stackframe = 0 ec_next = 0x0
ec_prev = 0x0 ec_state = 1 ec_oliocnt = 0
ec_waittype = 0x0 ec_dbstat2 = 0 ec_preverror = 0
ec_subecstat = 1 ec_subecnext = 0x0 ec_resSemWaitInfo = 0
ec_deadlockSequence = 0 ec_lockFlags = 0 ec_backupContext = 0x0
ec_checkResultset = 0x0 ec_dbccContext = 0x0 ec_allocFile = 0x0
SDES @0x1FCCBA64
----------------
Des = 0x2F6638E0 ScanCur.PageId = (1:3752)
ScanCur.row.(rnum/roff) = 16 Current row = 0x1FB0B144
Sstat = 0x41801 sridoff = 74 slocks = 2
smode = 0x1
Kept buffer @0x11765340
-----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
Kept buffer @0x1FB0A000
-----------------------
m_pageId = (1:3752) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 2 m_indexId = 0 m_prevPage = (1:183)
m_nextPage = (1:254) pminlen = 82 m_slotCnt = 20
m_freeCnt = 4340 m_freeData = 6388 m_reservedCnt = 0
m_lsn = (1253242:2441:2) m_xactReserved = 0 m_xactId = (0:81643698)
m_ghostRecCnt = 1 m_tornBits = 0
SDES @0x1FAA1B5C
----------------
Des = 0x2F6686E0 ScanCur.PageId = (0:0) ScanCur.row.(rnum/roff) = 0
Current row = 0x00000000 Sstat = 0x0 sridoff = 0
slocks = 0 smode = 0x0
SDES @0x1FAA10A8
----------------
Des = 0x2F6686E0 ScanCur.PageId = (0:0) ScanCur.row.(rnum/roff) = 0
Current row = 0x00000000 Sstat = 0x0 sridoff = 0
slocks = 0 smode = 0x0
SDES @0x1FAA1548
----------------
Des = 0x2F6638E0 ScanCur.PageId = (1:3752)
ScanCur.row.(rnum/roff) = 16 Current row = 0x1FB0B144
Sstat = 0x1001 sridoff = 74 slocks = 1
smode = 0x0
Kept buffer @0x11765340
-----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
Kept buffer @0x1FB0A000
-----------------------
m_pageId = (1:3752) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 2 m_indexId = 0 m_prevPage = (1:183)
m_nextPage = (1:254) pminlen = 82 m_slotCnt = 20
m_freeCnt = 4340 m_freeData = 6388 m_reservedCnt = 0
m_lsn = (1253242:2441:2) m_xactReserved = 0 m_xactId = (0:81643698)
m_ghostRecCnt = 1 m_tornBits = 0
ec_buftrace.Index = 6
ec_buftrace.Entry [0]
---------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [1]
---------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [2]
---------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [3]
---------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [4]
---------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [5]
---------------------
bpage = 0x1FA46000 bhash = 0x00000000 bpageno = (1:1)
bdbid = 7 breferences = 36 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [6]
---------------------
bpage = 0x1FE12000 bhash = 0x00000000 bpageno = (1:665)
bdbid = 7 breferences = 1 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [7]
---------------------
bpage = 0x1FB04000 bhash = 0x00000000 bpageno = (1:315)
bdbid = 7 breferences = 263 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [8]
---------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [9]
---------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [10]
----------------------
bpage = 0x222FE000 bhash = 0x00000000 bpageno = (1:186)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [11]
----------------------
bpage = 0x222FC000 bhash = 0x00000000 bpageno = (1:114)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [12]
----------------------
bpage = 0x222F6000 bhash = 0x00000000 bpageno = (1:871)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [13]
----------------------
bpage = 0x222F4000 bhash = 0x117CAF00 bpageno = (1:377)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [14]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [15]
----------------------
bpage = 0x1F988000 bhash = 0x00000000 bpageno = (1:24)
bdbid = 7 breferences = 104 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [16]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [17]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [18]
----------------------
bpage = 0x1FB66000 bhash = 0x00000000 bpageno = (1:185)
bdbid = 7 breferences = 93 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [19]
----------------------
bpage = 0x222F2000 bhash = 0x117CAF40 bpageno = (1:378)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [20]
----------------------
bpage = 0x1FD2C000 bhash = 0x00000000 bpageno = (1:1168)
bdbid = 7 breferences = 2 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [21]
----------------------
bpage = 0x1FB66000 bhash = 0x00000000 bpageno = (1:185)
bdbid = 7 breferences = 93 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [22]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [23]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [24]
----------------------
bpage = 0x1F94E000 bhash = 0x00000000 bpageno = (1:6)
bdbid = 7 breferences = 1388 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [25]
----------------------
bpage = 0x1FB04000 bhash = 0x00000000 bpageno = (1:315)
bdbid = 7 breferences = 263 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [26]
----------------------
bpage = 0x1F94E000 bhash = 0x00000000 bpageno = (1:6)
bdbid = 7 breferences = 1388 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [27]
----------------------
bpage = 0x1FB04000 bhash = 0x00000000 bpageno = (1:315)
bdbid = 7 breferences = 263 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [28]
----------------------
bpage = 0x1F94E000 bhash = 0x00000000 bpageno = (1:6)
bdbid = 7 breferences = 1388 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [29]
----------------------
bpage = 0x1FB04000 bhash = 0x00000000 bpageno = (1:315)
bdbid = 7 breferences = 263 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [30]
----------------------
bpage = 0x1FA2E000 bhash = 0x00000000 bpageno = (1:14)
bdbid = 7 breferences = 647 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [31]
----------------------
bpage = 0x1FC56000 bhash = 0x00000000 bpageno = (1:274)
bdbid = 7 breferences = 169 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [32]
----------------------
bpage = 0x1F94E000 bhash = 0x00000000 bpageno = (1:6)
bdbid = 7 breferences = 1388 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [33]
----------------------
bpage = 0x1FB04000 bhash = 0x00000000 bpageno = (1:315)
bdbid = 7 breferences = 263 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [34]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [35]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [36]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [37]
----------------------
bpage = 0x1F988000 bhash = 0x00000000 bpageno = (1:24)
bdbid = 7 breferences = 104 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [38]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [39]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [40]
----------------------
bpage = 0x1F94E000 bhash = 0x00000000 bpageno = (1:6)
bdbid = 7 breferences = 1388 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [41]
----------------------
bpage = 0x1FB04000 bhash = 0x00000000 bpageno = (1:315)
bdbid = 7 breferences = 263 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [42]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [43]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [44]
----------------------
bpage = 0x222C8000 bhash = 0x00000000 bpageno = (1:3081)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [45]
----------------------
bpage = 0x222C4000 bhash = 0x00000000 bpageno = (1:2972)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [46]
----------------------
bpage = 0x222C2000 bhash = 0x00000000 bpageno = (1:3082)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [47]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [48]
----------------------
bpage = 0x1F988000 bhash = 0x00000000 bpageno = (1:24)
bdbid = 7 breferences = 104 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [49]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [50]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [51]
----------------------
bpage = 0x222BA000 bhash = 0x117E6A00 bpageno = (1:803416)
bdbid = 7 breferences = 4 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [52]
----------------------
bpage = 0x222BA000 bhash = 0x117E6A00 bpageno = (1:803416)
bdbid = 7 breferences = 4 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [53]
----------------------
bpage = 0x222BA000 bhash = 0x117E6A00 bpageno = (1:803416)
bdbid = 7 breferences = 4 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [54]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [55]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [56]
----------------------
bpage = 0x222B2000 bhash = 0x00000000 bpageno = (1:3083)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [57]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [58]
----------------------
bpage = 0x1F988000 bhash = 0x00000000 bpageno = (1:24)
bdbid = 7 breferences = 104 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [59]
----------------------
bpage = 0x1F990000 bhash = 0x00000000 bpageno = (1:13)
bdbid = 7 breferences = 356 bkeep = 0
bstat = 0x9 bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [60]
----------------------
bpage = 0x1FB0A000 bhash = 0x00000000 bpageno = (1:3752)
bdbid = 7 breferences = 72 bkeep = 10
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [61]
----------------------
bpage = 0x222BA000 bhash = 0x117E6A00 bpageno = (1:803416)
bdbid = 7 breferences = 4 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [62]
----------------------
bpage = 0x222AE000 bhash = 0x00000000 bpageno = (1:15160)
bdbid = 7 breferences = 0 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [63]
----------------------
bpage = 0x222BA000 bhash = 0x117E6A00 bpageno = (1:803416)
bdbid = 7 breferences = 4 bkeep = 0
bstat = 0xb bspin = 0 bnext = 0x00000000
EXCEPT (null) @0x305C8A2C
-------------------------
exc_number = 0 exc_severity = 0
exc_func = autostats_ex_shell+1a
-
Why not follow the directions specified?
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server 1792.842
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
---------
Alternatively, if you view the text error messages, it's the SQL Server of the old phone message:
"Your call could not be completed as dialed. Please hang up and try again"
What were you trying to accomplish? Is this a prod database? test? development? SS2k5? What OS?
- it is a process that makes select, update, insert, cursor and backup, not well that as of I am I generate the problem.this system is in production.Windows 2000 sp4SQL Server 7 sp 4this dump I generate a single time, but later whenever I want to do the sentences previously mentioned, the SQL Server consumes all the memory of the servant.
-
Your sysindexes table is corrupt. From the call stack in the dump, its failing trying to delete a statistics blob column in sysindexes. You should run DBCC CHECKDB to find out how bad the damage is and then restore from your backups. Did anything happen to the server before this error occured? (e.g. power loss, drive crash)
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005 -
I do not think anything is corrupt ... my guess is that you need more RAM
Memory
------
MemoryLoad = 98% TotalPhys = 255 MB AvailPhys = 2 MB
TotalPageFile = 1002 MB
Only 256 Mb for SQL Server ???
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply