SQL Storedprocedure trace other than profiler
-
To capture what are the Stored procedures are being hit in Production environment the profiler would be used. Whether it would be slowdown the environment? Whether it will affect the performance? If so, what are the alternative to trace the SP hits without affecting the performance?
-
To capture what are the Stored procedures are being hit in Production environment the profiler would be used. Whether it would be slowdown the environment? Whether it will affect the performance? If so, what are the alternative to trace the SP hits without affecting the performance?
Member 3137078 wrote:
Whether it would be slowdown the environment?
AFAIK, it will not affect performance. Profiler is a tool just to track the transactions happening at defined server and not modify any call.
Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Latest Article(s)]: How to extend a WPF Textbox to Custom Picker Server side Delimiters in ASP.NET
-
To capture what are the Stored procedures are being hit in Production environment the profiler would be used. Whether it would be slowdown the environment? Whether it will affect the performance? If so, what are the alternative to trace the SP hits without affecting the performance?
I agree with Sandeep, while it may impact your SSMS app it is only listening to traffic on the server and showing you the content, somewhat like a network sniffer!
Never underestimate the power of human stupidity RAH