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

?????? ????????? ?????? ?????????
???? ???????: 298475
????? ???? | ?? ????

?? ??? ??????

??????

???????? ?????? ?? ??????? ??? ???? ????? ????? ?? ??????? ?????? ??????? ?????? ??? ???????. ???? ????? ???????:
  • ???
  • ??????? ??? ??????? ??????
  • ????? ??????? ???????
  • ????????? ?? ????????? ??????? ??? ??????? ???? ????
????? ??? ??????? ???? ????? ?????? ????? ? ?? ?????? ??? ???? ????? ????????? ???? ?? ?????. ????? ???? ????? ??? ???? ????? ????? ?????? ????? ?? ???? ???????. ???? ???? ????? ?????? ?????? ???? ????? ??????? ?? ???? ?? ?????????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
224587????? ??????? ????? ???? ??????? ?? SQL Server
???????? ?? ?????? ??? ??????? ????????? ??? ????????? ??????? ?? ??? ????? ????? ??????? ????? ?????? ??? ??????? ?????? ??? ???????? ?? Microsoft (PSS):
  • ????? ???????? ????? ??? ????????
  • ??? ?????? ???? ????? ??????? SQL
  • ??? ?????? ???? ???? SQL
?????? ?? ???? ??? ??? ??? ????????? ??? ?????? ???? ???????? ?? ???? ???? ???? ????????? ??? ????. ???? ?? ???? ??? ????? ????? ??????? ??????? ????????.

??? ???? ???????? ????? ????????? ??????? ????? ??????:
  • ????? sqldiag
  • ???? ??????? Microsoft Windows NT ???????? ??????? ?????
?? ???? ???????? ????? PSS ??? ????????? ???? ?????? ?????? ????? ??????. ??? ??? ?? ??? ?? ??? ????????? ??? ??????? ?? ???? ????? ??????? ??????? ???????? ? ?? ??? ????? ????? ????? ??????.

??? ?? ??? ????? ?? ????? ??? ?????? ?? ??????? ???? Microsoft ????? ????? ??? ???????. ?? ???? ???? ????? ????? ????? ?????? ????????? ???????? ??????? ???????. ???????? ??? ???? ??? ??? ????? ?????? ??? ???? ????? ??????? SQL ??????? ??? ????? ???? ???? SQL ????? ?????? ??? ??? ????? ??????? ??? ?? ?????? ????? ??????? ??? ??????? ???????? ??? ??? ????? ??????? ?? ???????.

??? ??? ??? ??? ????????? ?? ???? ???? ????? SQL Server ????? ?? ????? ?????? ??????. ??? ???? ??? ?? ????? ??? ????????? ?????? ??? ???????? ??? ??????? ??????? ????????. ???? SQL Profiler ??? ?? ????? ???? ??? ??????. ??? ??? ??? ????? ?????? ??? ????? ????? ????? ????? SQL ???? ???? ????? ??????? ?????? ????? ??????? ?????. ???? ??? ?? ???? SQL Profiler ????? ??? ??????. ??? ??? ???? ????? ?? ????? ?? ????? ???? ????????? ???????? ? PSS.

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

???????? ????? ???? ????? ?????? ?????????? ?????. ??? ???? ????? ??????? ??????? ?? ???????? ????? ???????? ??????? ???????? ?????? ??????? ??? ?? ???? ??? ???? ?????. ?????? ??? ??????? ???? ??? ????? ?? ??? ??? ?? ?????? ??????????? ??? ???????? ??? ?????/????? ?????? ?? ??? ????????? ?? ??? ???????? ?? ???? ??? ?? ?????. ????? ?? ????????? ??? ????? ???????? ????? ??? ????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? Microsoft Knowledge Base:
251004????? ?????? ??? SQL Server 7.0
271509 ????? ?????? ??? SQL Server 2000

??? ?????? ???? ????? ??????? SQL

???? SQL Profiler ????? ???? ??? ????????? ?????? SQL Server. ????? ??????? ??? ????????? ?????? ??? ????? ????????? ???? ??????? ??? ????. ???????? ??? ???? ???? ????? ??????? SQL ????????? ????? ??????? ???? ???? ??? ????? ??????? ?????? ??? ????? ????? ????? ??.

?????? ?????? ????? ???? ???? ????? ??????? SQL ??? ???????? ????? ???????? ????????? ???? ??? "?? ??? ??????" ?? ???? Microsoft ????? ????? ???????:
224587 ????? ??????? ????? ???? ??????? ?? SQL Server
????? ?? ????????? ??? ????? ????? ???????? ???? ????? ??????? SQL ???? ???????? ????? SQL ????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? Microsoft Knowledge Base:
289742????? ????? ???? SQL Server 7.0
283790 ????? ????? ???? SQL Server 2000
????? ?? ????????? ??? ????? ?????? ???? SQL Profiler ??? ???????? ????? SQL ????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? Microsoft Knowledge Base:
289279INF: ????? ?????? ?????? SQL Server 7.0
283786 ????? ?????? ?????? SQL Server 2000
?????? ??? ??? ???? ???? ???? ????? ??????? SQL ?? ??? ????? ?????? ????? ??????? ????? ??? ??????. ?????? "????? ??? ??????" ??????? SQL Server ???? ?????? ?????? ?????? ?? ??????? ?????????? ??????. "????? ??? ??????" ???? ????? ???? ????? ?? ??? ??? ?????? ???? ????? ?? ????? ???????? ?????? ??. ?? ???? ????? ??????? ???? ??????? ?????? ?? ????? ?? ????? ???? ??????? ????? ??.

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

