????? ????? FIX: ?? ??? SQL Server Errorlog ??? ???? ?????? ? ???? ????? ????? ????????? ??????? ????? ???? ?????? ?? ??????? ??????? ?? ??????? ?????? ?? SQL Server 2005: "???? ????? ????? ?????? ??? ?????????"

?????? ????????? ?????? ?????????
???? ???????: 942661 - ??? ???????? ???? ????? ????? ??? ???????.
???: # 50001692 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

?? Microsoft SQL Server 2005 ????? ????????? ??????? ????? ???? ?????? ?? ??????? ??????? ?? ?????? ?? ???? ?????????. ??? ???? ?????? ? ???? ????? ????? ??? ????????? ??????? ? ?? ??? ????? ????? ??? ?????? ??????? ?? ??? Errorlog ???? SQL:
Date Time SPID ??? ????? ?????: FAIL_PAGE_ALLOCATION 1
Date Time SPID 701 ???: ???????: ???? 17 ?: 193.
Date Time SPID ???? ????? ????? ?????? ??? ?????????.

????

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 4. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
941450???? ??????? ???????? 4 SQL Server 2005 ?????? ????? ?????? SP2
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2
??? ????? ????????? ??????? Microsoft SQL Server 2005 ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2005 ?????? ????? ?????? SP2 ??? ????? SQL Server 2005 ?????? ????? ?????? SP2. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

?????

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

??????? ????

?????? ??? ???? ?? ????????? ??? ????? ?? ?? ??????? ? ?????? ??? ??????? ??? ??? ??????? ????? ?????? ???? ??????? ???????? ???? ????? ??? ??????? ?????? ?????? ?? ????? "????? ??????? ?? Microsoft" ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
941450???? ??????? ???????? 4 SQL Server 2005 ?????? ????? ?????? SP2

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

  1. ????? ????? ???? ???????:
    USE tempdb;
    GO
    CREATE PROCEDURE dbo.use_memory
    AS
    BEGIN
        CREATE TABLE #a(a INT);
        CREATE TABLE #b(b INT);
        CREATE TABLE #c(c INT);
        DECLARE @a TABLE(a INT);
        DROP TABLE #a,#b,#c;
    END
    GO
    
  2. ????? ??????? ?????? 50 ??? ???? SQL Server 2005. ??? ????? 3 ??????? ???????? ?? ????? ????? ??? ??????
  3. ??? ?? ????? ???? ?????? ????? ??????? ???????: tempdb
    USE tempdb;
    GO
    DECLARE @i INT;
    SET @i = 1;
    -- note that depending on your hardware and
    -- specific memory pressure in your environment,
    -- the upper bound might be higher than 1000
    WHILE @i <= 1000
    BEGIN
        EXEC dbo.use_memory;
        SET @i = @i + 1;
    END
    GO
    

?????

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ???? ?????? Service Pack 2 ?????? ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005
????? ?? ????????? ??? ??????? ??????? ?????????? ?? SQL Server 2005 ?????? ????? ?????? SP2 ?? ?????? ???? Microsoft ?????? ??? ?????:
http://go.microsoft.com/fwlink/?LinkId=71711
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 942661 - ????? ??? ??????: 19/???/1429 - ??????: 6.2
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
????? ??????: 
kbmt kbsql2005engine kbhotfixrollup kbfix kbpubtypekc kbqfe kbexpertiseadvanced KB942661 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????942661

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

 

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