FIX: ?? ???? ????? ??? ??? ???? ??? ????? ??? ????? ?????? ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 912885 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 420246 (SQLBUDT)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

???????

?? Microsoft SQL Server 2005 ?? ???? ????? ??? ??? ???? ??? ?????? ???????:
  • ????? ???? ?????? ?????? IGNORE_DUP_KEY ?????.
  • ????? ????? INSERT ????? ?? ???? ?? ??? ??????.
  • ??? ????? INSERT ??????.
  • ??? ????? ???? ??? ????? ???????? ?????? IGNORE_DUP_KEY ???????? ?????.
???????? ??? ???? ?? ???? ????? ??? ?????? ??????? ???????:
??? ??? ?? ???? ?? ????? ??????. ??????? ? ?? ????? ??? ?? ??? ?????.

????

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

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

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

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

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

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

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 ?? x 86-based ?????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Msvcp80.dll8.0.50727.42548,864?? ?????? ?????: 26x 86
Msvcr80.dll8.0.50727.42626,688?? ?????? ?????: 26x 86
Sqldiscoveryapi.dll2005.90.1518.0527,06421 ????? ????00: 11x 86
SQL Server 2005 x 64 ?????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Msvcp80.dll8.0.50727.421,097,728?? ?????? ????18: 46x 64
Msvcr80.dll8.0.50727.42822,784?? ?????? ????18: 46x 64
Sqldiscoveryapi.dll2005.90.1518.0745,68821 ????? ????04: 14x 64
SQL Server 2005 ??????? ???????? ??? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Msvcp80.dll8.0.50727.421,385,472?? ?????? ????18: 35IA-64
Msvcr80.dll8.0.50727.421,484,800?? ?????? ????18: 35IA-64
Sqldiscoveryapi.dll2005.90.1518.01,924,31221 ????? ????03: 30IA-64

???? ??????

??????? ?????? ??? ??? ??????? ???? ??????? ???????:
  1. ????? ????? INSERT ?????? ???? ??? ?????? ??????.
  2. ??? ?????? ????????? ?????? ??? ?????? ????? INSERT ?????. ????? ???? ????? ??????? ??? ???? ????? ????.
?????? ???? ?? ????? ????? ????? INSERT ?????? ???? ??? ??? ?????? "? ????? ??????? ??????? ??????? ??" ??????? ??????? "??????? ?????? ??? ??? ???????.

?????? ????? INSERT ?????? ???? ??? ??? ???? ???? ??????? ???????:
  1. ?? ??? ??? ????? "???? SQL" ? ??? ???? ???? ????? ??? ?????? ????.
  2. ?????? ?? ???? ????? ??? ??? ???? ???? ??????? ???? ??????? ??????.
  3. ????? ???? ??????? ?????? ???? ???? ??????? ???? ??????? ??????.

    ?????? ????? ??????? ????? INSERT ?????? ???? ??? ?????? ??????.
  4. ??? ????? ??????? ??? ????? INSERT ???? ???, ?? ???? ??? ????? INSERT ????? ??????. ??? ????? ??????? ??? ?????? INSERT ??????, ????? ?????? ???? ?????? ????? INSERT ?????:
    1. ?? SQL Server ???? ????? ??????? ? ????? ???? ????? ???? SQL Server 2005.
    2. ?? ????? ????? ??????? ?????????? ??? ??? ????? ??? ??? ????? ???????.

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

      ??? ??????? ????? ??? ?????? SQL ???????? ??? ??? ???? ??????? ???????? ??????? ??? ??? ????? TSQL:
      • SQL:BatchStarting
      • SQL:BatchCompleted
      • SQL:StmtStarting
      • SQL:StmtCompleted
      ??? ??????? ????? ??? ????? ???? ???? ??? ???? ??? ???? ??????? ???????? ??????? ??? ??? ????? ??????? ?????:
      • SP: ???
      • SP: ?????
      • SP:StmtStarting
      • SP:StmtCompleted
    3. ????? ?????? ??? ?? ????? ??????.

      ???? ??? ?????? ????? ????? ?????? ??????. ?? ????? ????? ????? INSERT ?????. ??? ????? ??????? ???? ?? ????? ??????.

      ??? ?? ??? ????? ???? SQL Server ????? Studio ?? ???? ?????? ?????? ??? ?????? ?? Studio ????? ???? SQL. ??? ???? ?? ?? ???? ??? ????? ????? ??? ??????? ?????? ???? ???? ???????. ???? ??? ?????? ??? SQL Server 2005 recompiles ????? INSERT ????? ?? ??????? ???????? ??? ????? ?????? ?? ?? ???? ??????? ?????? ??????.
    4. ????? ?????? ??? ?? ????? ????? ?????? ?????? ????? INSERT ?????. ?????? ????? INSERT ????? ????? SPID ???? ????? ??? ???? ? ???? ???? ????? ????? ??????. ??? ??? SPID ? ???? ????? INSERT ???? ???? ????????? ???????:
      • ??? ??? ????? ??????? INSERT.
      • ?? ??? ????? ??????? INSERT ???.
