You can't. SQL Server Profiler is a bit restricted in the way it displays and filters data.
You would be better off storing the traced data into a separate table on the same server and then querying the data at given intervals. The big benefit being you have the data in the table and can perform any complex
SELECT statement you wish. Ensure you don't capture too much data by specifying one or two filter criteria.
You could also consider running the SQL Server Profiler from the command prompt which will reduce the overhead of displaying the data constantly in an interface.
The parameters are:
SQL Server Profiler
[/S<SQL Server instance name>]
[/A]<Analysis Services instance name>
[/B<trace table to load>]
[/E] trusted connection
[/F<trace file to load>]
[/T<template file to load or use when starting a new trace>]
[/M<trace stop time>]
[/O<trace output file name>]
[/Z<maximum output file size (MB)>]
[/R<use rollover files>]
Reference: Profiler (Microsoft Docs)
- You would create a template for your standard profiling and use this in the command-line startup
- Start SQL Profiler via command-line referencing your template
- Query data stored in table
Seeing as you might be looking at a migration in the near future and because SQL Server Profiler is going out of fashion as mentioned by Microsoft, you could consider bringing your skills up-to-date by looking at Extended Events.
We are announcing the deprecation of SQL Server Profiler for Database Engine Trace Capture and Trace Replay. These features are available in SQL Server 2016 but will be removed in a later version.+
The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects will also be deprecated.
Reference: SQL Server Profiler (Microsoft Docs)
Extended Events is a light weight performance monitoring system that uses very few performance resources. Albeit with the slight drawback that there was no GUI for SQL Server 2008 (ok, there is an add-on for SSMS, which can be found on codeplex.)
An introduction into Extended Events can be found on Microsoft's site.