What profiler to use with sql express?

Question

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

Answer 1

Try: http://sqlprofiler.googlepages.com/.

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

Answer 2

The mentioned SqlProfiler For Express Edition at http://sqlprofiler.googlepages.com/ 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?

Answer 3

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

Answer 4

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: http://sqlprofiler.googlepages.com/

Hope this helps!