概述:
这个项目包括了基于loadtest result的一组存储过程和reporting servics report.他写包括了一个asp.net app让你方便的删除数据库的一组运行结果和在结果上进行分析.
安装说明:
1.代码下载http://loadtestreports.codeplex.com/
2.整个安装过程见下载的installationGuide.doc英文说明。这里翻译一下:
This document outlines the procedure for setting up the loadtest report generator. The tool has a server and a client component. The serverpart must contain the LoadTest database that is created and used by MicrosoftVisual Studio 2005/2008 Test Suite.
The server components can be installed on a single server orcan be split into separate servers, one containing the LoadTest database andanother that hosts SQL Server Reporting Services (SSRS).
这个工具具有服务和客户端部件,服务部分必须包含通过微软的vsstudio2005/2008测试创建数据库。其实2010也同样适用。
这个服务部能安装在同一个的服务器或者能被拆分成不同的服务器,一个包含loadtest数据库和另外一个sql server reporting services主机
Server:
· Microsoft Windows 2003 Standard /Enterprise with SP2
· Microsoft SQL Server 2005 Standard /Enterprise with SP1 with Mixed ModeAuthentication Enabled (refer Appendixfor more details)
· Microsoft SQL Server 2005 ReportingServices
服务器具有必备条件:
windows2003标准版/企业版带有sp2补丁,实际安装在windows 2008/windows同样适用
sql server 2005标准版/企业版带有sp1补丁,安装时混合模式即sa和windows方式,参见附件了解更新的详情,实际安装在sql server 2008 R2也同样适用
sql server 2005 reporting services,实际使用sql 2008r2 reporting services.
The current user must havepermissions to:
· Create procedures & select datafrom the LoadTest database tables
· Author reports on the SSRS instancewhere the reports will be deployed
· Copy assemblies to the bin folder ofReportServer on the SSRS box
当前用户必须具有的权限:
从loadtest数据库里创建存储过程及选择数据的权限
创建report在ssrs实例因为load test report需要部署在那儿
在ssrs中需要有复制文件的权限
1. 实际安装过程
1)检查reportserver有没有安装好,检查方法:
两个URL能否正常访问.
数据库里增加了report server数据库
对应的目录
注意:
虽然这是两个URL但并不是建立在IIS上,在IIS上也没有该虚拟目录,是用的另一种方式。
2) 安装report sever
若没有安装report sever则需要在现有的数据库里实例中添加,不要再新增加实例,见下图。
点击"New installtion oradd...."
select “add features to an existing instance of …..”
安装完成后,在数据库里没有发现report server数据库,则需要配置一下,见下图
3) 安装存储过程及表
进入下载下来的bin目录,运行cmd,输入批处理:install_scripts.bat 数据库实例,比如install_scripts sql08, 这个实例名取自装有loadtest数据库的实例。因为这些存储过程和表都是添加在loadtest数据库的,在sql2008以后loadtest数据库名安装好后默认是loadtest2010,而这个工具只在loadtest数据库上安装,所以要把loadtest2010改成loadtest。见下图
Batcmd:
install_scripts EPX-V-SERLIU\TEST2012
\
BATCMD
Install_scriptB6D3PFSTOSQL05
4) 发布REPORT
进入bin目录下的loadtestreport目录下,执行批处理:install_report 数据库名 report的url,
例Install_Reports.bat SQL08\SqlExpress http://localhost/ReportServer $SQLExpress
或report server安装在别的服务器上,
则批处理:
Install_Reports.bat SQL08\SqlExpress http://SRSS08/ReportServer $SQLExpress,
实际上数据库名安步骤3的方法取,report url直接从配置report server中取,不会有错,见下图:
Install_Reports.bat EPX-V-SERLIU\TEST2012http://epx-v-serliu/ReportServer_TEST2012
Install_Reports.bat B6D3PFSTOSQL05 http://b6d3pfstosql05/ReportServer
在实际的安装过程中,有出错,见下面,但可以不理会。
D:\tools\VSTSCustomReports\bin\Installer\LoadTestReports>Install_Reports.batEPX
-V-SERLIU\TEST2012http://epx-v-serliu/ReportServer_TEST2012
Parentfolder LoadTestReports created successfully
Datasource LoadTestDatabase created successfully
Report:ComparisonSummary published successfully with no warnings
System.Web.Services.Protocols.SoapException:Error while loading code module: `U
tilities,Version=1.0.0.0, Culture=neutral, PublicKeyToken=81e0fe7aaaf3a0a5'. De
tails:Could not load file or assembly 'Utilities, Version=1.0.0.0, Culture=neut
ral,PublicKeyToken=81e0fe7aaaf3a0a5' or one of its dependencies. The system can
notfind the file specified.
atMicrosoft.ReportingServices.WebServer.ReportingService2005Impl.CreateRepor
t(StringReport, String Parent, Boolean Overwrite, Byte[] Definition, Property[]
Properties, Warning[]& Warnings)
atMicrosoft.ReportingServices.WebServer.ReportingService2005.CreateReport(St
ringReport, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Pro
perties,Warning[]& Warnings)
Report:ErrorSummary published successfully with no warnings
Report:OverlayCountersAcrossLoad published successfully with no warnings
System.Web.Services.Protocols.SoapException:Error while loading code module: `U
tilities,Version=1.0.0.0, Culture=neutral, PublicKeyToken=81e0fe7aaaf3a0a5'. De
tails:Could not load file or assembly 'Utilities, Version=1.0.0.0, Culture=neut
ral,PublicKeyToken=81e0fe7aaaf3a0a5' or one of its dependencies. The system can
notfind the file specified.
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateRepor
t(StringReport, String Parent, Boolean Overwrite, Byte[] Definition, Property[]
Properties, Warning[]& Warnings)
atMicrosoft.ReportingServices.WebServer.ReportingService2005.CreateReport(St
ringReport, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Pro
perties,Warning[]& Warnings)
5)复制utlities.dll到SQL Reporting Service RootFolder>\Reporting Services\ReportServer\bin目录
6) 安装客户端
首先需要安装好IIS,运行vstscustomreporting,安装过程中,需要输入数据库名和登入数据库的用户名密码,若是sa方式,则用户名输入sa及密码,若是windows方式登入则不需要输入用户名和密码,直接ok.安装好后会在IIS中建立web,见下图