If I capture an "exec sp_execute" command in SQL Profiler (2012), what exactly does the duration measure? I'm trying to understand whether or not factors outside of SQL Server (network or the client) can effect the duration. So if the duration of one call is higher than that of a similar call, is it correct to say "SQL Server took more time to process that call". Conversely if the duration includes the amount of time it takes the client to read the data, then I can not assume that the problem is on SQL Server (it could have been network or a problem with the client program).
I'm attempting to track down some performance problems, and the answer to this question will hopefully help me determine whether or not the problem is in SQL Server or some other component (network/client/etc.)
In case it makes a difference, I'm talking about executing a very simple select statement like:
SELECT * FROM Customer WHERE Id=? and Product='ABC'
Thanks in advance.