Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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/

share|improve this question
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 Dec 5 '13 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 Dec 5 '13 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 Dec 5 '13 at 15:06
1  
To get you started, Jonathan has some numbers on Measuring “Observer Overhead” of SQL Trace vs. Extended Events –  Kin Mar 10 at 14:09
add comment

1 Answer 1

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

share|improve this answer
    
Any sources for that statement? –  vonPryz Dec 10 '13 at 13:04
    
My expirience, observations, lab testing –  Locky Feb 21 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 Mar 10 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 Mar 11 at 15:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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