0

I'm wondering does running Express Profiler against an SQL Express Server have a major impact on performance. The versions of SQL Express I'm looking to run against are on 2008 and 2013.

This is the express profiler I'm using. http://expressprofiler.codeplex.com/

Improve this question
4
  • 1
    Did you try it? The problem with asking about performance impact of 3rd party tools here is that (a) not everyone here has even heard of that tool (especially since SQL Server's own profiler is now free with Management Studio Express in SQL Server 2012 SP1), (b) those who have heard of it might not have done any performance testing, (c) those who have done performance testing have done so on completely different systems with different usage patterns and probably with completely different traces, and (d) most folks know to use server-side traces rather than graphical tools anyway.
    – Aaron Bertrand
    Commented Dec 5, 2013 at 13:12
  • @Aaron Didn't know that was now free, I'll try downloading it and see how I get on with it. Have you a link on how to use server-side traces?
    – DermFrench
    Commented Dec 5, 2013 at 14:22
  • 3
    You can download Management Studio 2012 SP1 here. Plenty of articles on server-side trace vs. profiler, and why: here, here, here, here...
    – Aaron Bertrand
    Commented Dec 5, 2013 at 15:06
  • 1
    To get you started, Jonathan has some numbers on Measuring “Observer Overhead” of SQL Trace vs. Extended Events
    – Kin Shah
    Commented Mar 10, 2014 at 14:09

1 Answer 1

Reset to default
-1

Performance impact of expressprofiler is almost the same as of standard sql profiler and can be up to 25%

Improve this answer
4
  • Any sources for that statement?
    – vonPryz
    Commented Dec 10, 2013 at 13:04
  • My expirience, observations, lab testing
    – Locky
    Commented Feb 21, 2014 at 14:44
  • 2
    @Locky your environment and OP's environment (workload, server spec, etc) will be totally different and to make a number (as you had --> 25%) will not be correct.
    – Kin Shah
    Commented Mar 10, 2014 at 14:10
  • of course "it depends", but taking into account that ExpressProfiler supposed to use (but not limited to) with SqlExpress - "up to 25% performance degradation" is precise enough definition.
    – Locky
    Commented Mar 11, 2014 at 15:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.