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
Plans/Roadmap
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.
