Click here to Skip to main content
Search within:



       

Database

 
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
View All ThreadsFirst Prev Next
QuestionSQL Storedprocedure trace other than profilermemberMember 31370789 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?
Sign In·Permalink
AnswerRe: SQL Storedprocedure trace other than profilermvpSandeep Mewara9 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
Sign In·Permalink
AnswerRe: SQL Storedprocedure trace other than profilermemberMycroft Holmes9 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
Sign In·Permalink
Last Visit: 31 Dec '99 - 18:00     Last Update: 24 May '13 - 3:49Refresh1

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   


Advertise | Privacy | Mobile
Web01 | 2.6.130523.1 | Last Updated 24 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid