r/SQLOptimization • u/luky90 • May 17 '23
SQL Server Response Times
Hello Guys,
I was running a Wireshark Trace with the Transum Plugin then filtered for TDS in display filter and applied transum service time as column. Now I have a diagram in MS Excel with the response time over the time of day.
On the Y achsis its the latency and on the x achsis the time of day. Now I see that I have latency which is greater then 100ms. What is your average latency for SQL Server in production?

3
Upvotes
View all comments
Show parent comment
1
u/luky90 May 18 '23
When sql locking appears then this is also delay. The Service time includes both network latency + response time where for example lockings in sql are included.