SqlDiag

1,安装64位的。我的环境是sqlserver2012.

 

2,安装之后搞：

 

3，搞。
ReadTrace -I"C:\22222.trc" -o"C:\trace" -S"192.168.9.220" -d"PerfAnalysis" -U"sa" -P"xxx"

在本地生成一个PerfAnalysis库。

4，报表的东西自动弹出来。

 

 

 

 

 

 

 

遗憾就是上面的超链接点不了。

然后上面只有两个项目，网上看到的版本是有三个项目的。

 

 

2016/9/2 21:56:29 Information: Press OK to launch report(s)
2016/9/2 21:56:29 Progress: Processing request...
2016/9/2 21:56:29 Information: Connecting to Server: 192.168.2.118 Database: PerfAnalysis
2016/9/2 21:56:29 Progress: Validating versions and data basic information...
2016/9/2 21:56:29 Progress: Connecting to database and executing SQL commands
2016/9/2 21:56:29 Information: Loading resource string: Validate_SQL
2016/9/2 21:56:29 Information: Connecting to Server: 192.168.2.118 Database: PerfAnalysis
2016/9/2 21:56:29 Progress: Validating schema version...
2016/9/2 21:56:29 Information: Connecting to Server: 192.168.2.118 Database: PerfAnalysis
2016/9/2 21:56:29 Progress: Installing Reporter objects...
2016/9/2 21:56:29 Progress: Connecting to database and executing SQL commands
2016/9/2 21:56:29 Information: Loading resource string: Setup_SQL
2016/9/2 21:56:29 Information: Connecting to Server: 192.168.2.118 Database: PerfAnalysis
2016/9/2 21:56:30 Progress: Creating report ReadTrace_Main
2016/9/2 21:56:30 Information: Loading resource string: ReadTrace_Main
2016/9/2 21:56:30 Information: Connecting to Server: 192.168.2.118 Database: PerfAnalysis
2016/9/2 21:56:30 Progress: Loading report definition
2016/9/2 21:56:30 Progress: Establishing data sets
2016/9/2 21:56:34 Progress: Processing data set BATCHAGG_SCALE
2016/9/2 21:56:34 Information: BATCHAGG_SCALE: Row count: 1
2016/9/2 21:56:34 Progress: Processing data set TIMEINTERVALS
2016/9/2 21:56:34 Information: TIMEINTERVALS: Row count: 169
2016/9/2 21:56:34 Progress: Processing data set ACTUALTIMERANGE
2016/9/2 21:56:34 Information: ACTUALTIMERANGE: Row count: 1
2016/9/2 21:56:34 Progress: Processing data set WARNINGS
2016/9/2 21:56:34 Information: WARNINGS: Row count: 1
2016/9/2 21:56:34 Progress: Processing data set BATCHAGGREGATES_TIMEINTERVAL
2016/9/2 21:56:34 Information: BATCHAGGREGATES_TIMEINTERVAL: Row count: 35
2016/9/2 21:56:34 Progress: Processing data set PARTIALAGGS_ORDERBY
2016/9/2 21:56:34 Information: PARTIALAGGS_ORDERBY: Row count: 17
2016/9/2 21:56:34 Progress: Processing data set PARTIALAGGS_GROUPBY
2016/9/2 21:56:34 Information: PARTIALAGGS_GROUPBY: Row count: 3
2016/9/2 21:56:34 Progress: Processing data set DURATION_UNITS
2016/9/2 21:56:34 Information: DURATION_UNITS: Row count: 1
2016/9/2 21:56:34 Progress: Processing data set CURRENT_DB
2016/9/2 21:56:34 Information: CURRENT_DB: Row count: 1
2016/9/2 21:56:34 Information:

ReportViewer Version: 10.0.40219.1 Assembly Info: Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\10.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll 2016/9/1 20:25:58
2016/9/2 21:56:38 Information: Rendering complete
2016/9/2 21:57:02 Information: Handling hyperlink: reporter://data/?%3CMETHOD%20name='OnParametersClick'%3E%3C/METHOD%3E
2016/9/2 21:57:02 Information: Preparing to invoke: OnParametersClick
2016/9/2 21:57:02 Information: Loading resource string: ReadTrace_Main
2016/9/2 21:57:02 Progress: Building parameter list
2016/9/2 21:57:13 Information: Handling hyperlink: reporter://data/?%3CMETHOD%20name='ShowHelp'%3E%3CPARM%3EPerformance%20Overview%3C/PARM%3E%3C/METHOD%3E
2016/9/2 21:57:13 Information: Preparing to invoke: ShowHelp
2016/9/2 21:57:13 Information: Parameter: Performance Overview
2016/9/2 21:57:21 Information: Rendering complete
2016/9/2 21:57:28 Information: Rendering complete
2016/9/2 21:57:32 Information: Rendering complete
2016/9/2 21:57:39 Information: Rendering complete
2016/9/2 21:57:43 Information: Handling hyperlink: reporter://data/?%3CMETHOD%20name=%22ToggleReportParameter%22%3E%3CPARM%3EFShowStartingEvents%3C/PARM%3E%3C/METHOD%3E
2016/9/2 21:57:43 Information: Preparing to invoke: ToggleReportParameter
2016/9/2 21:57:43 Information: Parameter: FShowStartingEvents
2016/9/2 21:57:43 Information: Toggling report parameter: FShowStartingEvents
2016/9/2 21:57:43 Information: Rendering complete
2016/9/2 21:57:46 Information: Handling hyperlink: reporter://data/?%3CMETHOD%20name=%22ToggleReportParameter%22%3E%3CPARM%3EFShowStartingEvents%3C/PARM%3E%3C/METHOD%3E
2016/9/2 21:57:46 Information: Preparing to invoke: ToggleReportParameter
2016/9/2 21:57:46 Information: Parameter: FShowStartingEvents
2016/9/2 21:57:46 Information: Toggling report parameter: FShowStartingEvents
2016/9/2 21:57:46 Information: Rendering complete
2016/9/2 21:57:51 Information: Handling hyperlink: reporter://data/?%3CMETHOD%20name=%22ToggleReportParameter%22%3E%3CPARM%3EFShowCompletedEvents%3C/PARM%3E%3C/METHOD%3E
2016/9/2 21:57:51 Information: Preparing to invoke: ToggleReportParameter
2016/9/2 21:57:51 Information: Parameter: FShowCompletedEvents
2016/9/2 21:57:51 Information: Toggling report parameter: FShowCompletedEvents
2016/9/2 21:57:51 Information: Rendering complete
2016/9/2 21:57:55 Information: Handling hyperlink: reporter://data/?%3CMETHOD%20name=%22ToggleReportParameter%22%3E%3CPARM%3EFShowCompletedEvents%3C/PARM%3E%3C/METHOD%3E
2016/9/2 21:57:55 Information: Preparing to invoke: ToggleReportParameter
2016/9/2 21:57:55 Information: Parameter: FShowCompletedEvents
2016/9/2 21:57:55 Information: Toggling report parameter: FShowCompletedEvents
2016/9/2 21:57:55 Information: Rendering complete