Have you guys seen these blogs from dynaTrace before? They give some pretty good explanations, observations and recommendations on really common low level operations and performance issues in regards to SharePoint. Some examples:

SharePoint: Monitoring individual List usage and performance

SharePoint: Performance Problem with LookupField Control

SharePoint: Identifying memory problems introduced by custom code

SharePoint: More on column index and their performance impact