FIX: ???? ???? ????? ?????? federated ?? ????????? ??? ????? ????????? ?????? ??? ???? ??????? ????? ????????? ?????? ???? NUMA ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 944902 - ??? ???????? ???? ????? ????? ??? ???????.
???: # 50002030 (??????? ?????? SQL)
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

???? ??? ????????? ??????. ??? ???? ??????? ????? ????????? ????? ???? ?? ???? ???? ?? Microsoft SQL Server 2005 ???? ?????? ??????? ??? uniform ????? ?????? (NUMA). ????? ??? ??????? ???? ????? ?????? federated. ?? ??? ?????????? ??? ????? ????????? ?????? ?? ???? ??????? ???? ???????? ???????? ????? ??? 100 ???????. ???????? ??? ???? ????? ???? ????? ???????? federated ?? ?????????. ??? ??? ?????? ??????? ??????? ??? ??? ?????? ???? ????????? ??? ?? ??? ?? ???? ?????? wait_type ?? ?????? ?? ????? CMEMTHREAD.
select * from sys.dm_exec_requests

????

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

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

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

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

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

?????? ??? ??????? ??????? ??? ?? ???? ???? SQL Server 2005 ?????? ????? ?????? SP2 ?????. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005? x 64-based ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.3208.088,08808 ?????? ????21: 47x 64
Chsbrkr.dll12.0.7822.01,694,05622 ????? ????10: 51x 64
Chtbrkr.dll12.0.7822.06,109,03222 ????? ????10: 51x 64
Databasemailprotocols.dll9.0.3208.046,10408 ?????? ????21: 47x 86
Distrib.exe2005.90.3208.086,55208 ?????? ????21: 47x 64
Dts.dll2005.90.3208.01,892,88808 ?????? ????21: 47x 64
Dtsconn.dll2005.90.3208.0408,08808 ?????? ????21: 47x 64
Dtspipeline.dll2005.90.3208.01,065,49608 ?????? ????21: 47x 64
Fteref.dll12.0.7822.0433,15222 ????? ????10: 51x 64
Infosoft.dll12.0.7822.0621,41622 ????? ????10: 51x 64
Instorcl.sql??? ???? ???????153,779????? ?????? ????13: 18??? ???? ???????
Korwbrkr.dll12.0.7822.0101,73622 ????? ????10: 51x 64
Langwrbk.dll12.0.7822.0236,90422 ????? ????10: 51x 64
Mergetxt.dll2005.90.3208.037,91208 ?????? ????21: 47x 64
Microsoft.analysisservices.dll9.0.3208.01,217,56008 ?????? ????20: 31x 86
Microsoft.sqlserver.connectioninfo.dll9.0.3208.0156,69608 ?????? ????21: 47x 86
Microsoft.sqlserver.dtstransferprovider.dll9.0.3208.0115,73608 ?????? ????21: 47x 86
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3208.0295,96008 ?????? ????20: 31x 86
Microsoft.sqlserver.replication.dll2005.90.3208.01,832,98408 ?????? ????21: 47x 64
Microsoft.sqlserver.servicebrokerenum.dll9.0.3208.042,00808 ?????? ????21: 47x 86
Microsoft.sqlserver.smo.dll9.0.3208.01,606,68008 ?????? ????21: 47x 86
Microsoft.sqlserver.smoenum.dll9.0.3208.0222,23208 ?????? ????21: 47x 86
Microsoft.sqlserver.sqlenum.dll9.0.3208.0898,07208 ?????? ????21: 47x 86
Msfte.dll12.0.7822.03,808,10422 ????? ????10: 51x 64
Msftefd.exe12.0.7822.099,17622 ????? ????10: 51x 64
Msftepxy.dll12.0.7822.0127,33622 ????? ????10: 51x 64
Msftesql.exe12.0.7822.0158,56822 ????? ????10: 51x 64
Msir5jp.dll5.0.2130.03,421,54422 ????? ????10: 51x 64
Mssqlsystemresource.ldf??? ???? ???????524,28808 ?????? ????17: 19??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,239,10408 ?????? ????17: 19??? ???? ???????
Nlhtml.dll12.0.7822.0191,84822 ????? ????10: 51x 64
Nls400.dll5.0.4217.014,101,35222 ????? ????10: 51x 64
Odsole70.dll2005.90.3208.090,13608 ?????? ??????: ??x 64
Osql.exe2005.90.3208.085,52808 ?????? ??????: ??x 64
Query9x.dll12.0.7822.068,45622 ????? ????10: 51x 64
Rdistcom.dll2005.90.3208.0828,44008 ?????? ??????: ??x 64
Replmerg.exe2005.90.3208.0417,30408 ?????? ??????: ??x 64
Replprov.dll2005.90.3208.0747,03208 ?????? ??????: ??x 64
Replrec.dll2005.90.3208.01,012,24808 ?????? ??????: ??x 64
Sac.exe9.0.3208.082,96808 ?????? ????20: 26x 86
Sbmsmdlocal.dll9.0.3208.015,955,99208 ?????? ????20: 31x 86
Sqlaccess.dll2005.90.3208.0357,40008 ?????? ??????: ??x 86
Sqladhlp.exe2005.90.3208.066,07208 ?????? ??????: ??x 64
Sqlagent90.exe2005.90.3208.0429,08008 ?????? ??????: ??x 64
Sqlbrowser.exe2005.90.3208.0242,71208 ?????? ????20: 26x 86
Sqlcmd.exe2005.90.3208.0338,45608 ?????? ??????: ??x 64
Sqldiag.exe2005.90.3208.01,247,76808 ?????? ??????: ??x 64
Sqldumper.exe2005.90.3208.068,63208 ?????? ????20: 26x 86
Sqldumper.exe2005.90.3208.083,99208 ?????? ??????: ??x 64
Sqlmaint.exe2005.90.3208.092,69608 ?????? ??????: ??x 64
Sqlsac.exe2005.90.3208.01,246,23208 ?????? ????20: 26x 86
Sqlservr.exe2005.90.3208.039,596,56808 ?????? ??????: ??x 64
Sqlsqm.exe9.0.3208.0128,02408 ?????? ????20: 26x 86
Sqlsqm.exe9.0.3208.0128,02408 ?????? ??????: ??x 86
Sqlwep.dll2005.90.3208.090,64808 ?????? ????20: 26x 86
Sqlwep.dll2005.90.3208.0123,41608 ?????? ??????: ??x 64
Sqlwtsn.exe9.0.3208.099,35208 ?????? ????20: 26x 86
Sqlwtsn.exe9.0.3208.099,35208 ?????? ??????: ??x 86
Sqsrvres.dll2005.90.3208.082,96808 ?????? ??????: ??x 64
Ssradd.dll2005.90.3208.050,71208 ?????? ??????: ??x 64
Ssravg.dll2005.90.3208.051,73608 ?????? ??????: ??x 64
Ssrmax.dll2005.90.3208.048,15208 ?????? ??????: ??x 64
Ssrmin.dll2005.90.3208.048,15208 ?????? ??????: ??x 64
Ssrpub.dll2005.90.3208.034,84008 ?????? ??????: ??x 64
Sysdbupg.sql??? ???? ???????510,622?? ????? ????04: 40??? ???? ???????
Tablediff.exe9.0.3208.087,06408 ?????? ??????: ??x 86
Thawbrkr.dll12.0.7822.0209,76822 ????? ????10: 51x 64
Xmlfilt.dll12.0.7822.0271,20822 ????? ????10: 51x 64
Xpadsi90.exe2005.90.3208.069,14408 ?????? ??????: ??x 64
Xpstar90.dll2005.90.3208.0549,91208 ?????? ??????: ??x 64

