FIX: ??? ???? ????? ??? ????? ?????? ???? SQL Server 2012 ??? ???? ??????? ?????? NUMA

???? ???????: 2688697 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
???? Microsoft ?????? ??????? ? Microsoft SQL Server 2012 ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???????? ???? ?? ????? ??????? SQL Server 2012 ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????????? ??????. ????? ????? ???? Microsoft SQL Server 2012 ??? ??????? ???? ?????? ??????? ??? uniform ?????? (NUMA)? ??????? SQL Server ?????? ?? ??????? ????????. ?? ??? ?????????? ?? ????? ??? ???? ?????. ??? ???? ??????? ?? ??? ????? ??? 701 ??????? ?? ??? ??? ??? SQL Server:
<Date><Time><spid id=""> </spid></Time></Date>???: 701? ?????: ???? 17,: 123.
<Date><Time><spid id=""></spid></Time></Date>???? ????? ????? ?????? ??? ?????????.
??? ??????? ???? ???? ??? ????? ?????? ???? ????????? ??????? ?????? ?? ???? ???? ????? ?? ????? ?????? ???????? ?? ??????? SQL Server. ??? ??? ??????? SQL Server ???? ?? ??????? ?? ????? ?? ??? ????? ????? NUMA.
???? ??? ?????? | ????? ???????

?????

???? ??? ??????? ??? ?????? ????????? ????? ????? ??????? ???????? ????? ????? ?? ???? ???? ????.
???? ??? ?????? | ????? ???????

????

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

SQL Server 2012

???? ????? ??????? ????? ???? ??????? ?? ??????? ???????? 1 ???? 2012 ?? ???? SQL. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2679368
(http://support.microsoft.com/kb/2679368/ )
??????? ???????? 1 ? SQL Server 2012
?????? ??? ???????? ???????, ?? ????? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???????? ???? ?? ????? ??????? SQL Server ???????. ???? ???? ???????? ????? ???? ?? ??????? ????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2692828
(http://support.microsoft.com/kb/2692828/ )
????? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012
???? ??? ?????? | ????? ???????

??????? ????

?????? ?? ????? ??????? ????????? ?????? ???? ????? ???????:
  • ????????? ?? ??? ????? ????????? sys.dm_os_memory_nodes (???). ?????? ??? ???? ?? ????????? ??? sys.dm_os_memory_nodes ???? ?? ?????? ???? msdn ??? ??? ??????:
    ??????? ???? ??? sys.dm_os_memory_nodes ???
    (http://msdn.microsoft.com/en-us/library/bb510622.aspx)
  • ????? ??????? ??????? ?? ???? ?? ????? ???? ??????? ?? ??? ??? SQL Server ??? ???? ??? 701:
    DBCC memorystatus
  • ??? ?????? ????? ???? ??????? (???? ????) ?? ???? "????? ????" ?? SQL Server ??? 2012. ????? ?? ????????? ??? ?????? "?????? ???????"? ?? ?????? ???? msdn ??? ??? ??????:
    ??????? ???? ??? ?????? "?????? ???????"
    (http://msdn.microsoft.com/en-us/library/ff929156(v=sql.110).aspx)
???? ??? ?????? | ????? ???????

?????

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

???????

???? ???????: 2688697 - ????? ??? ??????: 20/????? ??????/1433 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
????? ??????: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew kbmt KB2688697 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2688697
(http://support.microsoft.com/kb/2688697/en-us/ )
???? ??? ?????? | ????? ???????

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

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