??? ????: "SqlDumpExceptionHandler: ????????? <spid>??????? ????? ????? c0000005 EXCEPTION_ACCESS_VIOLATION." SQL Server 2012 ???, SQL Server 2008 ???, SQL Server 2008 R2 ??? ?? SQL Server 2005 ??? ??? ?????? ????? ??? ??????</spid>

???? ?????? ???? ??????
???? ID: 972936 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Microsoft Microsoft SQL Server 2008 ??????? ?? ??????? ???? ????? ????? ?? ??? ??? ?????? ???? ??? ??????? ????? ???? ???, ??????? ??? ?????????? ?? ?? ???? ?? ?? ?? ????? SQL Server 2008 ?? ??? ????? ?? ??? ??????? ???????? ?????? ??? ?????
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

Microsoft SQL Server 2012, Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2 ??? ?? Microsoft SQL Server 2005 ???, ?? ????? ??????? ??????? ???? ??, sys.dm_os_waiting_tasks ???????? ??????? ????? ?? ?????? ???? ?? SQL Server ????????? ????? ?? ???? ???

??? ??????????, ?????? ??? ???????? ???? ?????? ??????, ???? PSSDIAG sys.dm_os_waiting_tasks ????? ?????? ???? ?? ???? ???

?? ?? ?????? ???? ??, ?? mini-dump ????? SQL ????? ??? ??????? ??? ??????? ???? ??? ??? ??, ?????? ????? ?? ????? ?? ???? ????? SQL ????? ?????? ??? ????? ??? ??? ?? ???:
?????? ??? SPID ?? ????? ???? ??? 'dbghelp.dll' ??????? '4.0.5'
?????? ??? SPID *** ????? ???? ?? ??? ???? ?? ??? ???<Log file="" path="">
?????? ??? SPID SqlDumpExceptionHandler: ????? ????? <spid>????????? ??????? c0000005 EXCEPTION_ACCESS_VIOLATION. SQL ????? ?? ????????? ?? ??? ?? ??? ???
?????? ??? SPID *
*******************************************************************************
?????? ??? SPID *
?????? ??? SPID * ??????? ????? ????:
?????? ??? SPID * ?????? ??? SPID
?????? ??? SPID *
?????? ??? SPID *
?????? ??? SPID * ????? ??? 0000000113DFDB00 Module(UNKNOWN+0000000000000000) =
?????? ??? SPID * ????? ??? c0000005 EXCEPTION_ACCESS_VIOLATION =
?????? ??? SPID * ??? 0000000113DFDB00 ???? ????? ??????? ???????
?????? ??? SPID * ????? ???? 37 ?????? -
?????? ??? SPID * 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
?????? ??? SPID *?? & J1 01 00 00 00 ff ff 0 c 00 02 00 00 00 26 04 04 4a 31 04
?????? ??? SPID * 00
?????? ??? SPID *
?????? ??? SPID *
?????? ??? SPID * ??????? ???? END ????
?????? ??? SPID * sqlservr 0000000001000000 0000000007AE3FFF 06ae4000
?????? ??? SPID * ntdll 0000000077B30000 0000000077CCFFFF 001a0000
?????? ??? SPID * kernel32 0000000076E10000 0000000076FFFFFF 001f0000. .
?????? ??? SPID * StFIR: 0000000000000000:
?????? ??? SPID * StFDR: 0000000000000000:
Date Time SPID * *******************************************************************************
?????? ??? SPID *
-------------------------------------------------------------------------------
?????? ??? SPID 0000000113DFDB00 Module(UNKNOWN+0000000000000000)
?????? ??? SPID 0000000002F74640 Module(sqlservr+0000000001F74640)
?????? ??? SPID ????? ????????? ???? ?? ??? ?? 0x0000000164592CC6
?????? ??? SPID ????? ???? ????????? ???? ??? 0x20000001. ????? ???? ????????? ??? ????????? ?????? ?????? ??? SPID ??????: 17311, ???????: 16, ??????: 1?
?????? ??? SPID SQL Server ????? ????? c0000005 ?? ???? ??? ?? ??? ??? ??????? Win32 ?? C++ ????? ?????? ?? ????? ???????? ?? ????? ??? ?? ????? ??????? ???? ?? ?????? ?? ???? ?? ?? ???? ??? ???? ?? ??????? ????? ????? ?? ????? ?? ??? SQL ?????? ??? ?? ???? ????? ?? ????? SQL ????? ?? ???? ???? ?? ??? ????? ???? ??? ?? ?????? ?? ???????????? ???? ?? ???, ?? ?? (SQLAgent ???????? ????: ???? ?? ??? ????????? ??) ????? ???????? ?????
?????? ??? SPID SQL ????? ????? ??? ???? ?? ???? ???? ??? ??? ID ?? ??? ????? = '1' ??? ?? ???? ?? ??????? ????? ????? ??; ??? ?????????? ?????? ?? ???????? ???? ???
?????? ??? ????? ??????: 17188, ???????: 16, ??????: 1?
?????? ??? ????? SQL Server ?? ??????? ??????? ???? ?? ????, ??????? ?? ??? ?? ??? ??? ??????? ??? ???? ??? ??? [???????: <IP address="">] </IP></spid></Log>
?? ????? ???????? ?? ????? ?? ?? ???? ??:
  • Sys.dm_os_wait_stats ?? ??????? ????? ???? ?? ??? ?????? ?? ????? ??????? ????? ??? ??????? ?????? ???? ???? ???? ????????? ?? ?? ??????? ???? ????? ?????? ????? ???? ???? ?? ?? ???? ?????? ????? ?? ?????? ?? ???? ???
  • ???? ???????? ?? ??????? sys.dm_os_wait_stats ????? DEADLOCK_ENUM_MUTEX ????????? ?????? ?? ???????? ??? ?? ????????? ???? ?? ??? ????? ?? ???? ???

