对连接到网络存储设备的数据库进行负载测试
我们正在研究对数据库的 NAS 系统进行压力测试，主要是想了解它可以承受多少滥用以及它对数据库性能的影响有多大。 这是我们的计划
- 我正在构建一个测试工具，它将启动可配置数量的 运行 sql 查询的线程（也可配置，并考虑 让它能够运行多个查询）
- 使用 SQLIOSim 实用程序模拟 SQL Server 活动
- 将大量数据复制到设备上或从设备上复制（同时）
任何人都可以想到我们可以做的任何其他事情（这是可重复的）来放置系统上的负载。
We are looking at stress testing a NAS system for a Database, basically was want to see how much abuse it can take and how much it affects the Database performance. here is what we have planed
- I have a test Tool I'm building that will kickoff a configurable number of
threads that run a sql query (also configurable, and thinking about
having it able to run multiple quires) - using the SQLIOSim utility to simulate SQL Server activity
- Copying very large amounts of Data onto and off of the device (at the same time)
Can anyone think of anything else we could do (that's repeatable) for placing a load on the system.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
您还需要模拟数据库和 NAS 之间的网络条件。 随着越来越多的流量进入网络，其可实现利用率下降，这将严重影响您的性能。
举例来说。 如果 1Gbps 网络上有 50 台计算机，并且网络利用率接近 100%，则数据链路层的数据包冲突和重试意味着您的有效总传输量只是只有两个通信器时可实现的网络潜力的一小部分网络上。 更糟糕的是，随着重试次数的增加，有效负载也会增加。 面对高峰需求，你会得到一个丑陋的反馈循环。
有许多网络流量模拟器和生成器，但恐怕我从未使用过其中任何一个。
You'll also want to simulate network conditions between your database and the NAS. As more traffic hits a network, its realizable utilization drops, and this will seriously affect your performance.
By way of example. If you have 50 machines on a 1Gbps network and the network is approaching 100% utilization, packet collisions and retries at the data link layer mean that your effective total transfer is a fraction of the network potential that would be realized if you had only two communicators on the net. Worse yet, as retries increase, so does effective load. You get an ugly feedback loop in the face of peak demand.
There are a number of network traffic simulators and generators out there, though I'm afraid I've never used any of them.
您可以查看 Pole Position，这是一个通用数据库性能测试套件。
http://www.polepos.org/
You could look at Pole Position, a generic database performance testing suite.
http://www.polepos.org/
根据您希望通过负载测试实现的目标，您可能还需要考虑使用 SQLIO 和 SQLIO。 不仅仅是 SQLIOSim。 SQLIOSim 非常适合压力测试和压力测试。 模拟SQL Server负载& 如果检测到任何 IO 错误，将从绿色变为红色。 尽管 KKline< /a> 提供了一些见解。
如果您想连续执行一项操作（例如大型随机读取或大型顺序写入），则 SQLIO 非常有用。 介于两者之间的任何东西。 它还将为您提供一些有用的输出统计数据，您可以将其绘制成图表并显示出来。 用作比较。
Depending on the goals you wish to achieve with your load testing you may also want to look at using SQLIO & not just SQLIOSim. SQLIOSim is very good for stress testing & simulating SQL Server load & will go from green to red if it detects any IO errors. It's output is a bit cryptic though although KKline gives some insight.
SQLIO is useful if you want to perform one operation continuously such as large random reads, or large sequential writes & anything in between. It will also give you some useful output stats which you can graph & use as a comparison.
您可以尝试 Intel 的 IoMeter
You can try IoMeter from Intel