What is SQL Server Profiler?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is SQL Server Profiler?
Rating:
SQL Server Profiler is a tool used to monitor and trace events. The events generated can be used to find the slow running queries and to determine the cause of a deadlock and that of slow running queries. The events that are captured by SQL Server Profiler are as follows:
- Login connections, failures, and disconnections
- Transact-SQL statements
- Remote procedure call
- The start or end of a stored procedure and statements within it
- The start or end of a transact-SQL batch
- An error written to the SQL Server error log
- Locks and deadlocks
Rating:
Was this information helpful?
Other articles
- What is the sp_who stored procedure?
- What is a restore job?
- What is a PRIMARY KEY constraint?
- What is a full backup?
- What is SSIS?