使用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了

 

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值