Introduction to Express Profiler

Express Profiler:

Express profiler is a tool that we can use with SQL server express edition, Non-express edition and for LocalDB. I love it its very light weight and it won't consume a lot of resources.

We can say it is a simple and fast replacement for SQL Server Profiler and it is compatible with SQL server 2005/08/12/14.

We need to provide Server Name, Authentication type, user name and password and start it.

We can copy all or selected events or copy for Excel to view details later. Its a pretty cool tiny little tool you should try it.

Features given on codeplex:

• Tracing of basic set of events (Batch/RPC/SP:Stmt Starting/Completed, Audit login/logout, User error messages, Blocked Process report) and columns (Event Class, Text Data,Login, CPU, Reads, Writes, Duration, SPID, Start/End time, Database/Object/Application name) - both selectable
• Filters on most data columns
• Copy all/selected event rows to clipboard in form of XML
• Find in "Text data" column
• Export data in Excel's clipboard format

Command-line parameters. 
Can be used to set default GUI values

• -server, -s <server name>
• -user, -u <user name>
• -password, -p <user password>
• -maxevents, -m <value> : set maximum events in event list (1000 by default)
• -duration, -d <min duration> : sets filter on duration column
• -start : automatically start profiling

Plans/Roadmap

• online query normalization
• online extraction of actual query from prepared statements/sp_executesql
• online execution statistics grouped by normalized statements
• save/load captured trace

You can go to http://expressprofiler.codeplex.com/ for more details and documentation or if you're facing any issues regarding expression profiler.