使用数据库生成的动态 URL 进行负载/压力测试网站
嘿伙计们，我需要加载测试一个网站。该网站根据在查询字符串中接收到的数据提供不同的内容。我在 SQL Server 中有一个巨大的表，其中保存了数百万条记录，其中保存了这些查询字符串。我可以使用的最好的免费负载测试工具是什么？
理想情况下，我更愿意使用 C# 编写脚本，因为我对此很满意，
简而言之，我需要一个可以从 sql server 中的表中读取查询字符串并将其发送到网站的工具
hey guys i need to load test a website. the website serves different content based on what data it receives in query strings. i have a huge table in sql server with millions of records where these query strings are saved. what is the best free load testing tool which i can use for this?
ideally i would prefer if i can script in c# as i am comfortable with the same
in short, i need a tool which can read the query strings from a table in sql server and fire these to the website
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Visual Studio 2010 Ultimate 版有一个很棒的 负载测试套件，我衷心推荐它，只要您负担得起。
您可以通过浏览器记录测试并将它们连接到数据库，而无需编写任何代码，但作为一名编码员，您会欣赏它将这些测试转换为 C# 代码的能力，从而为您提供所需的灵活性。
Visual Studio Ultimate 版本允许您模拟最多 250 个“虚拟用户”，然后您需要获得许可证。这使您能够测试合理的负载。
Visual Studio 2010 Ultimate edition has a great load testing suite and I heartily recommend it, provided you can afford it.
You can record tests through your browser and hook them up to a database without needing to code anything, but being a coder you will appreciate the ability it has to convert those tests to c# code, giving you the flexibility you want.
Visual Studio Ultimate edition allows you to simulate up to 250 "virtual users" before you need to get a licence. This gives you the ability to test to a reasonable load.
大多数负载测试工具都可以在不同程度上处理您所描述的内容。几乎所有这些都可以导入数据并使用它来替换 URL 中的查询参数。在大多数情况下，您需要从数据库中获取数据（通过查询），然后将其作为文本文件导入到工具中。我们的产品（Web Performance Load Tester）就是这样工作的，大多数开源工具（ab、opensta、jmeter 等）也是如此。由于很少有高端工具可以直接查询数据库以获取每次测试开始时所需的数据。如果您的应用程序像您所描述的那样简单，您应该能够找到一个根本不需要任何脚本编写的工具。我不知道任何 C# 负载测试工具 - 您可能需要查看 MS 解决方案（例如 Visual Studio Team Studio，其中包含用于测试的组件）。
Most load testing tool can handle what you describe in varying degrees. Almost all of them can import data and use it to substitute for a query parameter within an URL. In most cases, you'll need to get the data out of the database (via a query) and then import it into the tool as a text file. Our product (Web Performance Load Tester) works this way, as do most of the open-source tools (ab, opensta, jmeter, etc). As few of the higher-end tools can query your database directly to get the data you need at the start of each test. If your application is as simple as you describe, you should be able to find a tool that doesn't require any scripting at all. I'm not aware of any C# load testing tools - you'll probably need to look at the MS solutions for that (e.g. Visual Studio Team Studio, which includes components for testing).