Dumpfiles

Question

Dumpfiles

ramana3327

SSCoach

Points: 19722
More actions
June 22, 2015 at 6:26 am

#301784

What are the reasons for dumpfiles in sql server?
All databases have no corruption when I ran DBCC checkdb (system & user dbs) but there were dumpfiles
SqlDumpExceptionHandler: Process 9999 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
what are the main reasons for acess violation dumpfiles?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

To allow for someone with the knowledge and tools to identify the cause of the access violation (memory-related error). Typically that someone is from Customer Support as they have access to the private symbols and tools to allow them to read the stack dumps.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ramana3327 SSCoach Points: 19722 More actions · Answer 2

Exception Address = 00000000777E105C Module(ntdll+000000000005105C)

2015-06-17 13:59:18.56 Server * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

2015-06-17 13:59:18.56 Server * Access Violation occurred reading address 000001700C248BC8

2015-06-17 13:59:18.56 Server *

2015-06-17 13:59:18.56 Server * MODULE BASE END SIZE

2015-06-17 13:59:18.56 Server * sqlservr 0000000000680000 0000000004291FFF 03c12000

2015-06-17 13:59:18.56 Server * ntdll 0000000077790000 0000000077937FFF 001a8000

2015-06-17 13:59:18.56 Server * kernel32 0000000077090000 00000000771AEFFF 0011f000

2015-06-17 13:59:18.56 Server * KERNELBASE 000007FEFDF10000 000007FEFDF7BFFF 0006c000

2015-06-17 13:59:18.56 Server * ADVAPI32 000007FEFF9C0000 000007FEFFA9AFFF 000db000

2015-06-17 13:59:18.56 Server * msvcrt 000007FEFF1E0000 000007FEFF27EFFF 0009f000

2015-06-17 13:59:18.56 Server * sechost 000007FEFF390000 000007FEFF3AEFFF 0001f000

2015-06-17 13:59:18.56 Server * RPCRT4 000007FEFF890000 000007FEFF9BCFFF 0012d000

2015-06-17 13:59:18.56 Server * MSVCR80 0000000074D70000 0000000074E38FFF 000c9000

2015-06-17 13:59:18.56 Server * MSVCP80 00000000749E0000 0000000074AE8FFF 00109000

2015-06-17 13:59:18.56 Server * sqlos 0000000074900000 0000000074906FFF 00007000

2015-06-17 13:59:18.56 Server * Secur32 000007FEFD890000 000007FEFD89AFFF 0000b000

2015-06-17 13:59:18.56 Server * SSPICLI 000007FEFDA50000 000007FEFDA74FFF 00025000

2015-06-17 13:59:18.56 Server * pdh 000007FEF7690000 000007FEF76DDFFF 0004e000

2015-06-17 13:59:18.56 Server * SHLWAPI 000007FEFE1C0000 000007FEFE230FFF 00071000

2015-06-17 13:59:18.56 Server * GDI32 000007FEFF3B0000 000007FEFF416FFF 00067000

2015-06-17 13:59:18.56 Server * USER32 0000000077690000 0000000077789FFF 000fa000

2015-06-17 13:59:18.56 Server * LPK 000007FEFF590000 000007FEFF59DFFF 0000e000

2015-06-17 13:59:18.56 Server * USP10 000007FEFF420000 000007FEFF4E8FFF 000c9000

2015-06-17 13:59:18.56 Server * USERENV 000007FEFCF80000 000007FEFCF9DFFF 0001e000

2015-06-17 13:59:18.56 Server * profapi 000007FEFDBF0000 000007FEFDBFEFFF 0000f000

2015-06-17 13:59:18.56 Server * WINMM 000007FEF7650000 000007FEF768AFFF 0003b000

2015-06-17 13:59:18.56 Server * IPHLPAPI 000007FEFB450000 000007FEFB476FFF 00027000

2015-06-17 13:59:18.56 Server * NSI 000007FEFE2F0000 000007FEFE2F7FFF 00008000

2015-06-17 13:59:18.56 Server * WINNSI 000007FEFB440000 000007FEFB44AFFF 0000b000

2015-06-17 13:59:18.56 Server * opends60 0000000074930000 0000000074937FFF 00008000

2015-06-17 13:59:18.56 Server * NETAPI32 000007FEFB0B0000 000007FEFB0C5FFF 00016000

2015-06-17 13:59:18.56 Server * netutils 000007FEFB0A0000 000007FEFB0ABFFF 0000c000

2015-06-17 13:59:18.56 Server * srvcli 000007FEFD720000 000007FEFD742FFF 00023000

2015-06-17 13:59:18.56 Server * wkscli 000007FEFB080000 000007FEFB094FFF 00015000

