Simple select * query and return the time it took to execute

Set up a SAM SQL User Experience Monitor, give it creds that can access the db, voila

SQL Server User Experience monitor

Hello and thanks for the reply

This is exactly what I have done until now, and I get error "Unable to convert query result", probably because the query returns a lot of rows and not a simple number

Is there a way to bypass it? I am not interested in the results, but only in the time that it took to execute

Thanks in advance

turn it into a count(*)?

Not good, it optimizes the query and it returns the result very quickly

IIRC you might be able to just throw your whole query in there as normal and just rig it up so that column 1 is an integer, maybe something like

select 1, * from table

In the past I remembered that it would basically just ignore anything outside row1 column1 (stat) column2 (message)

Good morning

It looks that this did the trick. Thanks a bunch

Minor additional question:The query returns a response in one quarter of time than it does in Management Studio. Any ideas why this happens

Off the top of my head maybe something like caching from previous requests, or if you used an agent on the SQL server maybe the agents report a faster response time with no network overhead, maybe you ran the SSMS queries from a different network location than the orion poller? Just guesses.