????????

????? ?????? ???????

SQL Server 2012 ?? ??? ????? ?????? 6

?? ?????? ?? ??? ????? ????? ?????? 6 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ????? ?? ??? SQL Server 2012 ??????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
2728897 SQL Server 2012 ?? ??? ????? ?????? ????? 6
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2012 ?? ??? ????? ?? ??? ??????? ???????? ?????? ??? ????? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ???? ???? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2692828 SQL Server 2012 ?? ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? SQL Server 2012 ????? ??

SQL Server 2008 R2 SP2 ?? ??? ????? ?????? 5

?? ?????? ?? ??? ????? ????? ?????? 5 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? SQL Server 2008 R2 SP 2 ?? ??? ??????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
2797460 SQL Server 2008 R2 ?????? ??? 2 ?? ??? ????? ?????? ?????? 5
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 R2 SP 2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ??? ????? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ???? ???? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2730301 SQL Server 2008 R2 SQL Server 2008 R2 ?????? ??? 2 ?? ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ????? ??

SQL Server 2012 SP1 ?? ??? ????? ?????? 2

?? ?????? ?? ??? ????? ???? ????? ?????? 2 ??? ?????? ???? ??? ??? ?? ????? ?????? ????? ?? ??? SQL Server 2012 SP1 ??????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
2790947 SQL Server 2012 ?????? ??? 1 ?? ??? ????? ?????? ????? 2
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2012 SP1 ?? ??? ????? ?? ??? ??????? ???????? ?????? ??? ????? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ???? ???? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
2772858 SQL Server 2012 ????? ?? ?? SQL Server 2012 ?????? ??? 1 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ??

SQL Server 2008 R2 ?????? ??? 1 ?? ??? ????? ?????? ?????? 10

?? ?????? ?? ??? ????? ????? ?????? 10 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? SQL Server 2008 R2 SP1 ?? ??? ??????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
2783135 SQL Server 2008 R2 SP1 ?? ??? ????? ?????? ?????? 10
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 R2 SP1 ?? ??? ????? ?? ??? ??????? ???????? ?????? ??? ????? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ???? ???? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2567616 SQL Server 2008 R2 SQL Server 2008 R2 ?????? ??? 1 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ????? ??

SQL Server 2008

?? ?????? ?? ??? ????? ???? ????? ?????? 4 ??? SQL Server 2008 ?????? ??? 1 ?? ??? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
973602 SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? ?????? 4
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 ?? ??? ????? ?? ??? ??????? ???????? ?????? ??? ????? ??? ?? ?????? ?? ???????? ????? ?????? ????? ?????? ???? ????? ?? Microsoft ??????? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
970365 SQL Server 2008 ?? SQL Server 2008 ?????? ??? 1 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ????? ??
Microsoft SQL Server 2008 ?????????? ??????? SQL Server ?????? ??? ?? ??? ???? ???? ???? ?? ???? SQL Server 2008 ?????? ??? 1 ?? ??????? ???? ?? ??? SQL Server 2008 ?????? ??? 1 ???????? ???? ???? ?????? ???????? ??? ??, ???? SQL Server ?????? ??? ??? ?????? ?? ?? ???? ?? ???????? ???? SQL Server ?????? ??? ??? ????? ???

SQL ????? 2005

?? ?????? ?? ??? ????? ???? ????? ?????? 9 ??? SQL Server 2005 ?????? ??? 3 ?? ??? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
980176 SQL ????? 2005 ???? ??? 3 ?? ??? ????? ?????? ?????? 9
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL ????? 2005 ?? ??? ????? ?? ??? ??????? ???????? ?????? ??? ????? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ???? ???? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
960598 SQL ????? 2005 ?? SQL ????? 2005 ???? ??? 3 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ????? ??
Microsoft SQL Server 2005 ?????????? ??????? SQL Server ?????? ??? ?? ??? ???? ???? ???? SQL ????? 2005 ???? ??? 3 ?? ??????? ???? ?? ??? ?? SQL ????? 2005 ???? ??? 3 ???????? ???? ???? ?????? ???????? ??? ??, ???? SQL Server ?????? ??? ??? ?????? ?? ?? ???? ?? ???????? ???? SQL Server ?????? ??? ??? ????? ???

??????

Microsoft ?? ?????? ?? ?? ?? ?? "?? ?? ????" ?????? ??? ???????? Microsoft ???????? ??? ?? ?????? ???

??????

???? ??? ???? ??????? ?? ??? ????????? ????? ???? SQL ????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
935897?? ????????? ????? ???? ?????????? ??????? ?? ?? ???????? ?? ??? ?????? ???? ?? ??? SQL Server ??? ?? ?????? ???? ??
SQL ????? ???????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
822499Microsoft SQL ????? ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?????????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
824684 Microsoft ?????????? ???????? ?? ????? ???? ??? ???????? ???? ???? ???? ?????? ?? ?????

???

???? ID: 972936 - ????? ???????: 18 ????? 2013 - ??????: 3.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2005 Service Pack 3
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • SQL Server 2012 Enterprise Core
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
??????: 
kbsurveynew kbexpertiseadvanced kbqfe kbfix kbmt KB972936 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:972936

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com