SQL Server Performance

Traceout User

Discussion in 'Getting Started' started by reethu, May 20, 2009.

  1. reethu New Member

    Hi got kind of situation,
    we have one sql user on the database now we need to figureout who is actually using it because we plan to delete it but not known exactly who is using it from application end. what is the best way to do it or trace it out using profiler or any other way to figureout it.
    I Need to know which applications are using it actively
  2. madhuottapalam New Member

    Profiler with proper filters is the best option available.
    Madhu
  3. satya Moderator

    What I done in the past is keep the database in READONLY for 3 weeks or so, if no complaints on updates/inserts/deletes then go ahead to keep in SINGLE-USER for next 3 weeks, so if no further complaints it is good to drop it.
  4. reethu New Member

    I Cannot take the database into single user mode or readonly mode. because this databases are actively used
    But my problem is need to figureour which applications are connecting to server.
    i am using in the profiler , hostname loginname and application name ,
    i can see host name but really icannot say which applicationis it using
    in the application it shows me like .net sqlclient data provider.
    jtds or Mocrosoft@windows @operatin system.
    it would not help me at all
    do we have any column filter to find out the actuall application touching ti.

Share This Page