我用事件探查器做一个Trace.trc,放在F盘,在本地数据库建立了一个新数据库mydb,
接着打开cmd,找到对应Read80Trace.exe目录
然后使用:Read80trace –f –dmydb –I"f:/trace.trc"
提示:
Output path was not specified; defaulting to E:/rml/output
05/11/08 16:22:16 -----------------------------------------------------
05/11/08 16:22:16 Read80Trace version 8.10.0010
05/11/08 16:22:16 –f
05/11/08 16:22:16 –dmydb
05/11/08 16:22:16 –IE:/rml/mytrace.trc
05/11/08 16:22:16 ERROR: Invalid path specified for input file
后来改用(语法错误)
read80trace -f -I"f:/trace.trc" -dmydb
提示以下:
08/08/05 12:12:06 WARNING: The following trace events were not captured: SQL:BatchStarting
, RPC:Starting, SP:StmtStarting, SP:StmtCompleted, Showplan Statistics. Review the help fi
le to ensure that you have collected the appropriate set of events and columns for your in
tended analysis.
08/08/05 12:12:06 ERROR: Event 10 does not contain the following required column(s): 15
08/08/05 12:12:06 WARNING: Event 10 does not contain the following recommended column(s):
3
08/08/05 12:12:06 ERROR: Event 12 does not contain the following required column(s): 15
08/08/05 12:12:06 WARNING: Event 12 does not contain the following recommended column(s):
3
08/08/05 12:12:06 ERROR: Event 14 does not contain the following required column(s): 15
08/08/05 12:12:06 ERROR: Event 15 does not contain the following required column(s): 15
08/08/05 12:12:06 ERROR: Event 17 does not contain the following required column(s): 15
08/08/05 12:12:06 ERROR: Performance analysis has been disabled because one or more events
is missing required columns. Consult the help file for the recommended set of trace event
s and necessary columns.
提示数据列列不足,查看了READ80TRACE帮助文件后,增加 以下列 DatabastID , EndTime, ObjectID, NestLevel,
IntegerData.
后来又出现这个错误提示:
08/08/05 12:18:51 WARNING: The following trace events were not captured: SQL:BatchStarting
, RPC:Starting, SP:StmtStarting, SP:StmtCompleted, Showplan Statistics. Review the help fi
le to ensure that you have collected the appropriate set of events and columns for your in
tended analysis.
再添加事件:
TSQL:BatchStarting,
, 存储过程RPC:Starting, 存储过程SP:StmtStarting, 存储过程SP:StmtCompleted, 性能Showplan Statistics
再运行OK了