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
Profiler might be too much overhead. Try server-side traces instead. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
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.
