SQL Server Profiler trace - events by type per second

eventsbytypepersecond.sql

SELECT	[TimeSlice] =
			RIGHT(N'0' + CAST(DATEPART(hh, StartTime) AS NVARCHAR(2)), 2)
			+ N':'
			+ RIGHT(N'0' + CAST(DATEPART(n, StartTime) AS NVARCHAR(2)), 2)
			+ N':'
			+ RIGHT(N'0' + CAST(DATEPART(ss, StartTime) AS NVARCHAR(2)), 2)
		, te.name AS [EventType]
		, [EventCount] = COUNT(te.name)
		, [ReadCount] = SUM(Reads)
FROM [YOUR_TRACE_TABLE_SCHEMA].[YOUR_TRACE_TABLE_NAME] AS d
INNER JOIN sys.trace_events AS te
	ON te.trace_event_id = d.EventClass
GROUP BY RIGHT(N'0' + CAST(DATEPART(hh, StartTime) AS NVARCHAR(2)), 2)
			+ N':'
			+ RIGHT(N'0' + CAST(DATEPART(n, StartTime) AS NVARCHAR(2)), 2)
			+ N':'
			+ RIGHT(N'0' + CAST(DATEPART(ss, StartTime) AS NVARCHAR(2)), 2)
		, te.name
ORDER BY [TimeSlice] ASC, te.name ASC;
GO