原文如下:
http://www.microsoft.com/china/msdn/library/data/sqlserver/Profiler.mspx
我在尝试的时候，发现以下错误:
08/11/05 09: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/11/05 09:12:06 ERROR: Event 10 does not contain the following required column(s): 15
08/11/05 09:12:06 WARNING: Event 10 does not contain the following recommended column(s):
3
08/11/05 09:12:06 ERROR: Event 12 does not contain the following required column(s): 15
08/11/05 09:12:06 WARNING: Event 12 does not contain the following recommended column(s):
3
08/11/05 09:12:06 ERROR: Event 14 does not contain the following required column(s): 15
08/11/05 09:12:06 ERROR: Event 15 does not contain the following required column(s): 15
08/11/05 09:12:06 ERROR: Event 17 does not contain the following required column(s): 15
08/11/05 09: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.
提示是在运行事件探查器跟踪SQL运行的时候，默认选取的"数据列"不足造成的，查过READ80TRACE帮助文件后，增加选取以下"数据列":DatabastID , EndTime, ObjectID, NestLevel, IntegerData.
后来又出现这个错误提示:
08/11/05 09:22: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.
提示是在运行事件探查器跟踪SQL运行的时候,默认选取的"事件"不足造成的.增加选取以下"事件": TSQL:BatchStarting,
, 存储过程RPC:Starting, 存储过程SP:StmtStarting, 存储过程SP:StmtCompleted, 性能Showplan Statistics
--------------------------------------------------------------
在本机SQLSERVER服务器LOCALHOST新建数据库RML,在Read80trace的安装目录下运行以下命令:
read80trace -f -dRML -I"d:\test.trc"
注意-d和数据库名RML之间无空格,-I和文件名之间也无空格.很怪的表达方式啊^-^
运行完毕，系统自动弹出IE给出一份跟详细的报告!(我还没有仔细查看该报告呢!)
----------------------------------------------------------------
PSSDIAG Data Collection Utility
PSSDIAG是MS SQLSERVER的数据收集诊断工具,今天先下载了看看，还没有具体使用呢!
PSSDiag is a diagnostic data collector for Microsoft SQL Server. It can simultaneously collect Perfmon/Sysmon logs, Profiler traces, event logs, SQLDIAG reports, and detailed blocking information. It is commonly used by Microsoft Product Support Services engineers to collect diagnostic data from end-user installations and can also be used by end-users to troubleshoot and monitor their own SQL Server installations
