ExpressProfiler (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/2008/2008r2/2012 (including LocalDB)

Features
  • Tracing of basic set of events (Batch/RPC/SP:Stmt Starting/Completed, Audit login/logout, User error messages) 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
If you wish to speed up development of specific feature you can vote at https://expressprofiler.codeplex.com/workitem/list/basic


Last edited Sep 11, 2013 at 9:49 AM by ExpressProfiler, version 15