?????

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

??????? ????

?? ????? ??? ??????? ?????? ???????? ?? 5 ???? ??????? ???????? ?? SQL Server 2005 ?????? ????? ?????? SP2. ???? 5 ???? ??????? ???????? ????? ???? ?????? ????? 8048. ??? ?? ????? ?? ?? ??? ??????? ?? ???? ????? ??? ??????? ?????? ????? ?????? ??????? ????? ???? ???????? 8048 ??? ??? ??????? ??? ????? 5 ???? ??????? ????????. ????? ????? ????? ???? ???????? ??? ??? ????? ???? SQL Server. ????? ???? ???????? 8048 ????? ???? ???????? ??????? ???? ??? ????? ?????? ???? NUMA ??? ?????? ??????? ????? ?????? CPU. ????? ???? ???????? 8048 ????? ????? ?? ??? ???????? CMEMTHREAD ??? ??????? ??????? (SMP) ????? ??? ?????? ?? ????? ???????? ???????? (CPU) ?? ??? ??????? NUMA ????? ??? ????? ???????? ???????? (CPU) ?????? ?? ??? ?? ????.

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

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

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

???????

???? ???????: 944902 - ????? ??? ??????: 03/?? ?????/1428 - ??????: 2.2
????? ???
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
????? ??????: 
kbmt kbautohotfix kbsql2005engine kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB944902 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????944902

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

 

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