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.

All labels observed (4)

Label Occurrences
SQL Server Profiler canonical 3
SQL Server Extended Events Profiler 1
SQL Trace 1

How this entity was disambiguated

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 Server Profiler self-linksurface differs
surface form: SQL:BatchCompleted events

Showplan XML events
deprecatedInVersion SQL Server
surface form: 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
surface form: SQL Server 2000
partOf SQL Server
surface form: Microsoft SQL Server
primaryFunction analyze SQL Server performance
monitor SQL Server events in real time
trace SQL Server activity
recommendedReplacement Extended Events
SQL Server Profiler self-linksurface differs
surface form: SQL Server Extended Events Profiler

SQL Server Management Studio
surface form: SQL Server Management Studio Live Query Statistics
requiresPermission ALTER TRACE
sysadmin fixed server role membership
runsOn Windows
status deprecated feature
supportsPlatform SQL Server Analysis Services
surface form: Analysis Services

SQL Server
surface form: 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

How these facts were elicited

Referenced by (6)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server hasComponent SQL Server Profiler
SQL Server Profiler recommendedReplacement SQL Server Profiler self-linksurface differs
this entity surface form: SQL Server Extended Events Profiler
SQL Server Profiler canCapture SQL Server Profiler self-linksurface differs
this entity surface form: SQL:BatchCompleted events
Extended Events replaces SQL Server Profiler
Extended Events preferredOver SQL Server Profiler
this entity surface form: SQL Trace
Extended Events preferredOver SQL Server Profiler