SQL Server Performance

User auditing...

Discussion in 'Performance Tuning for DBAs' started by geeth_rajesh, Oct 5, 2005.

  1. geeth_rajesh New Member

    Hi friends..

    When I am running a procedure in LIVE server,the execution times are different each day.
    I want to figure out the ideal time it takes in the server. I also want to do a audit on a daily basis between certain time to find out active sessions and active logins and other info during my procedure exection time.

    How do I do the above task...Need ur inputs...

    Thanks
    Rajesh
  2. Madhivanan Moderator

    Running the Profiler may be useful

    Madhivanan

    Failing to plan is Planning to fail
  3. FrankKalis Moderator

  4. satya Moderator

    If your management is happy to budget for third party tools then choose APEXSQL or Lumigent's tools to audit the activity. Using PROFILER is an alternative but you need allocate more time to assess the traces. There are many posts under this forum discussed about such topic.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page