성능::ReadTrace 사용법

사용법

 

1. --===================================
   -- READ TRACE
   --===================================
   ReadTrace -I파일경로 -S서버명 -dDB명 -U유저 -P패스워드
2. 
   D:\Program Files\Microsoft Corporation\RML\ReadTrace.exe /?
3. ReadTrace version 9.00.0023 (X86)
4. USAGE:
5. NOTE: All command line arguments are case sensitive
6. -I  File name of the first .TRC file to process [REQUIRED]
7. -i  If specified, indicates that the .TRC file(s) to process are present inside a CAB/ZIP file with this file name
8. -o  Full path of directory to place output files [default is current directory]
9. -S  Name of SQL Server 2005 server to connect to when loading performance analysis data [default is (local)]
10. -d  Database to use when loading performance data [default is PerfAnalysis].
11.      User specified below must have CREATE DATABASE permission (if DB doesn't
12.      exist) or be part of the db_owner role if the database already exists.
13. -E  Connect to SQL using Windows Authentication [default]
14. -U  Connect to SQL using this user name
15. -P  Password for the user specified in -U option
16. -a  Disable performance analysis
17. -f  Do not produce .RML output files for each SPID
18. -Q  Do normalization parse using quoted_identifier OFF symantics.  (Default is ON)
19. -r# Read at most this # of files (including the first) [default is all files
20.     until a break in the rollover file sequence is detected].
21. -M  Mirror trace files by SPID to the specified output directory (All SPIDs
22.     will be output even if SPID filter is specified)
23. -MF Mirror trace files by SPID to the specified output directory (Only SPIDs
24.    matching filter parameters will be output)
25. -A  'INCLUDE or EXCLUDE' events with Applicaiton Names
26. -H  'INCLUDE or EXCLUDE' events with Host Names
27. -s# 'INCLUDE or EXCLUDE' events from specified SPIDs
28. -b  Provide a designated start time in required format 2000-05-25 11:46:20:060
29. -e  Provide a designated stop time in required format  2000-05-25 11:46:20:060
30. -D  Skip date on log file output
31. -?  Show usage of command line parameters
32. EXAMPLES:
33. ReadTrace -Iserver__sp_trace.trc -ic:\temp\traces.cab -oc:\temp\output -f
34. ReadTrace -I"c:\my traces\80AllEvents.trc" -o"c:\my output"
35. ReadTrace -Ioutput\SQLSRV1__sp_trace_20.trc -ic:\temp\pssdiag.zip -oc:\temp\breakout -f -r2

PSSDIAG 수집 유형

• http://support.microsoft.com/kb/830232
• http://msdn.microsoft.com/en-us/library/aa175399(SQL.80).aspx 

 

이 글은 스프링노트에서 작성되었습니다.