Back to Basics: Least Connections is Not Least Loaded
Published Jan 02, 2013
Version 1.0Was this article helpful?
Instrumentation during dev / QA would be most helpful, even dumping method/function timing / memory use during execution to a log file (that can then be analyzed by tools like splunk) can assist in determining what calls are putting what load on the server.
Profiling tools are also another good option if you're using a language (Java, .NET) that has a good set of options for finding out where time and memory is spent in the code.
There's no good automatic way of determining workload however, it takes some time to gather all the appropriate statistics and then analysis them holistically to determine load per workload type.
HTH
Lori