SQL Server Profiler
E56985
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
Aliases (2)
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
database monitoring tool
→
graphical user interface application → |
| accessedVia |
SQL Server Management Studio
→
|
| canCapture |
Deadlock graph events
→
Performance statistics events → RPC:Completed events → SQL:BatchCompleted events → Showplan XML events → |
| deprecatedInVersion |
SQL Server 2012
→
|
| developedBy |
Microsoft
→
|
| documentationURL |
https://learn.microsoft.com/sql/tools/sql-server-profiler/sql-server-profiler
→
|
| hasFeature |
column selection for events
→
event grouping and sorting → event selection and filtering → exporting trace results → filtering by database, user, application, or host → graphical trace definition interface → integration with SQL Server Database Engine Tuning Advisor → pause and resume tracing → saving traces to files → saving traces to tables → server‑side trace script generation → template‑based trace creation → trace replay → |
| introducedInVersion |
SQL Server 2000
→
|
| partOf |
Microsoft SQL Server
→
|
| primaryFunction |
analyze SQL Server performance
→
monitor SQL Server events in real time → trace SQL Server activity → |
| recommendedReplacement |
Extended Events
→
SQL Server Extended Events Profiler → SQL Server Management Studio Live Query Statistics → |
| requiresPermission |
ALTER TRACE
→
sysadmin fixed server role membership → |
| runsOn |
Windows
→
|
| status |
deprecated feature
→
|
| supportsPlatform |
Analysis Services
→
Microsoft SQL Server Database Engine → |
| usedFor |
auditing database activity
→
capturing T‑SQL statements → capturing errors and warnings → capturing login and logout events → capturing query workloads → capturing stored procedure calls → identifying deadlocks → identifying long‑running queries → performance tuning → replaying captured workloads → troubleshooting SQL Server issues → |
Referenced by (3)
| Subject (surface form when different) | Predicate |
|---|---|
|
SQL Server Profiler
("SQL:BatchCompleted events")
→
|
canCapture |
|
SQL Server
→
|
hasComponent |
|
SQL Server Profiler
("SQL Server Extended Events Profiler")
→
|
recommendedReplacement |