???????? ?????? ???????? PSSDIAG

???? ???????: 830232 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

PSSDIAG ???? ??? ??????? ?????? ?????? ?? Microsoft Product Support Services ?????? ???? ????? ???????? ?????? ?????. PSSDIAG ????? ???? ??? ????? "?????? ??????"? ???? ????? ??????? SQL ?????? ?????? ???????? ????? ??? SQL Server ?????? ????? Windows ? SQLDIAG ???????. ???? ????? ????? ??? ???????? ?? ???? ????? ?? ????? ?? ?? ????? ??? ???????? ?????? ?????? ?????? ?????? ?? ???????? ????? ??? ????? ????? ??????? ??? ???? ????? ????? ????? ??????? ? ???? ????? ??????? SQL ??????? ?????? ????????. ??? ????? ????? PSSDIAG ???? ??? ??????? ?? ??????? ?????? SQL ???????? ??????? ??????? ???? ????? ?????? ???? ????? ??????? ???????? ?????.
???? ??? ?????? | ????? ???????

??????? ????

????? ??? ??????? ??? ????? PSSDIAG ???? ???? Microsoft Product Support Services ???????? ?? ??????? ??????? ???????? ?? ??? ???????. ???? ?????? ?????? ?? ?????? ????? ??????? ???????. ??????? ???? ???? ??? ????? ??????? ??????? ?????? ??????? ?? ?????? ???? ??? Microsoft Developer Network (MSDN) ???????:
. aspx http://msdn2.microsoft.com/en-us/library/aa175399 (SQL.80)
(http://msdn2.microsoft.com/en-us/library/aa175399(SQL.80).aspx)
? Microsoft SQL Server 2000 ?? Microsoft SQL Server 7.0? ????? ????? ?????? ??????? ?? "???? ??????? ? Microsoft":

?? ??? ??????????? ??? ??????
?? ??????
?? ?????? ?????? ?????? ???????? ?????? ???????? PSSDIAG ????.
(http://www.microsoft.com/downloads/details.aspx?FamilyID=5564386a-28c2-4483-8293-76fff67b9eb3&DisplayLang=en)


????? ???????: 29 ?????? 2004

Microsoft SQL Server 2005 ?????????? ??????? ?????? ????? Pssdiag ? Sqldiag ???? ???? ??????? ??? ?????? [???????] ??????:
http://diagmanager.codeplex.com/
(http://diagmanager.codeplex.com/)

?????? ??? ???? ?? ?????????? ?? ?????? ???? msdn ??? ??? ??????:
http://blogs.msdn.com/b/psssql/archive/2011/05/24/pssdiag-sqldiag-configuration-manager-released-to-codeplex.aspx
(http://blogs.msdn.com/b/psssql/archive/2011/05/24/pssdiag-sqldiag-configuration-manager-released-to-codeplex.aspx)

????? ?? ????????? ??? ????? ????? Microsoft ??? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
119591
(http://support.microsoft.com/kb/119591/ )
????? ?????? ??? ????? ??? Microsoft ?? ??????? ??? ????????
???? Microsoft ???? ??? ????? ????? ?? ?????????. ?????? Microsoft ???????? ????? ?? ????????? ?????? ???? ??????? ???? ???? ?????? ??? ??????? ???? ?? ??? ?????. ??? ????? ????? ??? ?????? ????? ?????? ???? ????? ??? ??? ????? ??? ??????? ??? ???? ??? ??? ?????.

????? ??? ????? PSSDIAG

???? PSSDIAG ?? ?????? C:\PSSDIAG ???? ???? ???????? ??? ????? ?? ???? ?????????. ??? ????? ??? ??? ?????? ??? ???? ????? ????? ??? ????? ????? ??? ????? ??????? ??????? ???????? ?????? ??? ??? ?? ????? PSSDIAG ???????. ???? ???? ?? ??? ????? PSSDIAG ???? ?????? ?? ??? ????? ?????? ?? ????? ????? ????? ????? ???????? ?? ???? ???? ?? ?????? ??? ??? ??? ???? ????. ????? ??? ?? ??????? ???? ???????? ???? ???? ???? ????? ??? ??????? ???? ??? ????? ?? ?????? ??? ??????. ????? ?? ?? ???? ????? ????. ???????? ???????? ???? ????? ????? ?????? ????? ????? ??? ???? ???? ????? ??????? SQL? ???? ?? ?? ??? ????? PSSDIAG ?? ???? ????? ????? ?? ?? ?????? ???? ????? ?? ?? ???? ????? ???? ????.

?????? ???? ????? PSSDIAG ?????? ??? ?????? ???? ??? ???????. ??? ???? ????? ????? PSSDIAG ??? ??? ???? ????. ????? ?? ????????? ??? ????? ????? PSSDIAG ?? ???? ???? "????? PSSDIAG ?? ??? ?? ??? ???? SQL ?????? ????????" ??? ?? ??? ???????.

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

?? ??? Pssdiag.exe ????? ????????? ??????? ????????. ??? ???? ????? Microsoft Windows NT ????? ??????? ?????? ?????? ?? ???????? ??????? ???? ???? ?? ???? PSSDIAG ???? ??????? ????? ???????. ????? ??? ?? ???? ???? ????? ?????? sysadmin ????? ???????? ??? SQL Server ??? ??? PSSDIAG ????? ??? ????? ?? SQL Server (?????? ??? PSSDIAG ???? ??? ??????? ?? ??? "????" ?? ?? /G ????? ????? ??? ???????). ???? ???????? ????? PSSDIAG Windows ?????? ????? SQL Server? ??? ???? ????? ??????? SQL Server ?????? ??? ??? ????.

PSSDIAG ???? ??? ?????????? ???? ??????? ??????. ????? ?? ????????? ??? ?????? ??? ??????? ?????????? ???? ?????? "?????? ??? ??????? PSSDIAG". ???? ????? ??? ?? ??????? ??????? ???????? ??????????. ??? ????? ??????? ?? PSSDIAG ????? ??????? ?? ?????? ??? "???? ??????? ? Microsoft"? Pssdiag.exe ??? ??? ????? ??? ????????.

??? ??? ????? PSSDIAG, ????? ???? ?????, ? ?? ???? ?????? ????? ??? ?? ?????? ???????. ??? ??????? ?? ?????? ??? ????. ??? ??? ????? PSSDIAG ????? ???? ???? ??????? ????? ???? ???? ????? ??????? ??????? ??? ???? ??????:

???? ??? PSSDIAG 12:30:14.90 2003/10/02. ???? ??? Ctrl + C ??????.


??? ??? ???? ?????? PSSDIAG ???? ???????? ??? ??????? ???? ????? ????? ??? ????? ????? ??? ????? ????? ??? ?????? ????? ????? ???????.

?? ??? ????? ?????? ?? ???? ??? ???? ?????? ??? ??? ????? PSSDIAG ??? ?? ??? ??? ???????? ?????? ??? ????? PSSDIAG. ??? PSSDIAG ???? ???? ????? ?? ????? ???? ????? ????? ?????? ?? ?????? ??? ??? ????? PSSDIAG ???? ?????? ???????? ?????? ??? ????????. ????? ????? PSSDIAG ?? ???? ????? ???? ??? ?????? ??? ??? ????? ???? ????? ??? ????? ???? ????? ????? ?? ????? ?????? ?????? PSSDIAG ??? ???????.

????? ????? PSSDIAG

?????? PSSDIAG? ???? ??? CTRL + C ?? ???? ???? ?????? ???? PSSDIAG ??? ???????. ???? ?? ?? ?????? ???? ?? ???? ??? PSSDIAG ????? ????? ???? ???? ???????? ?? ??? ????. ?????? ??? ???? ?? ????????? ??? ???? ???? ?????? "???????? ??? ?????? PSSDIAG". ??? ??? PSSDIAG ???????? ????? ????? ??? ???.cab ?????? ?? ?????? ??? ????? ? PSSDIAG ???????? ?? ??? ????? ????? ???????. ??? ?? ???? CTRL + C? PSSDIAG ??? ???? ????? ???? ????? ??? ???? ??? ???? ??????:
???????? PSSDIAG ???????? 12:24:00.69 2003/10/02 ???. ???????? ????? ??????? ????? ??????? ???? ??? ??????? (???? ?? ?????? ??? ?????)


??? ???? ??? ???????? PSSDIAG ?? ?? ??? ??? ?????? ?? ???????? ?? ?????? ????? ??? ??? ??? ??? ?? ????? ???? ???????? ???? ?? ????? ?????.

??? PSSDIAG ????? ???? ?????? ???? ?? ?????? ?? ????? ?????? ???:

?? ????? ??????? ?? F:\pssdiag\output\ ??? PSSDIAG.CAB. ??? ????? ?????????? ?? F:\pssdiag\output\backup\?


????? ???? ??? ??????? Microsoft ????? ??? ??????? ?? "N" ???????? ?????? ???????? ???? ?? ????? ?? ????? ????????? ??????????? ????? ?????????? ??? ??????? Pssdiag.cab ?????.

???? ??????? PSSDIAG

?? ?? ??? ????? ???? ????? ????? ???????? /O ????? ??? ???????? PSSDIAG ????? ???? ???? ???? ??????? ?? ?????? ??? ??? ??????. ??? ??? ???? ?????? PSSDIAG ?? ?? /C0 (???????) ?? /C1 ?????? ??? ??????? ?????? ??? ????????? ???? ??? ????? ??????? ?? ??? ??????. ?? ????? ??? ??? ??????? ?????? ???????? ???? ???????? ????? ?? ??? ??? ???? ?????? ?????? ??? ?????? ??? ??? Microsoft.

??? ??? ???? PSSDIAG ?? ??? ????? ????????? ???? ????? ???? ????? ??????? ??? ????? ??? Pssdiag.cab ?? ??????? ??????. ???? ???????? ?? ???? PSSDIAG ?? ???. ??? ?? ??? ????? ??? ??? ??? Pssdiag.cab ?????? ???? ????? ????? ??? ???? ????? ???? ????? ?????????. ?? ????? ????????? ??? ????? ???? ?? ??????? ??????. ????? ?? ???? ?????? ???????? ??? ???????? ???? ???? ????? ??? ????? ???? ????? ??? 2-???? ???? (GB). ??? ???? ???????? ???? ?? ????? ?????? 2 ???? ????, ????? CAB ?????? ??????? Pssdiag2.cab? Pssdiag3.cab? ??? ??? ??? ???? ?????.

????? PSSDIAG

PSSDIAG ?? ???? ??? ?????? COM? ??? ??? ????? ??? ????? ??????? ?? ?????? ????? ??????. ?????? PSSDIAG ??? ???????? ?? ???????? ?? ???? ???? ?????? ???? ????? ??? ????? PSSDIAG. PSSDIAG ????? ??? ??????? ?????? ?????? ?? ??????? ????? ????????. ??? ????????? ??????? ??? ???????? ????? ????? ????? ????? PSSDIAG.

?????? ??? ??????? PSSDIAG

????? ????? PSSDIAG/? ?? ??? ??????? ??????? ????? ?????? ??? ??????? ??? PSSDIAG ?????. ???? ?? ?? ??? ???????? ?????? ????????? ??????. ???? ?????? ??? ??????? ??? ????????.

?? ??? ??????????? ??? ??????
??????????
/Q????? ??????. ??? ????????? ???? ????? ???????? ???????? ??? ???????? ???? ????? ????? ?????????.
/C/C0 ????? ??? ????????? ? /C1 ????? ??? NTFS ??????? ???????? ?? ?????? ???????. /C0 (?? ???? ???) ?? ??????? ?????????.
/B YYYYMMDD_HH:MM:SS
????? ????? ???????? ????? ????? ?? ???. PSSDIAG ?????? ??? ??? ?????? ??? ??? ?????. ??? ????? ??????? ?????? ?? ????? ?????? ???? ?? ?????? ???. ???? ????? ??????? ?????? ??? ?? ?? ??? ???. ??? ???? ??????? ????? ???? ????? ????? ??? ?? ??????? ???.
/E YYYYMMDD_HH:MM:SS
????? ?????? ??? ????? ???????. ?????? ??? ?????? ??? ??? ?????? PSSDIAG ?????? ???????? ???????? ??? ?????? ????? ????. ???? ?? ??? ????? ??????? ?????? ??? ?? ?? ??? ???. ??? ???? ??????? ????? ????? ????? ??? ?? ????? ???.
/G??? ????. ????????? PSSDIAG SQL Server ?????? ??? ??? ???????? ???? ????? ???? SQL Server ??? ?????. ?? /G ??????? ????? ???? SQL ?????? ???? ????????? ??? ?? ???? ??????? PSSDIAG ??????????? ????.


??? ??????? ???????? ???? PSSDIAG

?? ??? ???????? ?? ???? ?? ?????? ??? PSSDIAG ???????? ??? ??? ???????? ?? ??? ????? ?? ????? ???????? ??? ??? ???????? ????? ????? ?? ???. ??? ???? ??????? ??? ?? ??????? ????? ??????? ???? ???? ?????? ?? ?????? 2:00 ?????. ?? ??? ??? ????? ?? ???? PSSDIAG ???? ??? ???????? ?? ?????? 1:00 ?????? ?????? ???????? ?? 3:00 ?????. ???? ????? ?????? ?????? ??? ???????? ???????? ?? ?????? ????? ???????? /B ??? /E ?????? ??? ???????. ???? ?? ??????? ????? ??????? ?????? ???? ???????? ???? ??? ??????? ?? "?????? ??? ??????? PSSDIAG" ???. ??? ????? ??????? ???????? ???????? ?????? ??? ????????? ??? ??? ????? PSSDIAG.

PSSDIAG ???? ???? ????? ???????? ???? ???? ???? ?? ??? ???? Pssdiag.stop ?? ?????? ???????? ????? ??????. ???? ???? ?? ???? ?????? ??????? ????? ???? ????? ????? ??????? PSSDIAG ??? ???? ??? ???????? ???? ??? ?? ???? ?? ?????? ????? ???? ???? ???? ??? ?????. ??????? ????? Pssdiag.stop ?? ??? ???. ???? ???? ??????? ??? ??? ??????? ?? ??? ????: 
ECHO abc > F:\PSSDIAG\Output\PSSDIAG.STOP

????? ?????? PSSDIAG

??? PSSDIAG ???? ???? ??? ??? ???????? ?????? ?????? ????? ????????? ???????? ????????? ??? ???? ????? PSSDIAG ???? ??? ?? ????? ????? ?????? ??? ?? ????? PSSDIAG ???????. ????? ??? ??? ??????? ?????? ??? ?? ?????? ???????? ???? ??? ??????? ??? ??????? PSSDIAG.

???? ????? PSSDIAG ??????? ???? ????? ?? ???????? ?? ???? ?????? ???? ???????? ???? ??? ???????? ???? ?? ??? ??????? ??? ????. ???? ?????? ?? ??? ?????? ??? ??????? ??????? ???? ??? ????? ????? PSSDIAG ?? ???? ??? ?? ???? ?? ???????? ????? ????? ????? ??????? ???? ???? ???? ?? ?????. ??? ??? ???? ?????? ???? ??????? ??????? ???? ???????? ??? ????? ??????? "?????? ?????" ???? ???? ?? PSSDIAG ?????? ????? ??????? ??? ?? ?? ?????? ???????.

???? ?????? ???? ???? Pssdiag.exe ???? ????? ???? ?? ?????? CPU ????? ??????? ?? ????? ???????? ?????? ???????? ?? CAB ?????????. ??? ??? ????? ?????????? ??? ??????. ??? ???? ???? ???? ????? ?? /C ????? ??? ???????. ?? /C ????? ??? ??????? ?? ???? ???????? ?? "PSSDIAG ????? "?????? ??? ???????.

????? PSSDIAG ?? ??? ?? ??? ???? SQL ?????? ????????

? PSSDIAG ???? ???????? ?? ???? ???? ?? ?? ??? ?? ??? ????? ???? ?????? ???????? ?? SQL Server? ????? Pssdiag.ini. ???? ??? ????? ??? ?????? ???? ????? ??????? PSSDIAG. ???? ?????? ??? ??? ???? ?? ??? ?????? ??? ?? ??? ???? ????? ???? ???? ??? PSSDIAG ?? ??????? ????.

??? ??? ??? ??? ??????? ????? ??? ???? ????? Pssdiag.ini ?? ??? ?????? ??? Pssdiag.ini Pssdiag.exe-??? ?? "???????". ????? ????? ????? ?? ????? ??????? ".". ?????? ?? ?????? ?? ??? ??????? ????????? ?? ??? ?????? ??????. ??? ??? ???? ?????? ???????? ?? ???? ????? ?? SQL ????? ???? ?? ??? ?????? ??? ????? ?????? ????? SQL ??????. ??? ???? ??????? ??? ??? ??? ???? SQL Server ????? ?? "MYSERVER\MyInstance"? ???? ??????? ????? ????? ?? ????? Pssdiag.ini ?? "[MYSERVER]".

??? ????? ???? ???? ????? ??????? SQL ????? ??? ??????. ???? ?????? ?? ????? ??? ??? PSSDIAG ???? ???? ????? ??????? ????????? ???? ??????? ?????? ?? ????? PSSDIAG ?? ???. ??? ??? ???????? ???? Microsoft ??? ???? ?????? PSSDIAG ?????? ??????. ??? ??? ???? ?? ????? ?? ?????? ???? ???????? ?? ??? ??? ???? profiler ??????? ???? "?????? ?????" ??? ???? ?? ?????? ??? ???? ?? ????????.

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

??? ??? ????? ??? ?????? ??????? ?? ???? ????? ????? Pssdiag.ini ??? ??????? ??? ???? ?????? ???????? ?? SQL Server? ??? ??? ???? ????? PSSDIAG ?????? ??? ????? ?? ??? ??????.
???? ??? ?????? | ????? ???????
?????? ???????? PSSDiag ?? ??? ?????? ?? ????? ??? ??? SQL ???? 7.0 ? SQL Server 2000. ??? ?? ????? ????? ? SQL Server 2005. ??????? ?????? ???? SQLDiag ??? ?????? ?? SQL Server 2005. ????? ?? ????????? ??????? ??? SQLDiag? ???? ????? "SQLDiag" ?? ??? SQL Server 2005 ??? ????????.
???? ??? ?????? | ????? ???????

???????

???? ???????: 830232 - ????? ??? ??????: 22/???? ?????/1433 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbmt KB830232 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????830232
(http://support.microsoft.com/kb/830232/en-us/ )
???? ??? ?????? | ????? ???????

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

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