2015-06-17 13:59:18.56 Server * LOGONCLI 000007FEFD250000 000007FEFD27FFFF 00030000

2015-06-17 13:59:18.56 Server * SAMCLI 000007FEFA8F0000 000007FEFA903FFF 00014000

2015-06-17 13:59:18.56 Server * BatchParser 00000000748D0000 00000000748FCFFF 0002d000

2015-06-17 13:59:18.56 Server * IMM32 000007FEFE300000 000007FEFE32DFFF 0002e000

2015-06-17 13:59:18.56 Server * MSCTF 000007FEFF280000 000007FEFF388FFF 00109000

2015-06-17 13:59:18.56 Server * psapi 0000000077960000 0000000077966FFF 00007000

2015-06-17 13:59:18.56 Server * instapi10 0000000074940000 000000007494CFFF 0000d000

2015-06-17 13:59:18.56 Server * cscapi 000007FEF7620000 000007FEF762EFFF 0000f000

2015-06-17 13:59:18.56 Server * sqlevn70 0000000058700000 0000000058903FFF 00204000

2015-06-17 13:59:18.56 Server * ntmarta 000007FEFCD10000 000007FEFCD3CFFF 0002d000

2015-06-17 13:59:18.56 Server * WLDAP32 000007FEFE290000 000007FEFE2E1FFF 00052000

2015-06-17 13:59:18.56 Server * CRYPTSP 000007FEFD470000 000007FEFD487FFF 00018000

2015-06-17 13:59:18.56 Server * rsaenh 000007FEFD120000 000007FEFD166FFF 00047000

2015-06-17 13:59:18.56 Server * CRYPTBASE 000007FEFDAE0000 000007FEFDAEEFFF 0000f000

2015-06-17 13:59:18.56 Server * BROWCLI 000007FEF0A00000 000007FEF0A11FFF 00012000

2015-06-17 13:59:18.56 Server * AUTHZ 000007FEFD610000 000007FEFD63EFFF 0002f000

2015-06-17 13:59:18.56 Server * MSCOREE 000007FEFA4F0000 000007FEFA55EFFF 0006f000

2015-06-17 13:59:18.56 Server * mscoreei 000007FEFA270000 000007FEFA30CFFF 0009d000

2015-06-17 13:59:18.56 Server * ole32 000007FEFF680000 000007FEFF882FFF 00203000

2015-06-17 13:59:18.56 Server * credssp 000007FEFD180000 000007FEFD189FFF 0000a000

2015-06-17 13:59:18.56 Server * msv1_0 000007FEFD410000 000007FEFD461FFF 00052000

2015-06-17 13:59:18.56 Server * cryptdll 000007FEFD700000 000007FEFD713FFF 00014000

2015-06-17 13:59:18.56 Server * kerberos 000007FEFD490000 000007FEFD547FFF 000b8000

2015-06-17 13:59:18.56 Server * MSASN1 000007FEFDC90000 000007FEFDC9EFFF 0000f000

2015-06-17 13:59:18.56 Server * schannel 000007FEFD1F0000 000007FEFD246FFF 00057000

2015-06-17 13:59:18.56 Server * CRYPT32 000007FEFDD40000 000007FEFDEACFFF 0016d000

2015-06-17 13:59:18.56 Server * security 00000000746B0000 00000000746B2FFF 00003000

2015-06-17 13:59:18.56 Server * WS2_32 000007FEFE240000 000007FEFE28CFFF 0004d000

2015-06-17 13:59:18.56 Server * SHELL32 000007FEFE450000 000007FEFF1D8FFF 00d89000

2015-06-17 13:59:18.56 Server * OLEAUT32 000007FEFF5A0000 000007FEFF676FFF 000d7000

2015-06-17 13:59:18.56 Server * ftimport 0000000060000000 0000000060024FFF 00025000

2015-06-17 13:59:18.56 Server * MSFTE 0000000049980000 0000000049D2DFFF 003ae000

2015-06-17 13:59:18.56 Server * VERSION 000007FEFCF70000 000007FEFCF7BFFF 0000c000

2015-06-17 13:59:18.56 Server * dbghelp 0000000074770000 00000000748CDFFF 0015e000

2015-06-17 13:59:18.56 Server * WINTRUST 000007FEFDF80000 000007FEFDFBAFFF 0003b000

2015-06-17 13:59:18.56 Server * ncrypt 000007FEFD5C0000 000007FEFD60FFFF 00050000

2015-06-17 13:59:18.56 Server * bcrypt 000007FEFD650000 000007FEFD671FFF 00022000

2015-06-17 13:59:18.56 Server * mswsock 000007FEFD2E0000 000007FEFD334FFF 00055000

