Database

View All Threads First Prev Next

SQL Storedprocedure trace other than profiler Member 31370789-Jan-13 20:19 Member 3137078 9-Jan-13 20:19  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? Re: SQL Storedprocedure trace other than profiler Sandeep Mewara9-Jan-13 21:22 Sandeep Mewara 9-Jan-13 21:22  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 Re: SQL Storedprocedure trace other than profiler Mycroft Holmes9-Jan-13 21:29 Mycroft Holmes 9-Jan-13 21:29  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

Last Visit: 31-Dec-99 18:00     Last Update: 6-May-24 11:06 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.