PRB: ??? ??? ???? ???? ??? ???? ??? ??????? Tempdb ???? ???

?????? ????????? ?????? ?????????
???? ???????: 141183 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

???????

??? ?? ??? ??? ????????? ????? ?????? tempdp ??? ???? ????? ? ???? ?????? ????? ????? ?????? tempdp ??? ???? ???? ???? ????? ??? ?????? ?????????? ? ????? logsegment.

?????

???? ??? ??????? ??? ??? ??? ???? ??? ????????? ????? ?????? tempdp ?? ?????? ?????? ????? ??.

??? 6.x SQL Server ??? ???? ??? ??? ??????? ????? ??????? SQL ???????? ??? ????? ????? ?????? ?????? ??? ??? ????? ??? ?????????.

???? ????? ????? ????? ????? ????? 1105:
?? ???? ????? ????? ????? '< ??? ?????? >' ?? ????? ???????? 'tempdb' ???? ?????? ?????? '??????????'. ??? ??? ?????? ????? ?? Syslogs ????? ??? ?????????. ????? ?????? ALTER ????? ?????? ?? sp_extendsegment ??? ????? ??? ??????.

???? ?? ???? ??? ??? contending ??? ????????? ?????? ???? ??? ?? ??????? ?? ???? ???????? ???. ?? ??? ???????? ???? ?? ?????? ??? ????????? ????? ?????? tempdp ??? ?????.

???? ??????

????? ????? ?????? tempdp ??? ???? 2 ???????? ?????? ??? ?????? ?????? ????? ?? (????? ?????). ?? ?? ?????? ??? ???? ??? ??????? ???? ?????.

?? SQL Server 4.21a ? ????? ??? ????? ?????? tempdp ?? RAM ?? ??? ??? ????? ?? RAM. ???? ??? ??? ????? ???? ???/?????? ????? tempdb 2 ???????? ??? ???? ????? ???????? ?????????. ??? ???? ????? ?????? tempdp ????? ????? ???? ?? RAM ?? ????? ????? ?????? ??????? ?????? ????? ?????? tempdp ??????? ?? 2 ???????? ??? ?????? ???????.



6.x SQL Server ? ???? ??????? ?????? ?? SHRINKDB DBCC ??????. ???? ?? SHRINKDB DBCC ?? ????? ?????? tempdp ????? ?????? ??? ??? ????? ?? ??? ???????? ???? ?? ??????? & -m. ???? SQL Server "???? ???????" ????? ?? ?????????.

??????? ????

?? ???? ????? ?????? ???????? ?????? ??? ??? ????????? ????? ?????? tempdp ?? ???? ???? ??? ????? ?????. ?????? ??? ???? ????? ??????? ?????? ??? ????? ?????? tempdp ? ?? ???? ???????? ??? ????? ?????? tempdp ?? RAM.

?????? ??? ??????? ?????? ??? ??? ????? ?????? tempdp ?? RAM ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
115050INF: ??? ???????? Tempdb ?? RAM

???????

???? ???????: 141183 - ????? ??? ??????: 28/???? ?????/1435 - ??????: 3.1
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbprb kbusage KB141183 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????141183

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