在 SQL Server 上重放负载的工具
有没有人遇到过任何可以读取 SQL Server (2005/2008) 跟踪文件并针对另一个数据库执行命令的好工具（最好但不一定是 FOSS）。 我们正在尝试在 SQL 服务器上执行一些性能测试，并希望复制实际负载。
我遇到过但尚未使用：
- JMeter
- ReplayML
最好，应用程序能够使用线程来模拟 SQL Server 上的用户连接和查询执行。
Has anyone come across any good tools (preferably but not necessarily FOSS) that can read a SQL Server (2005/2008) trace file and execute the commands against another database. We are attempting to perform some performance testing on our SQL servers and would like to replicate an actual load.
I have come across but not yet used:
- JMeter
- ReplayML
Preferably, the application would be able to use threading to mimic user connections and query execution on the SQL Server.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
您可以使用 SQL Server Profiler 本身针对另一台服务器重放 SQL Server Profiler 跟踪。
请参阅以下 Microsoft 参考作为起点。
http://msdn.microsoft.com/en-us/library/ms189604.aspx
Quest Software 还有一个名为 Benchmark Factory 的工具，可用于执行 SQL Server 负载测试。
http://www.quest.com/benchmark-factory/
You can replay a SQL Server Profiler trace against another server using the SQL Server Profiler itself.
See the following Microsoft Reference as a starting point.
http://msdn.microsoft.com/en-us/library/ms189604.aspx
Quest Software also have a tool called Benchmark Factory that can be used to perform SQL Server load testing.
http://www.quest.com/benchmark-factory/
实际上，最好的工具之一可以从 Microsoft 免费获得。 RML 实用程序针对 SQL2005 和 SQL2005。 SQL2008和SQL2008是专门为此类测试而设计的。
您可以从 下载这些工具http://www.microsoft.com/downloads/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en
我们使用它们来解决多个性能和锁定问题。
注意：由于 GUI 和跟踪后端交互的方式，使用 SQL Profiler GUI 捕获跟踪文件可能会增加性能问题。 RML 实用程序包括一个脚本，可以直接从 SQL Server 捕获跟踪，而无需使用 GUI。
One of the best tools is actually freely available from Microsoft. The RML Utilities are targeted at SQL2005 & SQL2008 and are specifically designed for this type of testing.
You can download the tools from http://www.microsoft.com/downloads/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en
We have used them to solve several performance and locking issues.
Note: Capturing trace files using the SQL Profiler GUI can add to performance problems due to the way the GUI and Trace backend interact. The RML Utilites include a script that can capture traces directly from the SQL Server without using the GUI.
您可以直接在 SQL Profiler 中重播跟踪文件，尽管我只使用过几次，所以我不知道它有哪些限制。
You can replay trace files directly in SQL Profiler, although I've only used it a couple of times for that, so I don't know what all of the limitations are on it.
团队系统有一个附加组件，您可以在 codeplex 上找到：它称为 ->
sql 负载测试
让我知道这是否适合您。
team system has an add-on that you can find on codeplex: It is called ->
sql load test
Let me know if that works well for you.
我知道这是一个非常老的问题，但经过一段时间的搜索后，我发现了一个新的开源工具。
https://github.com/spaghettidba/WorkloadTools 效果很好
I know this is a really old question but after searching for some time i discovered a new open source tool.
https://github.com/spaghettidba/WorkloadTools which works great