Show TOC

SQL ProfilerLocate this document in the navigation structure

Definition

This is an SQL-specific trace tool that you can use to monitor the database activity. It is based on the SQL Server Profiler functionality provided by transact SQL procedures.

Use

You can invoke this feature with transaction DBACOCKPIT. Then choose Diagnostics → SQL Profiler.

Features

You can start the SQL profiler by using Goto → Create Definition. When you create the trace you can select from a list of preconfigured settings for the event classes to be traced. You can set the trace size or the maximum runtime when creating the trace.