Would it be possible to monitor for a few days every query's execution and
collect the longest execution time (just that) for each different query?

Thanks

You can run a profile trace, capturing the output in a SQL Server
database/table -but not the server you are monitoring. If you have a lot of
traffic, the table can get very large very fast. Use the appropriate
Template. TSQL_Duration is a good choice for a Template to use.

Then you can sort through the captured data in the table isolating the
longest running queries.

You wouldn't be able to easily "collect the longest execution time (just
that) for each different query". How would the system know if any particular
execution will be the longest one until the collect period is finished?

Show quoteHide quote

Spreadsheet totals
Foreign Key may cause multilple cycles
Bulk Insert from Excel
Sort Numbers in Nvarchar As Numbers
How do I filter out unwanted rows by only one different column?