Monitor Traffic on a SQL Server End Point/Port

• nawazd1774

  SSC Rookie

  Points: 28

  More actions

  September 28, 2017 at 3:43 pm

  #402545

  Hello,
  I am trying to monitor traffic on an SQL Server endpoint. Basically, I am looking for monitor Logins that use a particular endpoint. Please recommend as to how I can achieve this? I tried the following:
  I created an extended events session and added event [sqlserver].[login]. There are no columns on this event that has the endpoint/port information. There are no action objects nor predicate objects that contain endpoint/port information.
  Please recommend some other ways I could achieve this

• Perry Whittle

  SSC Guru

  Points: 234065

  More actions

  September 29, 2017 at 5:05 am

  #1961575

  you want to see logins that have been granted connect on a database mirroring endpoint, is that correct?

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