SQL Show Server Trace

The Show Server Trace command provides access to information used to determine the server-side impact of a query.  If enabled when a query is executed, the Show Server Trace command displays the Trace pane, which provides information about the event class, subclass, integer data, text data, database ID, duration, start time, reads and writes, and CPU usage.

For more information, please see your SQL Server Books Online.