191
Views
2
Comments
Solved
Question on query time on service center General Logs
Question

Hello - I see message logged in General  logs like " xxxxxxxx.sql.query.took:took 3040 ms "

Is this 3040 ms query execution time on server ? or is this the time taken to execute query on SQL server and get the result back ( including network usage time).

Thanks | AG

2019-06-15 21-39-22
Afonso Carvalho
 
MVP
Solution

Hi Ajay,

It's just the query time on the SQL Server. I wasn't too sure since I don't see it spelled out in the documentation, but I tested this by writing a purposefuly slow query and then looking at the logs:


2024-10-13 06-36-41
Ajay Ghosh

Thank you !

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.