Menu
is there a way to monitor detail of sql calls in express version?
628
A new hope: The Extended Events (XE) XE will replace the SQL Profiler in the future versions. By the moment, SQL Server includes Profiler and XE. The XEs is a feature included in SQL Server 2008. It is a lighter option that consumes less resources than the Profiler.
SQL Server Express doesn't include SQL Server Agent, so it's not possible to just create SQL Agent jobs. What you can do is: You can create jobs "manually" by creating batch files and SQL script files, and running them via Windows Task Scheduler.
Free Tool SQL Data Profiler | IDERA.
Try SQL Express Profiler.
I've used it a bit and it seems to work as advertised.
52
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.
35
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
