A legacy SQL Server graphical trace tool used to capture and analyze server events, now deprecated in favor of Extended Events because of its significant performance overhead.
- Event capture: SQL Server Profiler captures events such as query executions, login and logoff activity, locks, errors, and stored procedure calls, storing the results in a trace file or database table.
- Deprecation: SQL Server Profiler is officially deprecated by Microsoft and may be removed in a future SQL Server release. Organizations are encouraged to migrate monitoring and troubleshooting workloads to Extended Events.
- Performance impact: The primary reason for deprecation is its significant performance overhead, which can reach 15–30% in high-throughput environments, compared to the minimal overhead of Extended Events.
- Migration path: The XEvent Profiler in SQL Server Management Studio (SSMS) provides a familiar, Profiler-like live event viewer built on Extended Events, making it the recommended alternative for DBAs.
- Legacy use case: SQL Server Profiler is still useful for replaying captured workloads against a test server for performance regression testing, although Distributed Replay is the modern successor for this scenario.
- Related terms: Extended Events, SQL Server Audit, Performance Monitoring, Distributed Replay.
