带有SQL客户端的网络监视器3.4 [英] Network Monitor 3.4 with SQL Client

问题描述

我正在尝试监控我的机器对SQL服务器进行的调用。 我有网络监视器3.4并已下载SQLServer的Ne​​tworkMonitor解析器。 我认为没有什么是"解析"。 捕获之后，我可以看到所有
日志用于我的调用，但我看到的只是带有一堆垃圾的十六进制详细信息而不是SQL调用。 如何获取已解析的信息？

I am trying to monitor the calls my machine is making to SQL server.  I have Network Monitor 3.4 and have downloaded the NetworkMonitor Parsers for SQLServer.  I don't think anything is "parsing".  After capture I can see all the logs for my calls but all I see is the hex details with a bunch of garbage and not the SQL call that was made.  How do I get the parsed info?

也在过滤器中。 我怎么能打一个。并获得一个过滤器列表，但我无法确定只为SQL客户端调用选择哪个项目。

Also in the filters.  How I can hit a . and get a list of filters but I can't figure out which item to choose for SQL Client calls only.

还有任何可用于网络监视器的教程吗？

Also any tutorials available for Network Monitor that you favor?

谢谢

推荐答案

如果您确定要捕获SQL流量，您可以通过在tcp.port == 1433上过滤来判断。 如果您看到此流量，请确保已选择Windows解析器集。 默认解析器集不解析TDS流量。

If you are sure you are capturing the SQL traffic, which you can tell by filtering on tcp.port==1433.  If you are seeing this traffic, then make sure you have the Windows parser set selected.  The default parser set does not parse TDS traffic.

Paul

这篇关于带有SQL客户端的网络监视器3.4的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！