?????: ????? ??????? ?????? ??? ??????? ???? ??? "???? ???????" system_health ??????? ??? ????? ???? ???? ??? ?? SQL Server 2008: "Msg 9436: ????? XML: ?? ????? ????? 54? 12? ??? ????? ????? ????? ???????"

?????? ????????? ?????? ?????????
???? ???????: 978629 - ??? ???????? ???? ????? ????? ??? ???????.
???? Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ???? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????. ???? ???? ??? ?? ????? ?????? Microsoft SQL Server 2008. ?? ????? ??????? system_health ????? ???? ??????? ??????? ????? ??????? ???? ???? ???. ?? ??? ?????????? ????? ????? ????? ???????:
Msg 9436 ?? ????? 16, ???? 1? ??? 1
????? XML: ?? ????? ????? 54? 12? ??? ????? ????? ????? ???????
??? ???? ??????? ????? ????? ????????? ?????? ?????? ????? buffer_ring ?? system_health ??? ???? ???? ???? ??? ???? ?????:
select XEventData.XEvent.value('(data/value)[1]', 'varchar(max)') as DeadlockGraph
FROM
(select CAST(target_data as xml) as TargetData
from sys.dm_xe_session_targets st
join sys.dm_xe_sessions s on s.address = st.event_session_address
where name = 'system_health') AS Data
CROSS APPLY TargetData.nodes ('//RingBufferTarget/event') AS XEventData (XEvent)
where XEventData.XEvent.value('@name', 'varchar(4000)') = 'xml_deadlock_report'
?? ??? ??????? ???? ????????? ??????? ???????.

??? ???? ????? ???? ????? ????????? ?????? ?????? ??? ????? ?? ???? ???? ??? ?????? XML:
select cast(XEventData.XEvent.value('(data/value)[1]', 'varchar(max)') as xml) as DeadlockGraph
FROM
(select CAST(target_data as xml) as TargetData
from sys.dm_xe_session_targets st
join sys.dm_xe_sessions s on s.address = st.event_session_address
where name = 'system_health') AS Data
CROSS APPLY TargetData.nodes ('//RingBufferTarget/event') AS XEventData (XEvent)
where XEventData.XEvent.value('@name', 'varchar(4000)') = 'xml_deadlock_report'
?? ??? ??????? ??? ????? ????? ??????? ???? ???? ??? ?? ????? XML. ??? ??? ?? ??? ????? ??????? ???? ???? ??? ???? ??? ????? ?? ???? ????? ?????? ?? ??????? xml_deadlock_report ????? XML ????. ??? ???? ????? ????? ????? ???????:
Msg 9436 ?? ????? 16, ???? 1? ??? 1
????? XML: ?? ????? ????? 54? 12? ??? ????? ????? ????? ???????

?????

???? ??? ??????? ??? ???? ???????? ???????? ???? ???? ???? XML ????? ??????? ???? ???? ??? ????? ??? ????? ????? ????? ???? ????. ???????? ??? ???? ???? ???? ??? ????? ??? ?????? ???? ???? ??? ????.

????

???? ????? ??????? ????? ???? ??????? ?? ??????? ???????? 6 ? SQL Server 2008 Service Pack 1. ????? ?? ????????? ??? ???? ??????? ????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
977443 ???? ??????? ???????? 6 ? SQL Server 2008 Service Pack 1
?????? ????? ???? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
970365 ???? SQL Server 2008 ???? ?? ??????? ??? ????? 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 2008 R2

??? ??? ????? ??? ??????? ??? ??? ???? ?????? SQL Server 2008 R2.

?? ????? ????? ??? ??????? ???? ??? ?? ??????? ???????? 1. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ????????? ? SQL Server 2008 R2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

981355 ???? ??????? ???????? 1 ????? ??????? SQL Server 2008 R2
?????? ????? ???? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? ?????? SQL Server 2008 R2 ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:

981356 ???? SQL Server 2008 R2 ???? ?? ??????? ??? ????? SQL Server 2008 R2

?????

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

?????

?????? ??? ????????? ??? "????? ????? ??????" ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
935897 ????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ???????? ???? ?? ??????? ????

????? ?? ????????? ??? ???? ??????? ???????? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499???? ????? ???? ???? ??????? ????? Microsoft SQL Server

????? ?? ????????? ??? ??????? ????? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684 ??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 978629 - ????? ??? ??????: 13/?? ??????/1432 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbexpertiseadvanced kbsurveynew kbqfe kbfix kbmt KB978629 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????978629

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

 

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