??? ?????? ???? ???? SQL

???? ????? ???? SQL ??? ?????????? ?? ???:
  • ???? ???????? ????????
  • ???????
  • ?????/????? ?????
  • ????? ?? ??? deadlocking
????? ??????? ?????? ?????? ???? SQL ?????? ????? ??? ?? ???? ?????????? ???????? ??? SQL Server. ???????? ??? ???? ????? ??????? ??? ????? ?????? ??? ????? ?????? ???? ???? ??????? ????????? ???? ???? SQL ?????? ???????? ???? ??? ???? ???? SQL.

??? ??? ????? ?????? ???? ???? SQL? ???? ?? ?? ?????? ????? ???. ?????? ????? ????? diskperf ?? ???? ???????. ??? ?? ??? ?????? ????? ???? ????? diskperf-y ??? ?????? ????? ???? ?????????.

????? ???? ?????? SQL ?????? ???? ???? ????? ??????? ???? ????????? ???????:
  • ??? ????? ???????
  • ?????
  • ???????
  • ???? ???????? SQL Server
  • ???????
  • ?????? ???????
  • ????? ???????
  • ????? ??????
  • ??????
?????? ?? ?????? ?????? ????????? 15 ????? ????? ?????? ??????? ??????; ??? ???? ??? ??????? ?????? ?? ???? ??? ????? ????? ?????? ?????? ?????? ????????.

????? ?? ????????? ??? ????? ????? ???? ???? SQL ?????? ???? ???? ??? ????? ???????? ??????? ???? ???????? ?? Microsoft Knowledge Base:
150934????? ????? ??? "?????? ??????" ???????? ??????? ???????? NT
248345 ????? ????? ??? ???????? "????? ??????" ?? Windows 2000


?????? ????? ?? ????????? ??? ?????? ?????? ?? SQL Server 2005? ???? ??????? "?????? ???? ??????" ?? ??? SQL Server 2005.

?????? ???????? sqldiag

??? ????? ?????? ???????? sqldiag ?? SQL Server. ?????? ??????? ???? ??? ????? ????????? ???? ???? SQL ?????? ????? ??????? ?????????? ???? ?? ??????? ???? ??? SQL ????? ????? ??????. ????? ?? ????????? ??? ????? ??????? ?????? ???????? sqldiag? ???? ??????? "sqldiag ??????? ????????" ?? "??? SQL Server".

????? ?? ????????? ??? ????? ????? sqldiag ??? ???? SQL ?????? ????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
233332????? ????? SQLDIAG ??? ?????? ????????/????? SQL Server

?????? ?? SQL Server 2005? ?? ????? ?????? ???????? SQLdiag ??? ?? ????. ?????? ??? ??????? ???? ?????? ???????? ??? ??????? ?? SQL Server 2000. ?? ??? ????? ??? ?????? ????????? ?????????? ?? ??????? ?????? ???? ????? ??? ?????? ??? ??????? ?? ?????? ????? ?? ?? ?? ???? ???? ???? ?? ???????? ?????????. ????? ?? ?????????? ???? ??????? "SQLdiag ?????? ????????" ?? ??? SQL Server 2005.

????? ????? ??????? ??????? Windows NT Microsoft

????? ??????? ???? ??????? Windows NT ?????? ???????? ????? ??????? ??? ?????? ??? ???????? ???? ?? ??????? ?? ?????? ????. ????? ??? ??????? ?? ????? ??? ???? ?????? ?????? ?????? ??? ???? ??????? ?? ??????.

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

???? ?? ????? FTP ????? ??? Microsoft ??????? ????? ????? ??????? ?? ????????? PSS:
ftp://ftppss.microsoft.com


?? ??? ???? ?? ?????????? ???? ????????? ???? ??? ??????? ?? ??? Microsoft ???? ??? FTP Exchange.




??????? ????????: 9

??????? ????

 
?? ??? ??????????? ??? ??????
?????? ???????????? ?????????? ?????????????? ???????? ???? ??? ????? ???????
???? ???? ??????????? SQL Server ?????? ?????? ?????? ???? ???? ??? ??????????? ???? ???? ?????? ???? ?????? ????? ???? ???? ?????????? ???? ??? ?????? ??????? ?????. ??? ????? ??? ??????? ??? ??? ???? ???? ???????? ??? ???????? ??? ?? ????? ?? ???? UNC ????? ???? ??????? e ??????????. ?????? ????????? ???????? ?? ??? ??????? ?????? ????????? ????????? ??? ??? ?????.SQL Server 2008
SQL Server 2008 R2
???? SQL 2012



???????

???? ???????: 298475 - ????? ??? ??????: 02/?? ??????/1433 - ??????: 1.0
????? ??????: 
kbhowtomaster kbinfo kbmt KB298475 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????298475

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

 

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