FIX: ???? ?????? ????? ?????? ?????? ???? SQL Server ? ?? ???? ????? ???? SQL ?? ???? Microsoft SQL Server 2008 ????? ???? ?????? ??? ???????

?????? ????????? ?????? ?????????
???? ???????: 975027 - ??? ???????? ???? ????? ????? ??? ???????.
Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

???????

?? ???? ???? ?????? Microsoft SQL Server 2008 ???? SQL Server ????? ?????? ?????? ??? ???? ????? ???? ??? ??????. ???????? ??? ???? ??? ????? ???? ?????? ??? "????? ?????" ? ????? ????? ????? ???? SQL Server. ??? ????? ??? ????? ????? ??? ?????? ??????? ?? ??? ???? Windows:

[RES] SQL Server < SQL Server (SQL1) >: [sqsrvres] SvcStop: ????? ????? ????? ????? ??? ????.
[RHS] RhsCall::DeadlockMonitor: ?????? TERMINATERESOURCE ???? ?????? '???? SQL (SQL1)'.
[RHS] ???? ???? ??? ?????? SQL Server (SQL1) ??????. ??????? ??????? ??????? ? ????? RHS terminaiting
00001858.00003154:: ???? Date Time WARN [RHS] ????? SQL Server IsAlive ?????.
00001bfc.000041a4:: HandleMonitorReply INFO [RCM] Time Date : FAILURENOTIFICATION 'SQL Server' ? ??????? gen(0) 1.
00001bfc.000041a4:: ProcessingFailure--> TransitionToState(SQL Server) INFO Time [RCM] Date ??? ??????.
00001bfc.000069d8:: Date Time ??? rcm::RcmResource::HandleFailure [RCM]: (SQL Server)
00001bfc.000069d8:: Date Time INFO [RCM] ?????? SQL Server: ??? ???? ?????: 1, restartAction: 2.
00001bfc.000069d8:: Date Time INFO [RCM] ???? ????? ????? ?????? ?? 500 ???? ?????.
00001bfc.000069d8:: ProcessingFailure TransitionToState INFO Time [RCM] (SQL Server) Date --> [????? ??? DelayRestartingResource].
00001bfc.000069d8:: rcm::RcmGroup::ProcessStateChange INFO [RCM] Time Date : (SQL Server (MSSQLSERVER) ? ????--> ?????)
00001bfc.000069d8:: TransitionToState(SQL Server Agent) INFO Date Time [RCM] ?????--> [????? ??? OnlineCallIssued].
00001bfc.000087fc:: ????? ????? ?????? '???? ???? SQL' Date Time INFO [RCM].
00001858.00008f58:: Date Time ??? ???? SQL [RES] < SQL Server >: [sqsrvres] CheckQueryProcessorAlive: ??? sqlexecdirect
00001858.00008f58:: Date Time ??? ???? SQL [RES] < SQL Server >: printODBCError [sqsrvres]: sqlstate = HYT00; ????? ?????? = 0; ??????? = ?
00001858.00008f58:: Date Time INFO [RES] SQL Server < SQL Server >: [sqsrvres] OnlineThread: ????????? ?????? ????? ?????? QP.
00001858.00001924:: Date Time ??? RhsCall::DeadlockMonitor [RHS]: ???? ??????? TERMINATERESOURCE ????? SQL Server.
00001858.00001924:: Date Time ??? ?????? ?? [RHS] ????? SQL Server ???? ???? ???. ????? ??????? ??????? ? terminaiting ????? RHS.
00001bfc.0000e7dc:: HandleMonitorReply INFO [RCM] Time Date : FAILURENOTIFICATION 'SQL Server' ? ??????? gen(1) 4.
00001bfc.0000e7dc:: rcm::RcmResource::HandleMonitorReply INFO [RCM] Time Date : ????? SQL Server ??? ???? ????? ????????? 1.
00001bfc.0000e7dc:: Date Time ??? rcm::RcmMonitor::RecoverProcess [RCM]: ????? ?????? ??????? 0x1858.
00001bfc.0000e7dc:: Date Time ??????? INFO [RCM] ???? ????? ????? 28164 / 0x6e04
00006e04.0000e8a4:: ????? Date Time INFO [RHS].
00001bfc.0000e7dc:: rcm::RcmResource::ReattachToMonitorProcess INFO [RCM] Time Date : (???? SQL [????? ??? DelayRestartingResource])
00001bfc.0000e7dc:: ????? TransitionToState INFO Time [RCM] "Date " (SQL Server)--> OpenCallIssued.
00001bfc.00004878:: Date INFO Time [RCM] TransitionToState (SQL Server) [????? ??? DelayRestartingResource]--> DelayRestartingResource.
00001bfc.00004878:: ???? SQL ????? - ????? INFO [RCM] Date Time "?" ?? ??????? ??????.
00001bfc.00004878:: DelayRestartingResource TransitionToState INFO Time [RCM] (SQL Server) Date --> OnlineCallIssued.
00001bfc.0000e7dc:: HandleMonitorReply INFO [RCM] Time Date : ONLINERESOURCE 'SQL Server' ? ??????? gen(1) 997.
00001bfc.0000e7dc:: OnlineCallIssued TransitionToState INFO Time [RCM] (SQL Server) Date --> OnlinePending.
00006e04.00003478:: ????? ???? Date Time INFO [RHS] ????? SQL Server ??? ??????. RHS ??? ????? ???? ??????? ??? RCM

?????

????? ????? ???? ???? ???????? ???? ???? SQL Server ? ???? ???? ???????? ?????? ????????? IsAlive. ??? ??? ????????? IsAlive ???? ???? ???? ???????? recycles ????? Rhs.exe ???? ?????? ????? .dll ????? SQL Server. ????? .dll ????? SQL Server ????? ????? ????? ????? SQL Server. ??? ????? ????? ??????? SQL Server ????? ????? ?????? ?? ??????? DeadlockTimeout ? ?? ???? ????? ?????? ????? ?????? "Stop." ????? ??? ???? ?????? "??? ??? ????? ????? ???? SQL Server.

????

???? ????? SQL Server 2008

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

?? ????? ??????? ????? ???? ??????? ????? ?? 7 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
973601???? ??????? ???????? 7 SQL Server 2008
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008

SQL Server 2008 ?????? ????? ?????? Service Pack 1

??? ??? ????? ??? ??????? ??? ??? ?????? SQL Server 2008 ?????? ????? ?????? Service Pack 1.

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 5 ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1. ????? ?? ????????? ??? ???? ??????? ???????? ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
975977???? ??????? ???????? 5 SQL Server 2008 ?????? ????? ?????? Service Pack 1
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? 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 ???????.

?????

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

?????

????? ?? ????????? ??? ??????? PendingTimeout ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn.microsoft.com/en-us/library/aa372194(VS.85).aspx


????? ?? ????????? ??? ??????? DeadlockTimeout ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn.microsoft.com/en-us/library/bb309217(VS.85).aspx

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


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


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

???????

???? ???????: 975027 - ????? ??? ??????: 14/?? ??????/1430 - ??????: 3.1
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
????? ??????: 
kbmt kbsurveynew kbfix kbqfe kbexpertiseadvanced KB975027 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????975027

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

 

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