???? ?????? ????????? ?????? ??? ?????? ????? INSERT ????? ?????? ???? ????? ???????.

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

?????? ?????? ??? ??????? ??? ??? ????? ?????? ??? ????? INSERT ?????.

????? ????? OPTION (MAXDOP 1) ??? ???? ????? INSERT. ??????? ???? ?? ???? INSERT ???????.
INSERT INTO MyTable (Col1, Col2)
SELECT Col1, Col2 FROM OtherTable
OPTION (MAXDOP 1) 
????? ?? ????????? ??? ????? ????????? MAXDOP ???? ?????? "MAXDOP ???????" ??? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms181714.aspx

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

?????? ?????? ??? ??????? ??? ?? ????? ?? ?????? ????? INSERT ?????. ??? ???? ??????? ????? INSERT ????? ?? ????? ????. ??? ???? ?? ???? ????? ????? ????? ?????? ?? ?? ???? ????? ????? ????? ?????? ?????? ??????? OPTION (MAXDOP 1). ?? ?? ???? INSERT ????? ?? ????? ????. ??? ???? ??? ????? ??????? ??????. ?? ????? ????? ???????? ?? ??????? ??????.

?????? ??????? sp_create_plan_guide ????? ????? ????? INSERT ?????. ?? ???? ?????? ????? ??? ??????? OPTION (MAXDOP 1) ?? ????? INSERT ?????. ?????? ?????? ???? ?? ????? ??????? ??????? sp_create_plan_guide ?????.
sp_create_plan_guide @name = N'planguide_for_MyFailingProc', -- Arbitrary name
@stmt = N'INSERT INTO MyOneFailingStatementTable VALUES (@a,@b,@c)', -- The problematic INSERT statement
@type = N'OBJECT', @module_or_batch = N'dbo.MyFailingProc', -- The name of the stored procedure that contains the problematic INSERT statement
@params = NULL, @hints = N'OPTION (MAXDOP 1)'-- Query hint to prevent parallelism
????? ?? ????????? ??? ??????? sp_create_plan_guide ????? ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms179880.aspx

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

?????? ?????? ??? ??????? ??? ???? ??? ?????? ???????:
  • ????? ????? INSERT ????? ???? ????????.
  • ?? ???? ????? ????? INSERT ???? ??? ?????? ??????.
??? ???? ??? ??????? ???? ??????????? ??? ???? SQL Server 2005 ?????? ??? ???? ????? ????. ????? ?? ?????? ??? ???????. ?? ???? ??? ??????? ??? ???? ?????? ?????? ??? ????????? ?????? ???? ???? ??? ??????.

????? ?????? SQL ???????? ???????.
sp_configure 'show advanced options', 1;
GO

RECONFIGURE WITH OVERRIDE;
GO

sp_configure 'max degree of parallelism', 1;
GO

RECONFIGURE WITH OVERRIDE;
GO
?????? ??? ???? ?? ????????? ??? ???? ???? ???? parallelism ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms181007.aspx

?????

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

??????? ????

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

???????

???? ???????: 912885 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 3.5
????? ???
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems Community Technology Preview
????? ??????: 
kbmt kbautohotfix kbsql2005engine kbsql2005presp1fix kbhotfixserver kbfix kbbug kbsqlserv2005fix kbqfe kbpubtypekc KB912885 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????912885

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

 

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