Profiler for SQL Server 2005/2008 Express Edition

During an interaction session with one of my clients, they popped up a question – Is it possible to use a profiler in SQL Server Express Editions to see how queries are being resolved? I had no answer as I knew that SQL Server profiler was not supported on Express Edition

On doing some research, I found a nice tool that lets you profile SQL Express Databases. It’s called “SQL Server 2005/2008 Express Profiler”. SQL Server Express Edition Profiler provides most of the functionality a standard profiler does, such as choosing events to profile, setting filters, etc.

I hope you find the tool useful!

What’s a SQL Server Profiler?

SQL Server Profiler shows how SQL Server resolves queries internally. This allows administrators to see exactly what Transact-SQL statements or Multi-Dimensional Expressions are submitted to the server and how the server accesses the database or cube to return result sets.


About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook

4 comments:

Ovidiu R. said...

Thanks for the link!

Kirste Purt said...

Dude this is an awesome blog!

Anonymous said...
This comment has been removed by the author.
Anonymous said...

This works great when replaying trace results
-Regards