在测试结束时将CSV / SQL数据导入VS Load Test结果? [英] Importing CSV / SQL data into VS Load Test results at the end of a test?
问题描述
您好
我有一些非常复杂的SQL,可以从BizTalk的BAM表中收集时间,并且无法编写自定义Perfmon计数器来实时查询它影响BizTalk应用程序数据库。
I have some quite complex SQL that gathers timings from BizTalk's BAM tables and can't write a custom Perfmon counter to query it in real-time without affecting the BizTalk app database.
是否可以将任意计时数据(CSV,SQL,Excel等)作为自定义计数器导入负载测试结果(并绘制图表)在考试结束时?我宁愿不直接破解负载测试结果数据库,是否可以通过公共
API执行此操作?
Is it possible to import arbitrary timing data (CSV, SQL, Excel, etc) into the load test results as a custom counter (and graph it) at the end of a test? I'd rather not hack the load test results database directly, is it possible to do this via the public API?
提前致谢!
Gaz
推荐答案
Hi Gaz,
Hi Gaz,
是的,可以通过诊断数据适配器(数据收集器)实现目标。这里有几个关于此的博客和MSDN链接以获取更多信息。很高兴你决定在论坛上查看负载测试数据库。
Yes, it is possible to accomplish your goal with a Diagnostic Data Adapter(Data Collector). Here are a couple of blogs on this and the MSDN link to more information. Glad you decided to check here on the forums vs. hack the load test database.
将数据收集器数据集成到负载测试分析器/表视图中
http://blogs.msdn.com/b/yutong/archive/2010 /04/08/integrate-data-collector-data-into-load-test-analyzer-tables-view.aspx
http://blogs.msdn.com/b/yutong/archive/2010/04/08/create-a-simple-data-collector-to-integrate-data-into-load-test-analyzer -tables-view.aspx
如何:创建诊断数据适配器
h ttp://msdn.microsoft.com/en-us/library/dd286737.aspx
How To: Create a Diagnostic Data Adapter
http://msdn.microsoft.com/en-us/library/dd286737.aspx
使用Data Collector附加文件以测试结果
http:// msdn.microsoft.com/en-us/library/dd286649.aspx
这篇关于在测试结束时将CSV / SQL数据导入VS Load Test结果?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!