想了解服务器磁盘的IO吞吐量，用sqlio 工具会不会对当前服务器有影响

Question

如题，谢谢高手指教

Answer 1

如果要监控系统IO，可以使用性能监视器中关于磁盘的监视。

sqlio是用来测试磁盘性能（模拟sql）的，测试的时候会写入读取数据，自然要占用系统资源，这个看实际情况使用。

---

family as water

Answer 2

谢谢回复。

那用sqlio 在生产库测试 ，是不是得到的结果 会不太准确呢，做这个测试 应该在服务器不在线的状态吗？

Answer 3

在那里运行 得到那里的数据。

测试系统上运行这个，个人觉得没有什么意义，除非测试系统具有和正式系统一样的物理环境，实际上很少有这样大手笔的项目。

为了保证测试的结果准确，最好是在没有运行任何其他服务器的裸机上做这个测试，否则测试结果没有多少说服力。

 

---

family as water

Answer 4

I'll not run on prod server if there's no disk i/o issue.

Answer 5

谢谢回复。

那用sqlio 在生产库测试 ，是不是得到的结果 会不太准确呢，做这个测试 应该在服务器不在线的状态吗？

http://blogs.technet.com/b/lobapps/archive/2010/09/27/using-sqlio-to-baseline-performance-tips-and-tricks.aspx

SQLIO Runtime Practices

Avoid busy times when testing

In the best of cases, you want to test your new disk subsystem (or configuration change) while no one or nothing else is accessing it. In the real world, this isn’t always possible. Running SQLIO is EXTREMELY disk intensive, though, so execute it with care when other users are on the system – they WILL notice. And keep in mind that if you’re running SQLIO while another load is concurrently using the disk system, your results will be skewed (lower!), perhaps much lower than what you would have observed otherwise. So do what you can to test off-hours, preferably during a scheduled downtime window or on another non-production disk subsystem identically configured to production (smart customers deploy “staging” or “pre-production” systems to support this kind of promote-to-production change management and testing).

 

Answer 6

谢谢