patternsqlModerate
Does SQL profiler affect server performance?
Viewed 0 times
sqlaffectperformancedoesprofilerserver
Problem
I am facing a problem where the sql server 2008 fails for some high load. I need to find that load case and need to optimize the code so that it can handle the load.
I have found on the internet that SQL profiler can be used to track the database interactions which can later be analyzed to find the exact point where the problem occurs.
I have also found as to how we can start the sql profiler.
But now my question is that by starting the sql profiler am i going to affect the server performance?
I have found on the internet that SQL profiler can be used to track the database interactions which can later be analyzed to find the exact point where the problem occurs.
I have also found as to how we can start the sql profiler.
But now my question is that by starting the sql profiler am i going to affect the server performance?
Solution
SQL Server Profiler is a GUI that utilizes SQL Server Trace through the client-side. Due to this nature, yes you can potentially see a mild to severe performance impact depending on the environment.
SQL Server Profiler is suited mainly for a quick glimpse at what is happening on the server (provided the database server can handle the extra latency). It is not intended to be run for long periods of time. For longer traces, use a server-side trace or Extended Events.
SQL Server Profiler is suited mainly for a quick glimpse at what is happening on the server (provided the database server can handle the extra latency). It is not intended to be run for long periods of time. For longer traces, use a server-side trace or Extended Events.
Context
StackExchange Database Administrators Q#17474, answer score: 11
Revisions (0)
No revisions yet.