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

???? ???????: 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.

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

??? ???? ??? ???????? ??? ????? ??? mini-dump ?? ???? ????? SQL Server. ???????? ??? ???? ??? ????? ????? ??? ?????? ??? ??? ?? ??? ??? ??? SQL Server:
??????? "????? SPID ????????" 'dbghelp.dll' ????? '4.0.5'
??????? ????? SPID * * * "????? ??????" ??? ??????? ???<Log file="" path="">
??????? ????? SPID ????????????????????????: ????? <spid>???? ?? ??????? ???????? ???? c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server ??? ????? ??? ???????.
??????? ????? SPID *
*******************************************************************************
??????? ????? SPID *
??????? ????? SPID * ????? ?????? BEGIN:
??????? ????? 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 ? 02 00 00 00 00 26 04 04 4a 31 04
??????? ????? SPID * 00
??????? ????? SPID *
??????? ????? SPID *
??????? ????? SPID * ??? ??????? ????? ?????? ???????
??????? ????? 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 Server ?????? ???????. ???????? ?? ??? ?????? ?? ?????? ????? ?????? (?? ?? ??? ????? SQLAgent ????? ??????? ????????).
??????? ????? SPID ???? SQL ????? ???? ????? ????? ??????. ???? ?????? = '1'. ??? ????? ??????? ???; ????? ?? ????? ?? ????????.
????? ??? ????? ?????? ???: 17188? ???????: ???? 16?: 1.
????? ??? ????? ???? SQL Server ?? ???? ????????? ???????? ????? ???? ??? ????? ?????. ??? ?? ????? ???????. [??????: <IP address="">] </IP></spid></Log>
???? ?? ????? ??????? ???????:
  • ??????? ???? ??? ??????? ?? sys.dm_os_wait_stats ????? ?????? ????. ???? ?? ???? ???? ??? ??? ?? ?????? ??? ??? "?????? ??????" ?? ?? ???? ??? ???????? ????????? ?? ??? "????? ?????? ????????".
  • ?? ???? ?????? ??????????? ???? ??? ??????? ?? sys.dm_os_wait_stats ??? ???????? ??? ??? ??? ???? ??? ??? ???????? DEADLOCK_ENUM_MUTEX.
???? ??? ?????? | ????? ???????

????

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

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

??? ????? ??????? ????? ???? ??????? ???? ??? ?? 6 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2012? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2728897
(http://support.microsoft.com/kb/2728897/ )
???? ??????? ???????? 6 ? SQL Server 2012
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2012. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2692828
(http://support.microsoft.com/kb/2692828 / )
???? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012

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

???? ???? ??????? ????? ???? ??????? ????? ?? 5 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2008 R2 SP 2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2797460
(http://support.microsoft.com/kb/2797460/ )
???? ??????? ???????? 5 ? SQL Server 2008 R2 Service Pack 2
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ?????? SQL Server 2008 R2 2 ???? ?????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2730301
(http://support.microsoft.com/kb/2730301/ )
???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2008 R2 ?????? service Pack 2

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

???? ???? ??????? ????? ???? ??????? ????? ?? 2 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2012 ???? ?????? SP1? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2790947
(http://support.microsoft.com/kb/2790947/ )
???? ??????? ???????? 2 ? SQL Server 2012 Service Pack 1
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2012 SP1. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2772858
(http://support.microsoft.com/kb/2772858/ )
???? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012 ?????? service Pack 1

???? ??????? ???????? 10 ? SQL Server 2008 R2 ?????? service Pack 1

??? ????? ??????? ????? ???? ??????? ???? ??? ?? 10 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2008 R2 SP1? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2783135
(http://support.microsoft.com/kb/2783135/ )
???? ??????? ???????? 10 ? SQL Server 2008 R2 SP1
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ?????? SQL Server 2008 R2 SP1. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2567616
(http://support.microsoft.com/kb/2567616/ )
???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2008 R2 ?????? service Pack 1

SQL Server 2008

???? ???? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 4 ? SQL Server 2008 Service Pack 1. ????? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
973602
(http://support.microsoft.com/kb/973602/LN/ )
???? ??????? ???????? 4 ? SQL Server 2008 Service Pack 1
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? Microsoft ??????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
970365
(http://support.microsoft.com/kb/970365/LN/ )
???? 2008 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2008 ?????? service Pack 1
??? ????? Microsoft SQL Server 2008 ????????? ??????? ???? ?????? SQL Server ?????. ??? ????? ????? ???? SQL Server 2008 ?????? service Pack 1 ?????? ? SQL Server 2008 Service Pack 1. ???? ???????? ??? ????? ?? ????????? ???????? ???? ?? ??????? ?? ???? ???? SQL Server ?? ???? ???? SQL Server ???????.

SQL Server 2005

???? ???? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 9 ? SQL Server 2005 ?????? service Pack 3. ????? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
980176
(http://support.microsoft.com/kb/980176/LN/ )
???? ??????? ???????? 9 ? SQL Server 2005 ???? ?????? 3
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
960598
(http://support.microsoft.com/kb/960598/LN/ )
???? 2005 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2005 ?????? service Pack 3
??? ????? Microsoft SQL Server 2005 ????????? ??????? ???? ?????? SQL Server ?????. ??? ????? ????? ???? SQL Server 2005 ?????? service Pack 3 ?????? SQL Server 2005 ?????? service Pack 3. ???? ???????? ??? ????? ?? ????????? ???????? ???? ?? ??????? ?? ???? ???? SQL Server ?? ???? ???? SQL Server ???????.
???? ??? ?????? | ????? ???????

?????

?? ????? Microsoft ?? ??? ?? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".
???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ??? "????? ????? ??????" ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
935897
(http://support.microsoft.com/kb/935897/ )
????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
????? ?? ????????? ??? ???? ??????? ???????? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499
(http://support.microsoft.com/kb/822499/ )
???? ????? ???? ???? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684
(http://support.microsoft.com/kb/824684/ )
??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft
???? ??? ?????? | ????? ???????

???????

???? ???????: 972936 - ????? ??? ??????: 08/???? ??????/1434 - ??????: 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 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????972936
(http://support.microsoft.com/kb/972936/en-us/ )
???? ??? ?????? | ????? ???????

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

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