Post reply

who's connect using R?

  • 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

     

  • 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.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply