March 21, 2010

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, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

4 comments:

Ovidiu Rus said...

Thanks for the link!

Kirste Purt said...

Dude this is an awesome blog!

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

This works great when replaying trace results
-Regards