2015-06-17 13:59:18.56 Server * wship6 000007FEFD640000 000007FEFD646FFF 00007000

2015-06-17 13:59:18.56 Server * wshtcpip 000007FEFD020000 000007FEFD026FFF 00007000

2015-06-17 13:59:18.56 Server * ntdsapi 000007FEF00E0000 000007FEF0106FFF 00027000

2015-06-17 13:59:18.56 Server *

2015-06-17 13:59:18.56 Server * P1Home: 000000006264E3A0: 00000000C0000005 0000000000000000 00000000777E105C 0000000000000002 0000000000000000 000001700C248BC8

2015-06-17 13:59:18.56 Server * P2Home: 000000006264DEB0: 000000006264E3A0 000000006264DEB0 0000001000000000 0000000000000000 0000000000000000 00000000006FB20E

2015-06-17 13:59:18.56 Server * P3Home: 0000001000000000: 0100A20000040101 004C000100402AD8 004B000100402ADA 1F29004101BE851D 0000000100402AD9 0009B7A600113B51

2015-06-17 13:59:18.56 Server * P4Home: 0000000000000000:

2015-06-17 13:59:18.56 Server * P5Home: 0000000000000000:

2015-06-17 13:59:18.56 Server * P6Home: 00000000006FB20E: 909090C368C48348 8B48909090909090 40894C20488944C4 4889481050894818 5541544157565308 B0EC814857415641

2015-06-17 13:59:18.56 Server * ContextFlags: 000000000010001F: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000

2015-06-17 13:59:18.56 Server * MxCsr: 0000000000001FA0:

2015-06-17 13:59:18.56 Server * SegCs: 0000000000000033:

2015-06-17 13:59:18.56 Server * SegDs: 000000000000002B:

2015-06-17 13:59:18.56 Server * SegEs: 000000000000002B:

2015-06-17 13:59:18.56 Server * SegFs: 0000000000000053:

2015-06-17 13:59:18.56 Server * SegGs: 000000000000002B:

2015-06-17 13:59:18.56 Server * SegSs: 000000000000002B:

2015-06-17 13:59:18.56 Server * EFlags: 0000000000010206: 0000778C50300000 0000FFFFFFFF0000 0000000000000000 0000000000000000 000000000FA00000 0000000000000000

2015-06-17 13:59:18.56 Server * Rax: 0000000000000002:

2015-06-17 13:59:18.56 Server * Rcx: 000000FFFFFFFFFF:

2015-06-17 13:59:18.56 Server * Rdx: 0000000000000000:

2015-06-17 13:59:18.56 Server * Rbx: 000001700C248BC0:

2015-06-17 13:59:18.56 Server * Rsp: 000000006264E470: 00000000005BD7D0 00000000005BD7E0 00000000005BD7E0 0000000000000004 000007FEFDA6B544 000007FEFDA69B00

2015-06-17 13:59:18.56 Server * Rbp: 0000000052046EE0: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 6048102B0008E89F 0000000000000002

2015-06-17 13:59:18.56 Server * Rsi: 0000000000000000:

2015-06-17 13:59:18.56 Server * Rdi: 0000000000000000:

2015-06-17 13:59:18.56 Server * R8: 0000000052046ED0: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000

2015-06-17 13:59:18.56 Server * R9: 000007FEFF897930: ACB0850F00507983 C300000001B80004 548B480001F59BE8 D88B480A8B482024 4C89482024448D48 8D48084189482024

2015-06-17 13:59:18.56 Server * R10: 000007FEFDA69B00: 11C91CEB8A885D04 6048102B0008E89F 0000000000000002 000007FEFDA6B5A0 000007FEFDA69BC2 000007FEFDA69BA0

2015-06-17 13:59:18.56 Server * R11: 0000000052046EE0: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 6048102B0008E89F 0000000000000002

2015-06-17 13:59:18.56 Server * R12: 0000000000500000: 0000000000000000 01004041ABD59520 00000000FFEEFFEE 00000000197D0018 0000000000500128 0000000000500000

2015-06-17 13:59:18.56 Server * R13: 000000000059B900: 000007FEFF97F550 0001000089ABCDEF 000000000000000A 0000000000000000 0000000000000000 0000000100000005

2015-06-17 13:59:18.56 Server * R14: 000000006264EA00: 000000000059B900 0000000000000000 0000000000000000 0000000600000000 000007FEFDA690D0 000007FEFDA6B540

2015-06-17 13:59:18.56 Server * R15: 00000000005BD7D0: 0000000052046EE0 000000000059A440 0000000000000001 0000000000000000 0000000000000000 0000000000000000

