使用Read80Trace优化数据库遭遇的问题

     我用事件探查器做一个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了