SQL Server Express is a free edition of Microsoft SQL Server family that although fully functional, it has some technical limitations like maximum database size per database. It also has some features missing from paid editions. One of those features not available with Express edition is SQL Profiler. In this post I will list the alternative tools for SQL Profiling that can be used with either SQL Server Express or can be used as the SQL Express replacement.
For me the need for SQL Profiler became apparent when I was playing with Entity Framework and started to use LINQ To Entity Queries.
I started to wonder what kind of SQL statements my LINQ syntax generates and this is where SQL Profiler comes into play as it provides the ability to inspect SQL statements that are sent to the database.
Since paid editions of Visual Studio cost so much, I looked on the web if there are some cheaper or even free alternatives to SQL Profiling.
This is what I found:
SQL Server Developer Edition
One alternative is to replace SQL Server Free Edition with SQL Server Developer Edition. It is basically a fully working SQL Server Enterprise Version with all the features included like SQL Agent and SQL Profiler, but you are limited to use it only for development and testing. You can download it for free at this Microsoft page.
ExpressProfiler
ExpressProfiler (aka SqlExpress Profiler) is a simple open source replacement for SQL Server Profiler with basic GUI. It supports both SQL Express and non-Express Editions.
Real-time Tracing With SQL Server Express
This is a desktop application on CodeProject written in C# and .NET 4 in 2014. It supports tracing with SQL Server Express in real-time much like SQL Server Profiler. The application was tested with SQL Server 2008 R2 Express and SQL Server 2012 Express.
I would thank the commentators below guest and mDude for suggesting some of the alternatives mentioned here. If you know of any other alternatives for SQL Profiling, let me know and I will add them to the list.
guest
June 24, 2013ExpressProfiler (aka SqlExpress Profiler) is a simple but good enough replacement for SQL Server Profiler with basic GUI
No requirements, no installation.
Can be used with both Express and non-Express editions of SQL Server 2005/20082008r2/2012 (including LocalDB
mDude
June 25, 2014I was looking for an alternative too. The ExpressProfiler works well. Its not as configurable as I wanted. Sql ExpressTrace works nicely, this article has a compiled UI and code too: http://www.codeproject.com/Articles/784905/Real-time-Tracing-With-SQL-Server-Express
admin
July 23, 2022The link doesn't exist anymore as CodePlex has shut down. I'm guessing it is this tool:
https://github.com/ststeiger/ExpressProfiler