2015-06-17 13:59:18.56 Server * Rip: 00000000777E105C: 0001BD49087B8B48 BE49000000010000 FFFFFFFF00007FFF 708841800F40C641 0FFFFF0000BF410E 8D4B105B8B4C001F

2015-06-17 13:59:18.56 Server * *******************************************************************************

2015-06-17 13:59:18.56 Server * -------------------------------------------------------------------------------

2015-06-17 13:59:18.56 Server * Short Stack Dump

2015-06-17 13:59:18.57 Server 00000000777E105C Module(ntdll+000000000005105C)

2015-06-17 13:59:18.57 Server 000007FEFF8C6D1F Module(RPCRT4+0000000000036D1F)

2015-06-17 13:59:18.57 Server 000007FEFF8C69BE Module(RPCRT4+00000000000369BE)

2015-06-17 13:59:18.57 Server 000007FEFF8D6C2B Module(RPCRT4+0000000000046C2B)

2015-06-17 13:59:18.57 Server 000007FEFF96C883 Module(RPCRT4+00000000000DC883)

2015-06-17 13:59:18.57 Server 000007FEFF96CBBB Module(RPCRT4+00000000000DCBBB)

2015-06-17 13:59:18.57 Server 000007FEFF96CF25 Module(RPCRT4+00000000000DCF25)

2015-06-17 13:59:18.57 Server 000007FEFDA54619 Module(SSPICLI+0000000000004619)

2015-06-17 13:59:18.57 Server 000007FEFDA5587C Module(SSPICLI+000000000000587C)

2015-06-17 13:59:18.57 Server 000007FEFDA55AA8 Module(SSPICLI+0000000000005AA8)

2015-06-17 13:59:18.57 Server 0000000000AFDB62 Module(sqlservr+000000000047DB62)

2015-06-17 13:59:18.57 Server 0000000000AFEBC5 Module(sqlservr+000000000047EBC5)

2015-06-17 13:59:18.57 Server 00000000007525C3 Module(sqlservr+00000000000D25C3)

2015-06-17 13:59:18.57 Server 00000000007480B6 Module(sqlservr+00000000000C80B6)

2015-06-17 13:59:18.57 Server 0000000000747F5A Module(sqlservr+00000000000C7F5A)

2015-06-17 13:59:18.57 Server 0000000000ACC82E Module(sqlservr+000000000044C82E)

2015-06-17 13:59:18.57 Server 0000000000ACD0DB Module(sqlservr+000000000044D0DB)

2015-06-17 13:59:18.58 Server 0000000000ACD2B1 Module(sqlservr+000000000044D2B1)

2015-06-17 13:59:18.58 Server 0000000000A8A6AD Module(sqlservr+000000000040A6AD)

2015-06-17 13:59:18.58 Server 000000000068EF4C Module(sqlservr+000000000000EF4C)

2015-06-17 13:59:18.58 Server 000000000068ED26 Module(sqlservr+000000000000ED26)

2015-06-17 13:59:18.58 Server 000000000068EB6B Module(sqlservr+000000000000EB6B)

2015-06-17 13:59:18.58 Server 00000000007EE216 Module(sqlservr+000000000016E216)

2015-06-17 13:59:18.58 Server 00000000007EE445 Module(sqlservr+000000000016E445)

2015-06-17 13:59:18.58 Server 00000000007EDB79 Module(sqlservr+000000000016DB79)

2015-06-17 13:59:18.58 Server 00000000007EEF8A Module(sqlservr+000000000016EF8A)

2015-06-17 13:59:18.58 Server 0000000074D737D7 Module(MSVCR80+00000000000037D7)

2015-06-17 13:59:18.58 Server 0000000074D73894 Module(MSVCR80+0000000000003894)

2015-06-17 13:59:18.58 Server 00000000770A59CD Module(kernel32+00000000000159CD)

2015-06-17 13:59:18.58 Server 00000000777BB891 Module(ntdll+000000000002B891)

2015-06-17 13:59:18.58 Server Stack Signature for the dump is 0x0000000131C2207E

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Yup, that's a stackdump triggered by an access violation.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ramana3327 SSCoach Points: 19722 More actions · Answer 4

Thanks you so much for your time.

I didn't understand fully. Please give me some more detailed explanation.

What are the access violations means? Is there any relation to this violations and resource bottlenecks?

Access violations means completely related to permissions

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

https://www.google.com/?gq=What+is+an+access+violation

First result I get is an MSDN blog post explaining what an access violation is.

And no, nothing to do with resource contention. It's a severe error relating to illegal memory accesses.

It also has nothing to do with permissions.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ramana3327 SSCoach Points: 19722 More actions · Answer 6

Thanks you.

We are not update with service packs. We are planning to apply the latest service pack. I hope it will solve the problem