?? ????? ??????? ????? ????? ??? ???? ??????? ???? ????? ??????? ISA Server 2004 ?? ?? ISA Server ???? ???? ???? ????? ??? ????? ?????? MSDE

?????? ????????? ?????? ?????????
???? ???????: 909636 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

?? ????? ??????? ????? ????? ??? ????????? 2004 ???? ?????? ????? ????? (ISA) ?? ??????? ISA Server ???? ?? ?????? ?????? ??????? ??? ????? ?????? Microsoft SQL Server Desktop Engine (MSDE).

?????

?????? Microsoft SQL Server ??????? ??????? ???????? ?????? ??????? MSDE ????????? ?????????. ?? ????? SQL Server ?????? ??????? ??????? ????? ?? ??? ??? ??????? ??????? ?? ???????? ?????? ???? ??? ??????? ??? ?????????.

?????? ?? ???? ??? ?????? ?????? SQL Server ??? ??????? ??????? ???????? ?????? ??? ????????? ISA Server.

?????

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

??????? ????

??? ????? ?? ??? ?? ???? ??? ?????? ??? ??????? ??????? ???????? ??????, ?? ????? ??? ????? ????? ??????? ??????? ???? ?? ??????? ?? SQL Server. ??? ??? ????? ?????? ??? ?? ?????? ??????.
?? ??? ??????????? ??? ??????
????? ??????????? ??????
1 ???? ???????? ???? ?? 386
2 ???? ????512 ???? ????
3 ???? ????764 ????????
4 ???? ????1024 ???? ????
??? ???? ??? ?? ?????? ?????? ???? ??????? ? ??? SQL Server (Sql.log) ????? ISA Server ?????? ?? ??? ???? ???????. ??? ?????? ????? ?????? ??? ????????? ????????. ?????? ????? ???? ??????? ???????:
  1. ????? ???? ?????? ??????? ??????? ?? SQL Server. ?????? ????? ???? ??????? ???????:
    1. ?? ???? ???? ?????? ?? ???? ?? ??? ??????? ?? ?? ???? ????? ???????? ???? ".sql". ??? ???? ??????? ???? ????? ?? ? checksqlmemory.sql ?.
      ????????? ???????
      EXEC sp_configure '????? ???????? ??????' 1
      ????? ????? ?? ???????

      ????????? ???????
      sp_configure EXEC '????? ?????? ???? ?????? (MB)'

      ????????? ???????
      EXEC sp_configure '????? ???????? ??????' 0
      ????? ????? ?? ???????
    2. ?? ???? ???????? ???? ????? ??????:
      osql \msfw ServerComputerName -S -E -i Path \ checksqlmemory.sql
      ?????? ?? ??? ????? checksqlmemory.sql ?? ????? ???? ??? ??????? ?? ?????? ??????? ?? Path ?? ?????? ?????? ????? ???? ??? ??????? ?? ?????? ???????.
  2. ????? ????? ??????? ??????? ???? ?? ??????? ?? SQL Server. ?????? ????? ???? ??????? ???????:
    1. ?? ???? ???? ?????? ?? ???? ?? ??? ??????? ?? ?? ???? ????? ???????? ???? ".sql". ??? ???? ??????? ???? ????? ?? ? setchecksqlmemory.sql ?.
      ????????? ???????
      EXEC sp_configure '????? ???????? ??????' 1
      ????? ????? ?? ???????

      ????????? ???????
      sp_configure EXEC '???? ???? ?????? ???????? (MB)' MaxServerMemory
      ????? ????? ?? ???????

      ????????? ???????
      EXEC sp_configure '????? ???????? ??????' 0
      ????? ????? ?? ???????
      ?????? ?? ??? ??????? MaxServerMemory ?????? ?? ??????? ??????? ??????????? (MB) ???? ???? ?? ?????. ??? ???? ??????? ?????? MaxServerMemory ? 512 ?.
    2. ?? ???? ???????? ???? ????? ??????:
      osql \msfw ServerComputerName -S -E -i Path \ setchecksqlmemory.sql
      ?????? ?? ??? ????? setchecksqlmemory.sql ?? ????? ???? ??? ??????? ?? ?????? ??????? ?? ?????? ?? ?????? ?????? ????? ???? ??? ??????? ?? ?????? ???????.

    ?????? ?? ????? ????? ??????? ??????? ?????? ?? SQL Server ?????? ????? ??.
???? ??????? ??????? ??? ????? ??????? ????????? 512 ???? ????:
  1. ?????? ??? ???? ????????. ??? ???? ??????? ?? ?????? ????? SetMSDEmemory.bat.
  2. ?? ???? ???? ?????? ???? ???? ??? ??? ??? ??????? ?? ?????. ?? ?? ?????? ??? ???? ?? ???? ????? PAUSE:
    osql -S %computername%\MSFW -E -Q "exec sp_configure 'show advanced options',1 reconfigure with override exec sp_configure 'max server memory (MB)',512 reconfigure with override" 
    PAUSE
  3. ?? ?????? ?????? ??? ???? ISA ??????.
  4. ????? ??? ????. ??? ??? ???? ????? ??? ???:
    ????? DBCC ?????
    ????? ???? ??????? '????? ?????? ???? ?????? (MB)' ?? 204754 ??? 256.
    ?????? ??? ??? DBCC ????? ????? ????? ? ???? ??? ????? ???????? PSS ?????? ??? ??????? ??? ????? ??????? ?? ?? ??????? ??????? ????????.
  5. ???? ?? ????? ??????? command shell.

???????

???? ???????: 909636 - ????? ??? ??????: 23/???/1430 - ??????: 4.0
????? ???
  • Microsoft Internet Security and Acceleration Server 2004 Standard Edition
  • Microsoft Internet Security and Acceleration Server 2004 Enterprise Edition
  • Microsoft Internet Security and Acceleration Server 2006 Enterprise Edition
  • Microsoft Internet Security and Acceleration Server 2006 Standard Edition
????? ??????: 
kbmt kbhowto kbtshoot kbprb KB909636 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????909636

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

 

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