who's connect using R?

• EamonSQL

  SSCrazy

  Points: 2307

  More actions

  October 15, 2020 at 1:23 pm

  #3797611

  Hi,

  I look after a server and have users connecting with R who are causing alot of performance issues.

  Is there an easy way to identifying these people.

  any help welcome:)

  Thanks,

  Eamon

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 16, 2020 at 2:10 pm

  #3798003

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• james_salasek

  Grasshopper

  Points: 13

  More actions

  October 22, 2020 at 12:19 pm

  #3800076

  Can't you just run any script to see what users are connected and see what way they are connected.  Below is a script that shows all users connected to a server and what database and program name they are using.

   

  SELECT @@ServerName AS SERVER
   ,NAME
   ,login_time
   ,last_batch
   ,getdate() AS DATE
   ,STATUS
   ,hostname
   ,program_name
   ,nt_username
   ,loginame
  FROM sys.databases d
  LEFT JOIN sysprocesses sp ON d.database_id = sp.dbid
  WHERE database_id NOT BETWEEN 0 AND 4
   AND loginame IS NOT NULL order by hostname