如何监视SQL Server网络流量 [英] How to Monitor SQL Server Network Traffic
本文介绍了如何监视SQL Server网络流量的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想用Microsoft SQL Server监视每个事务使用的网络流量,例如,当查询在SQL上运行时,请求的大小是多少?通过网络接口传递的响应.
I want to monitor the network traffic used by each transaction with Microsoft SQL Server, for example when a query ran on the SQL what was the size of the request & the response as it passed through the network interface.
是否有任何工具可以做到这一点,尤其是免费工具?
Are there any tools which do this, especially free tools?
推荐答案
Wireshark,在端口1433上捕获捕获:
Wireshark, filter capture on port 1433:
host [your sql server's ip] and port 1433
这篇关于如何监视SQL Server网络流量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文