I’m seeing around 35–40 queries/sec and I want to know if that’s considered normal or if it usually indicates a performance issue.
Thanks.
Why would lots of queries indicate a performance issue?
Lots of queries per second indicates just that - lots of queries per second.
If the queries are taking a long time, then that could indicate a performance issue (on the DB), or more likely a single query against a particular table being un-optimized due to query structure/lack of indexing/etc.
But "lots of queries" by itself is not a diagnostic criteria of anything other than perhaps a project that could be restructured.
As the saying goes:
2 Likes
The only time I determined queries-per-second to be an issue is a case where a developer put queries tags in a bunch of UDTs. With the default tag group. Oy!
Other than that, what Paul said.
1 Like