?? ?? ????? ????? ?????? ????? ????? ???? ???? ??? ???? ?? ????? ???????? ?? SQL Server

?????? ????????? ?????? ?????????
???? ???????: 316749 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

?? ?? ????? ????? ??????? ???????? ???????? ????? ?? ????? Microsoft SQL Server ??? ???? ???? ?????? ??????? ?????? ??? ????? SQL Server ????????? ??? ?????:
  • ?????? ?? ????? ??? ? ???????? ?? ???? ?? RAM.
  • ???? ??? ???? ?? ????? ?????? ??? ?????? (??? ???? ??????? ???? ?? 500).
  • ??? ????? ???? ????? ???????? (??? ???? ??????? ????? ???????? ?? ??? ???? "????? ???").
  • ???? ????? ?????????? ?????? ???? ?????? ??? ??????? ???? ?????? ????? worker SQL Server 255.
?? ?? SQL Server ????? ????? ????? ??????? ??? ??????? ????? ??????? ???????? 2 ???????? ?????? (?? ??? ?? ??? ??????? ????? ??????? ???????? 3 ???????? ?????? ??? SQL Server Enterprise Edition ?? / 3 GB ??????? ?? ????? Boot.ini).

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

17802 ???: ???????: ???? 18 ?: 3
???? ????? ???? ????? ??? ??????.

????? 2

?? SQL Server "?? ????? process_loginread ???? ???????.

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

?????: ??? ????? ??????? ?????? ??????? ?????? ??????? ???????.

???? ????? ?????? ??????: = 3454 ??????? = ??????? 2540 = 138
Inram = 0 = 1108 ???????? ????? = 35
I / Latched O = 0 = 0, ???? = 214821
???????? ???? ?????? ??????: = ????? 222096 = 222096 ?????? = 215964
InternalReservation = ExternalReservation 547 = Min 0 = 512 ???????
TotalProcs ????? ??????? ??????: = TotalPages 8 = 138 InUsePages = 138
???? ???? ??????? ???????: = 3556
???? ??????? = ??? ??? = 1706
????????? ?? ???? = ?????? 755 = 0
????? ?????? = ????? 9 = 1583
??????? ?????? ??????? ????????: = ????????? 1119 = XDES 163 = SQLCache 1 = ????? ???????? 90 = LockBytes 5 = ServerGlobal 2 = 20
???? ???? ??????? ?????????: = ?????? 0 = ?????? 0 = 164370 ???????? = 164370

?????

??? ????? ?????? ?? ????? SQL Server ???? ???? 64 ???????? ???? ??? ????? ????????? ?? ????? ????? ??????? ??? ?? ??? ??????? ??? ?????. ???? ??? ??????? ????? ??? ????? ????? ????? ?????? ????????, ??? ????? ????? INSERT ?? UPDATE ?? DELETE. ???????? ??? ?????? ???? ????? ??????? ???? ?? ?????? ?? ????????? ??????? ?????? ????? ??????? ?????? 64 ????. ????? SQL Server 7.0 ????? ???? ?? ????? ??? 54-KB. ?? SQL Server 2000 ? ??? ?????? ??????? ?????? ??? ????? ?????? ??? ???? ??? ????????? ???? SQL Server ?????? ????????.

???? ??????

??????? -g ??????? ??? ??????? ??? ??? ?????? ? unreserved ??????? ???????? ???????? ?? ??? ????? ?????? ???????. -g ?? ????? ??????? Readme.txt ???? ???? 7.0 ?? SQL Server ??? SQL Server 2000 ????????. "???? ?? ?????????" ??? ?? ??? ??????? ????? ????????? ???? ???? Microsoft ???????? ?????? ?????? ???????? ???? ???????.

??????? ????

