????? ????? ????-??-??????? ?? SQL Server 2012

?????? ????????? ?????? ?????????
???? ???????: 2769594 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

?? ????? Microsoft SQL Server 2012 ??? ????? ???? ????? ???? ???? ?????? ??????. ?? ??? ??????? ??? ??????? ???? ??????? MEMORYCLERK_SQLLOGPOOL ???? ??????? ???? ??? ????????? ?????? ?????? ??? ????????. ??? ???? ??????? ?????? ???? ???????_SQLLOGPOOL ????????????????? ?????? ??? ????????? ???????:
  • AlwaysOn ????? ????????? ??? ??????? ?? ????? ????????? ????????
  • ?????? ??? ????? ??????? ??? ????? ????????? ????? ????????

???? ?? ?????? ??? ??????? ??? ?????? ??? ????????? ???? ??? ?????? ??? ???? SQL server ???? ?????? ?????? ?? ????? ????? ????????. ??? ???? ??? ???????? ??? ????? ????? ??? ?????? ??? ??? ?? ??? ??? SQL:
??? ?? ????? ???????: FAIL_PAGE_ALLOCATION 8
???: 701, ???????: ???? 17?: 107.
???? ????? ????? ?? ???? ??????? '????????' ?????? ??? ?????????.
???: 701, ???????: ???? 17?: 123.
???? ????? ????? ?? ???? ????? '???????' ?????? ??? ?????????.
???: 701, ???????: ???? 17?: 107. (Params:. ??? ????? ????? ?? ??? ????? ???? ??? ??? ????? ???????. ????? ?? ?????????? ??? ???? ETW? ????????? ???.
???: 17312? ???????: ???? 16?: 1.
SQL Server ??? ????? ???? ?????? ?? ????? "???? ????" ???? ????? ?? ??? ????? ?????? (????? ?????? 1).
??? ??? ????? AppDomain 3181 (<appdomain>) ?????? ??????? ???? ??? ???????.
?? ????? ????? AppDomain 3181 (<appdomain>).
???: 9602, ???????: ???? 16?: 1.
??? ??? ????? ???? ???? ?? ??? ????? 28709? 19 ????.
???: 17300? ???????: ???? 16?: 1.
SQL Server ??? ??? ???? ??? ????? ???? ???? ????? ???? ??? ???? ??? ????? ??????? ?? ??? ????? ????? ?????? ???? ?????? ??????? ?? ?? ??????. ???? ?? ?? ?????? ????? ??? ????? ?????. ??????? sp_configure ?? ???? '??????? ????????' ?????? ?? ???? ?????? ???? ????????? ???????? ??????? ???. ?????? sys.dm_exec_sessions ?????? ?? ????? ?????? ?? ???????? ??? ?? ??? ?????? ????????.
???: 17312? ???????: ???? 16?: 1.
SQL Server ??? ????? ???? ?????? ?? ????? "???? ????" ???? ????? ?? ??? ????? ?????? (????? ?????? 1).
???: 18054? ???????: ???? 16?: 1.</appdomain></appdomain>
????? ?????? ???? SQL Server ????? ?????? ???? ????? ?? ?????? ????? AlwaysOn ???? SQL? ?? ???? ?????? ???????? ??? ????? ?????????. ?????? ??? ???????? ????? ????? ??? ??? ????? SQL Server.

??? ???? ???? ????-??-???????? ????? ?????? ?? ???? ??? ??? ?????? ????????? ????? ????????? ??????? ????????? ???????? ??????? ?? ????? ????? ??????? ??? ??? ????? ?????? ?????? ???????. ?????? ????? ?? ???? ?? ?? ?? ?? ???? ??? ??????? ????? ????? ???????? ?? ??? ???????? ???? ?? ???? ??? ????? ??????? ??? ??? ????? ????? ???? SQL ?????? ??? ???? ???????.

????? ????? DBCC MEMORYSTATUS ?????? ????? ???? ????? ?????? ?? ??????? ?????? ?? ???? ???? ?? ??????? ??? ????????? ?????? ???? ??????? MEMORYCLERK_SQLLOGPOOL . ?? ??? ???? ??? ?????:
MEMORYCLERK_SQLLOGPOOL (?????? 0) ?. ????
---------------------------------------- -----------
VM ?????? 0
VM ?????? 0
????? ????? ????? 0
SM ?????? 0
SM ?????? 0
????? ????? 823544
????? ???? ?????? ??? ????? ??????? ??????? ?? ???? ????? ??????????? DMV ???????:
SELECT * FROM sys.dm_os_memory_clerks WHERE type='MEMORYCLERK_SQLLOGPOOL'
SELECT type, name, pages_in_bytes/ 1024 AS PMO_KB FROM sys.dm_os_memory_objects WHERE type like 'MEMOBJ_LOGPOOL%'
???? ????? ???? ?? ?? SQL Server ????????? ???? ?? ????? RESOURCE_SEMAPHORE waittype ??? ???? ????? ?????? ?? ???? ?????? ??? ????? ???? ????? ?????? ?? ?????????? "??? ????".

??? ??????? ?????? ??? ?? ???????? ???????:
  • ??? ????? ???? ?????? ?? ???? ??????? ahead ???????? ???? ??? ????????? ?????? ???? ??? ??? ????????? ????????? ?????? AlwaysOn ????? ????? ????? ??? ???????? ?? SQL Server ??? 2012.
  • ????? ???? ???? ??? ?? ??????? ????????? ??????? SQL Server ????? ???? ??? ???????? ??? ???????? ?? ??? ????-??-??????? ????? ????.

????

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

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

???? ???? ??????? ????? ???? ??????? ????? ?? 2 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2012 SP1? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2790947 ???? ??????? ???????? 2 ? SQL Server 2012 Service Pack 1
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2012 SP1. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2772858 ???? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012 ?????? service Pack 1

??????? ???????? 5 ? SQL Server 2012

???? ???? ??????? ????? ???? ??????? ????? ?? 5 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ? SQL Server 2012? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2777772 ???? ??????? ???????? 5 ? SQL Server 2012
?????? ??? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ????? ???? ??????? ?????? ???? ?? ??????? ?? ??????? SQL Server 2012. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2692828 ???? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012

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

????? ????? ???? ????? ?? Microsoft. ??? ???? ??????? ??? ????????? ??????? ?????? ??????? ??????? ?? ??? ??????? ???. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????.

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

?????? ?? ???? ???? ????? ?????? ?? ??? ??????? ??? ??? ?????? ?? ???? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ??? ????? ????? ?? ????? ?????? ???? ??????? ? Microsoft ?????? ?? ?????? ??? ???? ?????? ????? ??? ???? Microsoft ?????? ??? ???:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ?? ????? ????? ???? ???? ?????.

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

??? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????.

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

?????? ??? ??????? ??????? ??? ?? ???? ???? SQL Server 2012 ?????.

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

???? ??????? ??????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????? ??????) ???????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? UTC ???????? ??????? ?????? ??????? ??????? ????? ??????? ?? ??????? ?????? ?????? ?? "???? ??????".
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????????
Sqlmin.dll2011.110.2387.032,460,27219 ?????? 201205:25x 64
Sqlservr.exe2011.110.2387.0190,94419 ?????? 201205:01x 64
Sqlmin.dll2011.110.2387.026,515,93619 ?????? 201205:22x 86
Sqlservr.exe2011.110.2387.0160,22419 ?????? 201205:17x 86

???????

???? ???????: 2769594 - ????? ??? ??????: 12/???? ?????/1434 - ??????: 3.0
????? ???
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
????? ??????: 
kbtshoot kbautohotfix kbqfe kbhotfixserver kbfix kbexpertiseadvanced kbsurveynew kbmt KB2769594 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2769594

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

 

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