Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sniffer Pro 4.70.533 SQL-sessions?

Sniffer Pro 4.70.533 SQL-sessions?

Sniffer Pro 4.70.533 SQL-sessions?

I've a problem in my LAN, sometimes freezing sessions to the SQL-server.

SQL uses TCP-port 1433.

I would like to make a "filter" in Sniffer Pro that sniffes only SQL sessions and the eventually cause of the problem ( boradcast's, icmp timeout's etc.).

Can somebodyhelp me?  

RE: Sniffer Pro 4.70.533 SQL-sessions?

Can you do a port monitor on the switchport that connects to the sql server? Do that and capture all traffic to/from the server.

To capture a specific port with sniffer.
Set up a new capture Profile.
Capture > Define Filter > Profiles > New and name the profile.
Click the address tab and select ip and put "any" in the source and destination.
Now click  the address tab and type the port your want.

RE: Sniffer Pro 4.70.533 SQL-sessions?

Ok thank you.

It's a 3COM switch an i think ,"port montitoring" is possible.

What i've to do with the buffer size in Sniffer Pro? I don't want to lose packets during a Sniffer day.

RE: Sniffer Pro 4.70.533 SQL-sessions?

Experiment with the buffer. Or, depending on the info you need to capture, Change the packet size on the buffer tab.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close