??? ???? ??????? ?? ? ???????? ?? ???? ?? RAM ?? ????? SQL Server ???? ???? 256 ???? ???? (SQL Server 7.0) ?? 384 ???????? (SQL Server 2000) ?? ????? ??????? ???????? ????? ????? ??? ??????? ????????? ?? ??? ???? ?????? ??????. ???????? ??? ???? ??? ????? ????? ??????? ?????? ???????? ?????? ?? ?????? SQL Server ????? ???? ?????? ?????? ????? ???? ????? ??????? ?????? ?? ?????? SQL Server ???? ??? ?? 8 ???? ????. ??????? unreserved ???????? ???? ????????? ?? ?????? ????? ???? ??? ????????? ?? ????? ?????? ??????. ????? ?????? ????? ??? ???? ?? ????? ???:
  • ?????? ?? ???? ??????? ???? ??????? ???? ????? ???????? ??? ?????? ??????? ???? ???? SQL. ??? ?? ???? ???? SQL ???? ?????? ????? 255 worker, ???? 140 ???????? ???????.
  • ?????? ??????? ???? ??? ?????? ?????? DLLs ?? ???????? ???? ???? ?? ????? ??????? SQL Server (????? ????? ?? ???? ???) ???:
    • ????? OLE DB ?? ??? ?????? ????????.
    • ?????? COM ???? ?? ??????? ?????? ??????? ???? sp_OA ????????? ??????? ?? ????????? ??????? ???????.
  • ?? ??? (.exe ?? .dll) ???? ??? ??????? ?? ????? ??????? ???? ???? ??????? ?? ??? ?? ???????? ???? ?? ??????? ?? ???? ???? ??? ??? ?????? ?????? ???????? sp_OA ?? ????? ????????? ???????.
  • ???? ??????? ??????? ????? ?? ?? heaps ???? ?? ???? ?????? SQL Server. ????? ????? ??? ????? ??? ????? 10 ???????? ???? ?? ???? ???? ??? ??? ?????? ?????? ???????? ?? sp_OA ?? ????????? ??????? ???????.
  • ?????? ??????? ?? ???????? SQL Server ???? ???? ?? 8 ???? ???? ??? ???????? ??? ????????? ????? ?????? ????? ??????? ??????? ??? ??? ?????? ????? ?????? ??? ?????? ??? ????? ??? 8 ???? ???? ?????. ??????? ??? ????? ???? ?? ?????? OS ???????? ???? ??? ????? ?? MEMORYSTATUS DBCC ?? ???? ??? ??????? ?? ??? ??????? 8-KB. ?? ????? ????????? ??? 5 ???? ????.
  • ???? ????? ??????? ?????? ?? ??? ?? ?????? ?????? ?? ????? ?????? ??????. ??? ?? ?????? ????? 20 ???????? ? ??? ??? ????? SQL Server ?? ???????? ??? ?????? ?????? (AWE) ???????? ??? ??? ?????? ???? ?? ???? ???? ???? ?????.
?? ??????? ???? ????? ??? ??? ???? ?? ????? ???????? ?? ???? ?????? ????? 64 KB ???????? ???? ????? ???? ??????? ???????? ????????. ??? ??? ?????? ?????? ????? ??????? ?? ???? ? ??? ???? ??? ???? ?? ???? ?? ??????? ??????? ?? "?????? ?????" ??? ?? ??? ???????.

???????? -g ??????? ??? ???????, ???? ????? ???? SQL ??? ??? ?????? ??????? ???????? ???????? ???? ?? ??? ????? ???????? ?? ?????? ????? ??? ???????? ??? ?????? ????? ???? ???? ?? ????? ??????? ????????.

?????? ?????? ??? ???????? ??? ???? ??????? -g ???? ???????? ??? ??? "????? ????????" ? "????? ??????:
?? ??? ??????????? ??? ??????
????? ????????SQL Server 7.0SQL Server 2000
250-g134n/a
500-g185n/a
750-g237n/a
1000-g288-g288
1250-g340-g340
1500-g392-g392
?? ???? ??? ?????? ???????? ????? ????????? ??????? ? ????? ???????? ?????? ?? ???? ?????? ???????? ?? sp_OA ?? ????????? ??????? ??????? ??? ?????????. ??? ????? ???? ?????? ??? ??????? AWE ? ??? ???? ????? ??????? SQL ??? ??? ?????????. ?? ?? ??? ??????? ?? ????? ????? ?????? -g.

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

???????? ??? ???? ????? ?????? ?? ????? ?????? ????? ???? ??? ?????? ??? ??????? ????????. ???? ????? ?????? ????? ??????? ?? ????? ???????? ???? ?? ???? ??? ???? ???? ???? ????? ???? ?????? ????. ??? ???? ??????? ?? ????? ????? ????? ???????:
701 ???: ???????: ???? 17 ?: 123.
???? ????? ????? ?????? ??? ?????????.
?? ???? ??? ????? ?? ???? ???? ??????? ?????? ?????? ?? SQL Server 2005 ???? ????? SQL Server 2005 ?? ?????? ??????? ??? ????? ?????? ?? ??????? SQL Server.

??? ???? ??????? ?????? ???????? ??????? sys.dm_db_index_usage_stats ????? ???? ??? ??? ?? ??????? ?? ????? ??????? ?????? ?? ???????. ????? ??????? ??????? ?????? ?? ??????? ??? ??? ??? ????? ?????? ?????? ?? ???????.

???????

???? ???????: 316749 - ????? ??? ??????: 10/???/1428 - ??????: 11.1
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
????? ??????: 
kbmt kberrmsg kbtshoot kbnofix kbprb KB316749 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????316749

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

 

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