What profiler to use with sql express? [closed]

F

8

20

is there a way to monitor detail of sql calls in express version?

Frustrated answered 5/3, 2009 at 20:2 Comment(2)

Sadly per all the answers for the free SQL express profiler, it appears to be no longer free, even the open source is "gone". Shoulda archived a copy when I had it. Now's it's a commercial product w/ free trial. – Ingraham 6/7, 2012 at 6:9

See also dba.stackexchange.com/questions/28213/… – Youthen 5/3, 2015 at 11:8

A

35

Try SQL Express Profiler.

I've used it a bit and it seems to work as advertised.

Apatite answered 5/3, 2009 at 20:8 Comment(3)

I'm looking for this now! The asker asked 3 years ago! So, when the answer provider found that and work on that! World is really ahead-ed, I'm really in behind, please you all help me to go upward, Thanks. – Rizzi 28/3, 2012 at 13:58

does this work for SQL server 2016? – Confrere 29/6, 2016 at 19:6

completelyuninstallprogram.com/sqlexpressprofiler-exe say this is trojan. Chrome browser also complain this setup is malicious. Is anything wrong with SQL Express Profiler? – Minnich 21/12, 2016 at 23:34

F

5

As most of the profilers mentioned above seem to be dead or gone commercial, I would like to share what I found some days ago:

SQL Express Profiler

Since CodePlex has been retired, the project moved to GitHub and seems to have no binary download options anymore, so you have to compile it from source code.

I'm currently using it with SQL Server Express 2012 to monitor queries form my NHibernate applications (didn't want to add log4net just for this purpose and show_sql outputs only to console window which I don't have in my WCF service).

Really nice and stable utility. I find it much easier to use than MS SQL Profiler which needs various settings, trace profiles for various server versions and what not. Express Profiler - just launch, hit Run, and all the T-SQL and sp_execute queries are displayed.

It's open source, you can add even more features if you wish. I guess, Clear button would be useful because now you have to Stop and Run again to clear the list.

Frae answered 25/1, 2013 at 12:21 Comment(6)

Oh, this post was edited by someone to replace the free profiler link with the paid one... I guess they have their reasons to do that, but now you'll have to google for express profiler on codeplex. – Frae 5/4, 2013 at 11:28

I've fixed this, @martin - I'm guessing you also wanted to link to express profiler, though if it is some other link you wanted to point to, then please fix it (or mention in comments so one of us can fix it). – Misinterpret 20/12, 2013 at 9:32

Thanks @Roopesh, now it is the right one. – Frae 20/12, 2013 at 10:53

Looks like it is gone now... – Stearic 10/4, 2018 at 6:40

@JayKilleen You can still download the source code and compile it, both from CodePlex archive and also the new GitHub repository. – Frae 13/4, 2018 at 6:37

Cheers I'll give that a go. – Stearic 13/4, 2018 at 7:40

P

2

The mentioned SqlProfiler For Express Edition works fine for development.

But I have not found it always useful in solving production emergencies, like when sqlexpress takes 100% of server processor capacity. I couldn't get the profiler produce any trace in one such case. Perhaps there are similar experiences?

Precedential answered 8/3, 2009 at 10:46 Comment(0)

B

2

Express edition is just the full version with some limitations (2GB ram, 2 cpu cores, 4GB DB), so if you have the tools for the full version, use them. I think the trial version off the MS website will allow you to use the tools - but not the engine - for more than 60 days..... tho there may be an official package of the tools around for express

Bloomery answered 8/3, 2009 at 11:1 Comment(0)

G

2

I have been using AnjLab Sql Profiler for quite some time. I have had no problems with it.

Edit: Here is the link: http://anjlab.com/en/projects/opensource/sqlprofiler

Gregarious answered 23/7, 2012 at 11:29 Comment(0)

I

1

The free SQL profiler others mention appears no longer available. Next best alternative might be something like this:

http://www.codeproject.com/Articles/20173/MS-SQL-Server-Profiler-with-NET

Ingraham answered 6/7, 2012 at 6:18 Comment(0)

L

1

You could rather use SQL Server Extended Events instead of any Profiler. Extended Events are available from within the Express version. There is UI management from SQL Server 2012 under the Management folder of a server in the Object Explorer window.

You can read a good answer on the advantages of using Extended Events over SQL Profiler -which include less performance overhead- at Stack Exchange: https://dba.stackexchange.com/questions/2665/when-should-extended-events-be-used-instead-of-sql-profiler-perfmon

"Extended Events is the future of monitoring & troubleshooting going forward and some day in the future SQL Trace will be removed"

Regards.

Location answered 6/3, 2014 at 19:13 Comment(1)

Not everyone likes to write queries. Even with today's command line approach on the rise (sublime, npm, anyone?), I prefer UI. – Corner 17/5, 2017 at 18:30

W

0

As a developer we can buy SQL Server 2005/08 Developer Edition which is available for $50 or so. It has full featured SQL Profiler and works beyond SQL Server Express SKUs limitations.

If not than use SQL Express Profiler

Hope this helps!

Wandering answered 25/5, 2010 at 14:15 Comment(0)

Recommended topics

Hot tags