On a misbehaving application we were seeing 200 transactions per second to a MS SQL Server database when normally there would be approximately 10 queries per second.
To analyse the type of SQL queries received by the server I used ‘SQL Server Profiler’ as follows:
File > New Trace …
Specify that you would like to save the results of the trace to a file:
SELECT 1 – how useful is that query?