SQL Server Profiler will produce a massive amount of output if you do not introduce filtering. The first level of filtering is to select the events to be filtered such as TSQL SQL:BatchStarting and Stored Procedures SP:Starting, RPC:Starting. Once you targeted the events, you can set filters on duration for example to 4,000 (4 sec) and over or on the number of reads at 10,000 and over.

For performance tuning a special template available called “Tuning”. Since this one does not have any column filters, it will accumulate a large trace log in relatively short amount of time. The output of the “Tuning” template is typically used by the Database Engine Tuning Advisor.

Related article:

Step-By-Step: An introduction to SQL Server Profiler By Susan Harkins