Expressprofiler

screenshot of Expressprofiler

ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI

Overview:

ExpressProfiler (aka SqlExpress Profiler) is a software program designed as a replacement for SQL Server Profiler. It provides a basic GUI interface and is integrated with the Red Gate Ecosystem project. It supports Express and non-Express editions of SQL Server 2005/2008/2008r2/2012/2014 (including LocalDB).

Features:

  • Tracing of basic set of events: Batch/RPC/SP:Stmt Starting/Completed, Audit login/logout, User error messages, Blocked Process report.
  • Columns: Event Class, Text Data, Login, CPU, Reads, Writes, Duration, SPID, Start/End time, Database/Object/Application name.
  • Filters on most data columns.
  • Copy event rows to clipboard in XML format.
  • Find feature in "Text data" column.
  • Export data in Excel's clipboard format.
  • Command-line parameters for setting default GUI values.

Summary:

ExpressProfiler is a user-friendly replacement for SQL Server Profiler, providing essential tracing functionalities and a basic GUI. It supports various editions of SQL Server and can be used without installation if needed. Additionally, it offers features like data filtering, copying data to clipboard, and command-line parameter support for customization.