SQL Server Admin
T-SQL Articles

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.


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter



 
  Feedback:

comments

4 Responses to "Profiler for SQL Server 2005/2008 Express Edition"
  1. Ovidiu Rus said...
    March 23, 2010 6:10 AM

    Thanks for the link!

  2. Kirste Purt said...
    March 24, 2010 9:41 PM

    Dude this is an awesome blog!

  3. Tom said...
    January 6, 2011 8:41 AM
    This comment has been removed by the author.
  4. Tom said...
    January 6, 2011 8:42 AM

    This works great when replaying trace results
    -Regards

 

Copyright © 2009-2011 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions